My Oracle Support Banner

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 MARCH 26, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Information 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


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