This SAS KB article describes how to enable SQL logging in the SAS Fraud Management web application SASServer8_1.

To set up debug mode, complete the following steps:

1. Copy or create a symbolic link of the following JAR file in the !SASConfig/Lev1/Web/WebAppServer/SASServer8_1/lib directory so that the SQL statements will be recorded in !SASConfig/Lev1/Web/Logs/SASServer8_1/SASFraudMgmtMid-Tier6.2<authdomain>.log:
   

   cd !SASConfig/Lev1/Web/WebAppServer/SASServer8_1/lib

   ln -s !SASHome/SASVersionedJarRepository/eclipse/plugins/log4j-slf4j-impl_2.17.2.0_SAS_20220620150649/log4j-slf4j-impl.jar log4j-slf4j-impl.jar

   Output:

   log4j-slf4j-impl.jar -> !SASHome/SASVersionedJarRepository/eclipse/plugins/log4j-slf4j-impl_2.17.2.0_SAS_20220620150649/log4j-slf4j-impl.jar
   
   

2. Insert the following logger in !SASConfig/Lev1/Web/Common/LogConfig/SASFraudMgmtMidTier6.2<authdomain>-log4j.xml:

   <Logger name="com.sas.finserv" level="DEBUG" additivity="false">

   <AppenderRef ref="SAS_FILE"/>

   </Logger>
   
   

3. Restart SASServer8_1.
   

   cd !SASConfig /Lev1/Web/WebAppServer/SASServer8_1/bin

   ./tcruntime-ctl.sh restart

!SASConfig/Lev1/Web/Logs/SASServer8_1/SASFraudMgmtMid-Tier6.2<authdomain>.log should now contain the SQL statements.