Error while importing Scenario (Doc ID 2871736.1)

Last updated on MAY 30, 2022

Applies to:

Symptoms

Client tried to migrate scenarios from dev environment to UAT environment, but ran into below error in the log
[Mon 22/3/2021 04:53:48] [LOAD] [ INFO] - LOAD - Message 265062: Connecting to the database
[Mon 22/3/2021 04:53:48] [LOAD] [FATAL] - LOAD - Message 265057: Unable to connect to the database. Please check the database configuration details specified.
[Mon 22/3/2021 04:53:48] [LOAD] [FATAL] - LOAD - Message 265003: GETCONNECTION: java.sql.SQLException: ORA-28000: the account is locked

[Mon 22/3/2021 04:53:48] [LOAD] [FATAL] - LOAD - Message 265060: Error during execution. Error : java.lang.Exception: Open Connection Error Module : LOADCONFIG
[Mon 22/3/2021 04:53:51] [LOAD] [ WARN] - CORRRULEMIGRATIONUTIL_LOAD - Message 181030: No Filename Containing Correlation Rule Names Has Been Specified. The System Would Now Proceed By Reading Its Default File.
.
.
.
.
.
[Wed 04/5/2022 01:52:04] [LOAD] [ INFO] - LOAD - Message 265105: Loading scenario catalog ID CTR-BSACTR
[Wed 04/5/2022 01:52:04] [LOAD] [ INFO] - LOAD - Message 265089: Score flag is false. Score tables {0} will be excluded
[Wed 04/5/2022 01:52:04] [LOAD] [ INFO] - LOAD - Message 265106: Loading scenario catalog ID CTR-BSACTR, scenario ID 118745200
[Wed 04/5/2022 01:52:04] [LOAD] [FATAL] - LOAD - Message 265201: Save Job Info failed with exception java.sql.SQLSyntaxErrorException: ORA-00904: "F_NUM_TO_CHAR": invalid identifier

[Wed 04/5/2022 01:52:05] [LOAD] [FATAL] - LOAD - Message 265188: UPDATE error: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (FCRMATM.FK_819_4) violated - parent key not found

[Wed 04/5/2022 01:52:05] [LOAD] [ WARN] - LOAD - Message 265055: Rolling back the transactions.

Cause

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