Known Issue - Data Source Not Found

Symptoms

One or more SQL Macro returns the following error:

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. 

Known Issue - Unable to Connect to Database

Symptoms

One or more SQL Macro returns the following error:

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).