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:
" 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
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)
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