Symptoms
One or more SQL Macros macros return the following error:
| Code Block |
|---|
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user) |
Cause
The Data Source data source is unable to authenticate the specified database.
Resolution
You have entered the wrong username wrong username or password in the Application server configuration (server.xml).