Installation of FTP 8.0.2 Fails With Errors Due to Invalid ETLRepository.xml
(Doc ID 2424788.1)
Last updated on MARCH 02, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 and laterInformation in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
Several errors occurred in OFS_PFT_installation.log while installing FTP 8.0.2.
ERRORS
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Validating ETL details..
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ERROR] - =====Exception====
org.xml.sax.SAXParseException; systemId: file:/u01/app/OFSAA/sftpshare/etlapphome/ETLRepository.xml; lineNumber: 779; columnNumber: 11; The element type "INFODOM" must be terminated by the matching end-tag "".
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:205)
at com.ofss.fsgbu.installer.common.UtilityFunctions.loadXml(UtilityFunctions.java:433)
at com.ofss.fsgbu.installer.preinstall.ValidityTest.install(ValidityTest.java:96)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at com.zerog.ia.installer.AAMgrBase.a(DashoA10*..)
...
at com.zerog.lax.LAX.main(DashoA10*..)
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - ------------ETL App/Src Creation and mapping---------
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Getting ApplicationName1 :FSAPPS_FTP
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Getting ApplicationDesc1 :FSAPPS_FTP
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Creating ETL Application..
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullcom.iflex.fic.etl.entity.ClsUEntETLReason@72b40f87]
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ERROR] - Error during Application creation --> 1: [S][ETL.UTIL.ERR_PROCN_REQ]
...
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Source Name : PROCESSING_FTP Source Desc : PROCESSING_FTP
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - <IP_address>::1529::OFSAUAT-->>oracle.jdbc.driver.OracleDriver
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Creating ETL Source..
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:false][D:null][S:null][U:null][PT:0][P:nullnull]
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Mapping PROCESSING_FTP with FSAPPS_FTP
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullcom.iflex.fic.etl.entity.ClsUEntETLReason@d16209e]
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Generating source model for PROCESSING_FTP
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullcom.iflex.fic.etl.entity.ClsUEntETLReason@7e2bd5e6]
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ERROR] - Error during Source Model generation --> 1: [S][ETL.UTIL.ERR_PROCN_REQ]
...
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] - ----------------Appending ETLRepository.xml-----------------
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] -
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] - Appending to
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ERROR] - =====Exception====
org.xml.sax.SAXParseException; systemId: file:/u01/app/OFSAA/sftpshare/etlapphome/ETLRepository.xml; lineNumber: 779; columnNumber: 11; The element type "INFODOM" must be terminated by the matching end-tag "".
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:205)
at com.ofss.fsgbu.installer.common.UtilityFunctions.loadXml(UtilityFunctions.java:433)
at com.ofss.fsgbu.installer.preinstall.ValidityTest.install(ValidityTest.java:96)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at com.zerog.ia.installer.AAMgrBase.a(DashoA10*..)
...
at com.zerog.lax.LAX.main(DashoA10*..)
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - ------------ETL App/Src Creation and mapping---------
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Getting ApplicationName1 :FSAPPS_FTP
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Getting ApplicationDesc1 :FSAPPS_FTP
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - Creating ETL Application..
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullcom.iflex.fic.etl.entity.ClsUEntETLReason@72b40f87]
[Thu 21/6/2018 05:34:14] [OFS_PFT] [ERROR] - Error during Application creation --> 1: [S][ETL.UTIL.ERR_PROCN_REQ]
...
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Source Name : PROCESSING_FTP Source Desc : PROCESSING_FTP
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - <IP_address>::1529::OFSAUAT-->>oracle.jdbc.driver.OracleDriver
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Creating ETL Source..
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:false][D:null][S:null][U:null][PT:0][P:nullnull]
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Mapping PROCESSING_FTP with FSAPPS_FTP
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullcom.iflex.fic.etl.entity.ClsUEntETLReason@d16209e]
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - Generating source model for PROCESSING_FTP
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ INFO] - [Installer-ETL App/Src Creator]--Response:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullcom.iflex.fic.etl.entity.ClsUEntETLReason@7e2bd5e6]
[Thu 21/6/2018 05:34:15] [OFS_PFT] [ERROR] - Error during Source Model generation --> 1: [S][ETL.UTIL.ERR_PROCN_REQ]
...
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] - ----------------Appending ETLRepository.xml-----------------
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] -
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] - Appending to
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - =====Exception====
org.xml.sax.SAXParseException; systemId: file:/u01/app/OFSAA/ftpshare/etlapphome/ETLRepository.xml; lineNumber: 779; columnNumber: 11; The element type "INFODOM" must be terminated by the matching end-tag "".
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:205)
at com.ofss.fsgbu.installer.common.UtilityFunctions.loadXml(UtilityFunctions.java:433)
...
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] - ETLRepository.xml is backed up with the name
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - Error while saving XML document by name :/u01/app/OFSAA/ftpshare//etlapphome/ETLRepository_backup.xml
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - =====Exception====
java.lang.Exception: Saving failed. Document object of given XML is null. User possibly does not have write permission here.
at com.ofss.fsgbu.installer.common.UtilityFunctions.saveDoc(UtilityFunctions.java:94)
...
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - Some exception occurred ... trying to print stack trace
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - =====Exception====
java.lang.NullPointerException
at com.ofss.fsgbu.installer.install.ETLReposUpdation.appendETLrep(ETLReposUpdation.java:169)
at com.ofss.fsgbu.installer.install.ETLReposUpdation.install(ETLReposUpdation.java:118)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
...
[Thu 21/6/2018 05:42:02] [OFS_PFT] [ INFO] - Executing file:/u01/app/OFSAA/scripts/config/insert/pr2_rule_object_member_801_ci.sql
[Thu 21/6/2018 05:42:03] [OFS_PFT] [ERROR] - Query:'MERGE INTO PR2_RULE_OBJECT_MEMBER T
USING (
SELECT '1431455799414' V_RULE_ID,'OFSPFTINFO' V_INFODOM_NAME,'HEPMDELQ' V_OBJECT_UNIQUE_NAME,'S' V_OBJECT_LOCATION_CODE,'[HEPMDELQ]' V_MEMBER_UNIQUE_NAME,'ND' V_MEMBER_TYPE_CODE,'1' N_MEMBER_ORDER,'N' F_DEFAULT_FLAG FROM DUAL
) S
ON (T.V_RULE_ID = S.V_RULE_ID AND T.V_INFODOM_NAME = S.V_INFODOM_NAME AND T.V_OBJECT_UNIQUE_NAME = S.V_OBJECT_UNIQUE_NAME AND T.V_OBJECT_LOCATION_CODE = S.V_OBJECT_LOCATION_CODE AND T.V_MEMBER_UNIQUE_NAME = S.V_MEMBER_UNIQUE_NAME)
WHEN MATCHED THEN
UPDATE
...
[Thu 21/6/2018 05:42:03] [OFS_PFT] [ INFO] - Executing file:/u01/app/OFSAA/scripts/config/insert/seeded_batch_ipa_rpa_801.sql
[Thu 21/6/2018 05:42:03] [OFS_PFT] [ERROR] - Query:'MERGE INTO BATCH_MASTER T
USING (
select 'OFSIFRSINFO_SCD_CI_CUSTOMER_SERVICE_ENROLL' AS v_batch_id,'SCD_CI_CUSTOMER_SERVICE_ENROLL' AS v_batch_description,'SYSADMN' AS v_created_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_created_date,'SYSADMN' AS v_last_modified_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_last_modified_date,'E' AS v_batch_type,'ICC' AS v_src_framework,'OFSIFRSINFO' AS v_dsn_name,'N' AS v_is_sequential from dual union
select 'OFSIFRSINFO_SCD_Product_Feature' AS v_batch_id,'SCD_Product_Feature' AS v_batch_description,'SYSADMN' AS v_created_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_created_date,'SYSADMN' AS v_last_modified_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_last_modified_date,'E' AS v_batch_type,'ICC' AS v_src_framework,'OFSIFRSINFO' AS v_dsn_name,'N' AS v_is_sequential from dual union
...
org.xml.sax.SAXParseException; systemId: file:/u01/app/OFSAA/ftpshare/etlapphome/ETLRepository.xml; lineNumber: 779; columnNumber: 11; The element type "INFODOM" must be terminated by the matching end-tag "".
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:205)
at com.ofss.fsgbu.installer.common.UtilityFunctions.loadXml(UtilityFunctions.java:433)
...
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ INFO] - ETLRepository.xml is backed up with the name
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - Error while saving XML document by name :/u01/app/OFSAA/ftpshare//etlapphome/ETLRepository_backup.xml
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - =====Exception====
java.lang.Exception: Saving failed. Document object of given XML is null. User possibly does not have write permission here.
at com.ofss.fsgbu.installer.common.UtilityFunctions.saveDoc(UtilityFunctions.java:94)
...
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - Some exception occurred ... trying to print stack trace
[Thu 21/6/2018 05:36:05] [OFS_PFT] [ERROR] - =====Exception====
java.lang.NullPointerException
at com.ofss.fsgbu.installer.install.ETLReposUpdation.appendETLrep(ETLReposUpdation.java:169)
at com.ofss.fsgbu.installer.install.ETLReposUpdation.install(ETLReposUpdation.java:118)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at com.zerog.ia.installer.InstallablePiece.install(DashoA10*..)
...
[Thu 21/6/2018 05:42:02] [OFS_PFT] [ INFO] - Executing file:/u01/app/OFSAA/scripts/config/insert/pr2_rule_object_member_801_ci.sql
[Thu 21/6/2018 05:42:03] [OFS_PFT] [ERROR] - Query:'MERGE INTO PR2_RULE_OBJECT_MEMBER T
USING (
SELECT '1431455799414' V_RULE_ID,'OFSPFTINFO' V_INFODOM_NAME,'HEPMDELQ' V_OBJECT_UNIQUE_NAME,'S' V_OBJECT_LOCATION_CODE,'[HEPMDELQ]' V_MEMBER_UNIQUE_NAME,'ND' V_MEMBER_TYPE_CODE,'1' N_MEMBER_ORDER,'N' F_DEFAULT_FLAG FROM DUAL
) S
ON (T.V_RULE_ID = S.V_RULE_ID AND T.V_INFODOM_NAME = S.V_INFODOM_NAME AND T.V_OBJECT_UNIQUE_NAME = S.V_OBJECT_UNIQUE_NAME AND T.V_OBJECT_LOCATION_CODE = S.V_OBJECT_LOCATION_CODE AND T.V_MEMBER_UNIQUE_NAME = S.V_MEMBER_UNIQUE_NAME)
WHEN MATCHED THEN
UPDATE
...
[Thu 21/6/2018 05:42:03] [OFS_PFT] [ INFO] - Executing file:/u01/app/OFSAA/scripts/config/insert/seeded_batch_ipa_rpa_801.sql
[Thu 21/6/2018 05:42:03] [OFS_PFT] [ERROR] - Query:'MERGE INTO BATCH_MASTER T
USING (
select 'OFSIFRSINFO_SCD_CI_CUSTOMER_SERVICE_ENROLL' AS v_batch_id,'SCD_CI_CUSTOMER_SERVICE_ENROLL' AS v_batch_description,'SYSADMN' AS v_created_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_created_date,'SYSADMN' AS v_last_modified_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_last_modified_date,'E' AS v_batch_type,'ICC' AS v_src_framework,'OFSIFRSINFO' AS v_dsn_name,'N' AS v_is_sequential from dual union
select 'OFSIFRSINFO_SCD_Product_Feature' AS v_batch_id,'SCD_Product_Feature' AS v_batch_description,'SYSADMN' AS v_created_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_created_date,'SYSADMN' AS v_last_modified_by,TO_CHAR(sysdate,'dd mon yyyy hh24:mi:ss') AS v_last_modified_date,'E' AS v_batch_type,'ICC' AS v_src_framework,'OFSIFRSINFO' AS v_dsn_name,'N' AS v_is_sequential from dual union
...
STEPS TO REPRODUCE
- Attempt installation of FTP 8.0.2 version.
- Check install logs.
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 |