My Oracle Support Banner

Unable to view SQL statement preview for Rules (Doc ID 2331934.1)

Last updated on MARCH 02, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 to 8.0.5 [Release 8]
Information in this document applies to any platform.


 On opening a rule from the RRF screen in view or edit mode, the SQL query cannot be viewed on clicking the 'Preview' button. A blank window with the following message is displayed:
"[16600] Error Occurred. Please contact your System Administrator for more information."

The following error is seen in the PR2Service.log:
[PR2LOG] Nov 22,17 10:35:31 : [PR2SERVLET][handleRequest] Error in handleRequest
at java.lang.String.<init>(
at com.ofs.aai.pr2.util.PR2Logger.createLogFile(
at com.ofs.aai.pr2.util.PR2Logger.createLogFile(

Also, the following error is seen in the web server's nohup.out:
[PR2Logger]:Logger is null for RULEEXECUTION
[PR2Logger]: Log4j Config File:/APPS/ofsaa/weblogic12/Oracle/Middleware/user_projects/domains/OFSAA/applications/OFSAADEV.ear/OFSAADEV.war/conf/PR2Logger.xml
log4j:ERROR setFile(null,false) call failed. /APPS/ofsaa/weblogic12/Oracle/Middleware/user_projects/domains/OFSAA/applications/OFSAADEV.ear/OFSAADEV.war/logs/ruleexecution/DynamicFilename (No such file or directory)
at Method)


This issue is not caused by any specific change; however it may occur if the deployed location logs are cleared incorrectly.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.