This documentation supports the 19.02 version of Remedy IT Service Management Suite.

To view the latest 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
  2. Edit the file and specify path for the arjdbc_query.log and arjdbc_misc.log settings.
    The contents of the file might look similar to the following:


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