Enabling debugging traces for performance issues with SAS® Government and Compliance Manager database queries


This SAS KB article provides steps to enable debugging traces for performance issues with SAS Governance and Compliance Manager database queries in Linux and Microsoft Windows operating environments.

For Linux Operating Environments  

1. Edit the system.properties file within WebDAV Repository, as follows:

  1. Execute the DAVTree.sh script that resides in SAS-configuration-directory/Lev1/Web/Utilities/./ to open the Java DAVTree utility.

    Note: Under Linux, you need to have the X11 Display export enabled.

  2. In the DAVTree utility, select File ► Open and enter the following URL: http://server:port/SASContentServer/repository/default (or, use HTTPS rather than HTTP, if appropriate).

  3. Next, select sasdav ► Products ► SASRiskGovernanceFramework ► RiskGovFrwkMid-Tier ► rgf-system ► Config. Right-click the system.properties file and select Edit to open the file for editing.

  4. In the system.properties file, change the value of the monitor.db.show_sql= property to true, as shown below. Then save the updated file.
# Controls whether SQL logging is enabled (default=false) 
monitor.db.show_sql=true 

Also, make sure that the following parameter is set in the system.properties file:

monitor.http.xframeoptions=SAMEORIGIN 

2. Enable additional performance traces for the SAS® Infrastructure for Risk Management web application server SASServer8_1 by completing the steps below

  1. Stop SASServer8_1 by submitting the following command:
    SAS-configuration-directory/Lev1/Web/WebAppServer/SASServer8_1/bin/./tcruntime-ctl.sh stop
  2. Make a backup of the SASRiskGovernanceFrameworkMidTier-log4j.xml file that resides in the SAS-configuration-directory/Lev1/Web/Common/LogConfig/ directory.


c. Edit SASRiskGovernanceFrameworkMidTier-log4j.xml by appending the following code:

<category additivity="false" name="com.sas.oprisk.server.perf">
   <priority value="DEBUG" />  
   <appender-ref ref="SAS_CONSOLE" />  
   <appender-ref ref="SAS_FILE" />  
</category>  

d. Archive the logs from the following locations:


e. Restart SASServer8_1 by submitting this command:

SAS-configuration-directory/Lev1/Web/WebAppServer/SASServer8_1/bin/./tcruntime-ctl.sh start

f. Reproduce the SAS® Government and Compliance query performance issue, and collect the following set of trace log data for further review:
 

For Microsoft Windows Operating Environments

1. Edit the system.properties file within WebDAV Repository, as follows

  1. Execute the DAVTree.bat script that resides in SAS-configuration-directory\Lev1\Web\Utilities\ to open the Java DAVTree utility.

  2. In the DAVTree utility, select File ► Open and enter the following URL: http://server:port/SASContentServer/repository/default (or, use HTTPS rather than HTTP, if appropriate).

  3. Select  sasdav ► Products ► SASRiskGovernanceFramework ► RiskGovFrwkMid-Tier ► rgf-system ► Config. Right-click the system.properties and select Edit to open the file for editing.

  4. In the system.properties file, change the value for the monitor.db.show_sql= property to true, as shown below. Then save the updated file.
# Controls whether SQL logging is enabled (default=false)
monitor.db.show_sql=true>

Also, make sure that the following parameter is set in the system.properties file:

monitor.http.xframeoptions=SAMEORIGIN

2. Enable additional performance traces for SAS Infrastructure for Risk Management web application's SASServer8_1 by completing the steps below:

    1. Stop the SASServer8_1 web application server from the Windows Task Manager.

    2. Make a backup of the SASRiskGovernanceFrameworkMidTier-log4j.xml file that resides in the SAS-configuration-directory\Lev1\Web\Common\LogConfig\ directory.

    3. Edit SASRiskGovernanceFrameworkMidTier-log4j.xml by appending the following code:
      <category additivity="false" name="com.sas.oprisk.server.perf">
         <priority value="DEBUG" />
         <appender-ref ref="SAS_CONSOLE" />
         <appender-ref ref="SAS_FILE" />
      </category>
    4. Archive the logs from the following locations:
       
        • SAS-configuration-directory\Lev1\Web\WebAppServer\SASServer8_1\logs

        • SAS-configuration-directory\Lev1\Web\Logs\SASServer8_1

    5. Restart SASServer8_1 from the Windows Task Manager.

    6. Reproduce the SAS Government and Compliance query performance issue, and collect the following set of trace log data for further review: