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.

Symptoms

 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
java.lang.NullPointerException
at java.lang.String.<init>(String.java:152)
at com.ofs.aai.pr2.util.PR2Logger.createLogFile(PR2Logger.java:157)
at com.ofs.aai.pr2.util.PR2Logger.createLogFile(PR2Logger.java:273)

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.
java.io.FileNotFoundException: /APPS/ofsaa/weblogic12/Oracle/Middleware/user_projects/domains/OFSAA/applications/OFSAADEV.ear/OFSAADEV.war/logs/ruleexecution/DynamicFilename (No such file or directory)
at java.io.FileOutputStream.open0(Native Method)
at java.io.FileOutputStream.open(FileOutputStream.java:270)

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution


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