This documentation supports the 20.02 version of Remedy Smart Reporting.

To view an earlier version, select the version from the Product version menu.

Configuring AR System JDBC log settings

As an administrator, you can enable AR System JDBC (ARJDBC) logging in Remedy Smart Reporting to track the ARJDBC related issues. By default, the ARJDBC logging is disabled because it generates huge data and can lead to performance issues.

To configure the ARJDBC log settings

  1. Create a file and save it as ARJDBCLog.properties.
  2. Edit the ARJDBCLog.properties file and specify path for the arjdbc_query.log and arjdbc_misc.log settings.
    The contents of the ARJDBCLog.properties file might look similar to the following:

    arjdbc_query.log=C:/JDBC_LOGS/query.log

    arjdbc_misc.log=C:/ JDBC_LOGS/info.log

  3. Copy the file to the following locations:

    • The process folder that loaded the ARJDBC driver: <SR_Install_Dir>/appserver/bin
    • The folder pointed by the java.io.tmpdir environment variable. If the environment variable is not defined, copy the file to the <SR_Install_Dir>/appserver/temp directory.
  4. Log in to Remedy Smart Reporting as an administrator.

  5. Select Admin Console > Data Sources > AR System.
  6. In the Custom Parameters section, at the end, add logging = true.
    For example, refreshCache=10;DateTimeFormat=MM/dd/yyyy hh:mm:ss a;DateFormat=yyyy-MM-dd;logging=true;
  7. Restart the Tomcat server.
Was this page helpful? Yes No Submitting... Thank you

Comments