Data source connection logs


Consult this topic to see the logging information of data source connections. When you enable debugging for the data source connections, the related logs are captured in the source.<datasourceID>.log file located at C:\<reportinginstalldir>\Tomcatdir\logs.

Logs for volatile data source connections

The following sample shows the entries that are logged for volatile data sources:

2020-07-31 07:41:24 NOTICE: [82345] Volatile Timeout: 3000
2020-07-31 07:41:24 NOTICE: [82345] Volatile Retries: 500

The following log samples show the retry counts that are logged when the connection drops within the time configured while enabling volatile data source setting:

Volatile Source is not available on attempt 1 (of 500)
2020-07-31 07:56:59 DEBUG: [82345] Connection Error: Cannot load connection class because of underlying exception:
'java.sql.SQLException: ERROR (90): Cannot establish a network connection to the AR System server; Connection refused: connect '.

2020-07-31 07:57:02 DEBUG: [82345] Volatile Source re-attempt: 2 (of 500)
2020-07-31 07:57:04 DEBUG: [82345] Volatile Source is not available on attempt 2 (of 500)
2020-07-31 07:57:04 DEBUG: [82345] Connection Error: Cannot load connection class because of underlying exception:
'java.sql.SQLException: ERROR (90): Cannot establish a network connection to the AR System server; Connection refused: connect

The following log samples show the entries logged when the connection restores within the time configured while enabling volatile data source setting:

2020-07-31 08:08:25 DEBUG: [82345] Volatile Source re-attempt: 134 (of 500)
2020-07-31 08:08:26 INFO: [82345] Created Connection[0]

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*