My Oracle Support Banner

SQL Rule Screen Fails to Load After Upgrade to OFSAA 8.1 with Error on LookupServices.xml (Doc ID 2769943.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 to 8.1.0.2.0 [Release 8.1]
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 to 8.1.0.1.0 [Release 8.1]
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 to 8.1.0.1.0 [Release 8.1]
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 to 8.1.0.1.0 [Release 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After installing or upgrading to Oracle Financial Services Analytical Applications (OFSAA) 8.1, the SQL Rule screen fails to load.

The following error exists in the FUSIONSUBSYSTEMSService.log in the web server's OFSAA log directory:

[16-10-20 18:58:53,395 GMT PM] [INFO ] [WEB] [AMHM] [NA] [SQLRULESERVICECLIENT] Exception occur to run SQLRules.java.io.FileNotFoundException: /<Tomcat Home>/webapps/<context>/conf/LookupServices.xml (No such file or directory)
[16-10-20 18:58:53,395 GMT PM] [ERROR] [WEB] [AMHM] [NA] [SQLRULESERVICECLIENT]
java.io.FileNotFoundException: /<Tomcat Home>/webapps/<context>/conf/LookupServices.xml (No such file or directory)
       at java.io.FileInputStream.open0(Native Method)
       at java.io.FileInputStream.open(FileInputStream.java:195)
       at java.io.FileInputStream.<init>(FileInputStream.java:138)
       at java.io.FileInputStream.<init>(FileInputStream.java:93)
       at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:90)
       at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:188)


This prevents you from using a SQL Rule.

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
Cause
Solution
References


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