java.io.FileNotFoundException: compileschema.sql (No such file or directory) Errors Installing FSDF 7.3 (Doc ID 1581219.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Financial Services Data Foundation - Version 7.3 to 7.3 [Release 7]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Data Foundation (FSDF) previously known as Oracle Financial Services Data Warehouse (FSDW) 7.3, when attempting to run the FSDF installer, the following errors appear in the installer log:

ERROR

[Fri 30/8/2013 01:05:29] [OFSDW] [ INFO] - Successfully saved XML document by name :/dprod01/oradata/ofsaai/ftpshare//etlapphome/ETLRepository.xml
[Fri 30/8/2013 01:05:29] [OFSDW] [ INFO] - Updating the existing TFM file with source TFM file...
[Fri 30/8/2013 01:05:29] [OFSDW] [ERROR] - =====Exception====
java.io.FileNotFoundException: /dprod01/oradata/ofsaai/ftpshare/INDOMOFSAAI/new/INDOMOFSAAI_TFM.XML (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:120)
at java.io.FileInputStream.(FileInputStream.java:79)

[...]

[Fri 30/8/2013 01:06:15] [OFSDW] [ INFO] - Compiling all objects in application schema.
[Fri 30/8/2013 01:06:15] [OFSDW] [ERROR] - =====Exception====
java.io.FileNotFoundException: /herramientas/oraofsa/product/ofsaai.7.3/scripts/compileschema.sql (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:120)
at java.io.FileInputStream.(FileInputStream.java:79)
at java.io.FileReader.(FileReader.java:41)
at com.ofss.fsgbu.installer.common.DBManager.ExecuteFile(DBManager.java:108)
at com.ofss.fsgbu.installer.postinstall.EndSol.install(EndSol.java:55)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaeg.run(DashoA10*..)
[Fri 30/8/2013 01:06:15] [OFSDW] [ERROR] - =====Exception====
java.io.FileNotFoundException: /herramientas/oraofsa/product/ofsaai.7.3/scripts/compileschema.sql (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:120)
at java.io.FileInputStream.(FileInputStream.java:79)
at java.io.FileReader.(FileReader.java:41)
at com.ofss.fsgbu.installer.common.DBManager.ExecuteFile(DBManager.java:108)
at com.ofss.fsgbu.installer.postinstall.EndSol.install(EndSol.java:55)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)


The issue can be reproduced at will with the following steps:

1. Install OFSAAI
2. Attempt to install FSDW

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms