Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Symptoms

One or more SQL macros return 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

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

Image Removed

Include Page
SUPPORT:How to resolve the Unable to connect to database error
SUPPORT:How to resolve the Unable to connect to database error