OFS PFT 8.1 Installer Execution failed with exit code : 3 Failure On Multiple SQL*loaders for Seeded Dimensions
(Doc ID 2760195.1)
Last updated on MAY 19, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
Following OFS PFT 8.1 installation execution, seven errors were observed in the OFS_PFT_installation.log file with respect to SQL*loader activities loading seeded DIM values.
ERRORS
[10-02-21 17:32:37,534 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_RUN_TYPE.ctl
[10-02-21 17:32:37,559 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_RUN_TYPE.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_RUN_TYPE.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:37,559 EST PM] [ERROR] Execution failed with exit code : 3 , time consumed in milliseconds: 25
[10-02-21 17:32:38,454 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/create/LD_GAAP.sql
[10-02-21 17:32:38,513 EST PM] [INFO ] # statements executed: 2 , time consumed in milliseconds: 57
[10-02-21 17:32:38,513 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_GAAP.ctl
[10-02-21 17:32:38,526 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_GAAP.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_GAAP.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:39,330 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_CURRENCY.ctl
[10-02-21 17:32:39,340 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_CURRENCY.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_CURRENCY.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:39,340 EST PM] [ERROR] Execution failed with exit code : 3 , time consumed in milliseconds: 10
[10-02-21 17:32:40,169 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_ACCOUNT_CLASSIFICATION.ctl
[10-02-21 17:32:40,180 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_ACCOUNT_CLASSIFICATION.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_ACCOUNT_CLASSIFICATION.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:40,180 EST PM] [ERROR] Execution failed with exit code : 3 , time consumed in milliseconds: 10
[10-02-21 17:32:41,019 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_INSURANCE_SCHE_APPLY_GRP.ctl
[10-02-21 17:32:41,029 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_INSURANCE_SCHE_APPLY_GRP.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_INSURANCE_SCHE_APPLY_GRP.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:41,029 EST PM] [ERROR] Execution failed with exit code : 3 , time consumed in milliseconds: 9
[10-02-21 17:32:41,863 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_INSUR_SCHE_COVER_TYPE.ctl
[10-02-21 17:32:41,873 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_INSUR_SCHE_COVER_TYPE.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_INSUR_SCHE_COVER_TYPE.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:41,874 EST PM] [ERROR] Execution failed with exit code : 3 , time consumed in milliseconds: 10
[10-02-21 17:32:42,702 EST PM] [INFO ] Executing file :/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_OWNERSHIP_CATEGORY.ctl
[10-02-21 17:32:42,713 EST PM] [INFO ] Command executed: [/app/oracle/product/19.0.0/client_1/bin/sqlldr, control=/app/ofsaai/ofsaa8/installerScripts/OFS_PFT/scripts/atomic/sqlloader/DIM_OWNERSHIP_CATEGORY.ctl, log=/app/ofsaai/installer/02_V998584_OFSPM81000/OFS_PFT_PACK/OFS_PFT/logs/sqlloader/atomic/DIM_OWNERSHIP_CATEGORY.ctl.log, userid=/*******@ociofsa, silent=header]
[10-02-21 17:32:42,713 EST PM] [ERROR] Execution failed with exit code : 3 , time consumed in milliseconds: 10
Other atomic scripts are successfully run and executed.
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 |