Enabling debugging traces for a Live ETL job failure in SAS® Infrastructure for Risk Management


This SAS KB article provides steps to enable debug traces for SAS Infrastructure for Risk Management Live ETL job failures in Linux and Microsoft Windows operating environments.

For Windows Operating Environments:

  1. Open the sas.log4j.properties file that resides in the SASHOME\SASFoundation\9.4\tkjava\sasmisc\ directory. In that file, change the log4j.logger.com.sas= property so that it has the following values:

log4j.logger.com.sas=TRACE, A1

2. Open the SASIRMServer-log4j file that resides in the SAS-configuration-directory\Lev1\Web\Common\LogConfig\ directory and locate the following code:

<!-- SAS: IRM Solutions -->
<logger name="com.sas.solutions.risk.irm" additivity="false">
   <level value="INFO" />
   <appender-ref ref="SAS_FILE"/>
   <appender-ref ref="SAS_CONSOLE"/>
</logger>

Change that code so that it looks like the following:

<!-- SAS: IRM Solutions -->
<logger name="com.sas.solutions.risk.irm" additivity="false">
   <level value="DEBUG" />
   <appender-ref ref="SAS_FILE"/>
   <appender-ref ref="SAS_CONSOLE"/>
</logger>

3. Stop and restart SASServer8_1.

4. Reproduce the problem with the Live ETL job, and collect the following log data:

For Linux Operating Environments:

  1. Open the sas.log4j.properties file that resides in the SAS_HOME/SASFoundation/9.4/misc/tkjava directory. In that file, locate the log4j.logger.com.sas= property and change the values to those that are shown below:

log4j.logger.com.sas=TRACE, A1

2. Open the SASIRMServer-log4j file that resides in the SAS-configuration-directory/Lev1/Web/Common/LogConfig/ directory. Locate the following code lines:

<!-- SAS: IRM Solutions -->
<logger name="com.sas.solutions.risk.irm" additivity="false">
   <level value="INFO" />
   <appender-ref ref="SAS_FILE"/>
   <appender-ref ref="SAS_CONSOLE"/>
</logger>

Change those lines so that they look like the code below:

<!-- SAS: IRM Solutions -->
<logger name="com.sas.solutions.risk.irm" additivity="false">
   <level value="DEBUG" />
   <appender-ref ref="SAS_FILE"/>
   <appender-ref ref="SAS_CONSOLE"/>
</logger>

3. Stop and restart SASServer8_1.

4. Reproduce the problem with Live ETL job, and collect the following log data: