Known Issues
Symptoms
One or more SQL Macro returns the following error:
| Code Block |
|---|
Error rendering macro 'sql-query' : Data source '<NAME>' not found. |
Cause
Your SQL Macro is referencing an incorrect Data Source Profile name (or) the Data Source Profile has been removed.
Resolution
Check the Data Source Profile listing to see if the Data Source Profile name matches the dataSource name within your SQL Macro.
Unable to Connect to Database
Symptoms
One or more SQL Macro returns the following error:
| Code Block |
|---|
Error rendering macro 'sql-query' : Unable to connect to database using jdbc:mysql://<HOSTNAME>:<PORT>/<DBNAME> with user <USER> |
Cause
Your SQL Macro is referencing a Data Source Profile that has one or more incorrect connection configurations.
Resolution
Double check the connection information associated with this Data Source Profile (Hostname, Port, Database, Username, and Password).