OFSAA Patch 6.x Installation Fails with Errors Applying Service Pack (Doc ID 1484414.1)

Last updated on JANUARY 21, 2015

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Asset Liability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.x

Symptoms

On Oracle Financial Services Funds Transfer Pricing (FTP) 6.0.2 when attempting to apply the 6.0.2 FTP service pack after successfully applying OFSAAI 7.3.1.0.0 and OFSAAI 7.3.1.0.4, the following error occurs in the AplicationService.log:

ERROR
[ 14/08/2012-03:22:15 ] ----- Reading the existing FusionMenu.xml : /oracle/ofsaa/ofsaa/ofsaa73/ficweb/webroot/WEB-INF/props/OFSAADOM
_FusionMenu.xml

============================== EXCEPTION ==============================
[ 14/08/2012-03:22:15 ] ----- Exception occured in File: <FusionMenuUpdation.java> Class: <com.ofss.fsgbu.servicepack.FusionMenuUpdation> Method: <main> Line: <26>
java.io.FileNotFoundException: /oracle/ofsaa/ofsaa/ofsaa73/ficweb/webroot/WEB-INF/props/OFSAADOM
_FusionMenu.xml (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:70)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:161)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(XMLEntityManager.java:653)
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(XMLVersionDetector.java:186)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:771)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
at org.jdom.input.SAXBuilder.build(SAXBuilder.java:518)
at org.jdom.input.SAXBuilder.build(SAXBuilder.java:986)
at com.ofss.fsgbu.servicepack.TFMMerger.loadXML(TFMMerger.java:138)
at com.ofss.fsgbu.servicepack.FusionMenuUpdation.main(FusionMenuUpdation.java:26)
============================== EXCEPTION ==============================

[ 2012.08.14-03.21.33 ] ----- Oracle Version is : Oracle11gR2
[ 2012.08.14-03.21.33 ] ----- Taking backup of Database layer ...
[ 2012.08.14-03.21.33 ] ----- Backing up  /oracle/ofsaa/ofsaa/ofsaa73/ficdb/bin to /oracle/ofsaa/ofsaa/ofsaa73/FTP_OFSAADOM
_2012.08.14-03.21.33
[ 2012.08.14-03.21.33 ] ----- Backing up  /oracle/ofsaa/ofsaa/ofsaa73/ficdb/lib/libFSGBU to /oracle/ofsaa/ofsaa/ofsaa73/FTP_OFSAADOM
_2012.08.14-03.21.33
[ 2012.08.14-03.21.33 ] ----- Updating DB Layer Files
[ 2012.08.14-03.21.33 ] ----- Preparing the SQL Scripts
[ 2012.08.14-03.21.33 ] ----- Error while retrieving the DB Layer IP
[ 2012.08.14-03.21.33 ] ----- ERROR: ORA-01017: invalid username/password; logon denied SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus


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

1. Run 6.0.2 FTP service pack installer
2. Find errors in AplicationServicePack.log

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