Troubleshoot Application Server Based Data Sources - 11.x
Description
This page lists the most common errors and examples. The resolution steps for data source profiles or application server based data sources (application server) might differ. In most cases, you will see common error messages like Error rendering macro 'sql' or Error rendering macro 'sql-query'
- Access denied - 11.x
- Data source name not found - 11.x
- Class not found - 11.x
- Validation query throwing exception - 11.x
- Could not connect to database server - 11.x
- Authentication failed - 11.x
- Broken connections - 11.x
- Invalid database port - 11.x
- Listener refused connection - 11.x
- No JDBC driver - 11.x
- Database server not found - 11.x
- isValid exceptions - 11.x
- Generic SQL exception - 11.x
- Validation query throwing Oracle exception - 11.x
- User authority - 11.x
Double check the configuration values and verify if your JDBC driver is installed in the correct location.
Make sure you restart Confluence after you make configuration changes to server.xml or an equivalent application server (if you are using a different application server).
Make sure your database is configured using remote access to the Confluence server with a user name and password (Need to check this). If you face any problems, connect using an independent SQL client from the server to verify the access. Consult your database documentation to know how to configure remote access and database permissions.
Need support? Create a request with our support team.