LocalDbSetup Execution is Failing at Step 6 with Error ORA-00904: "T"."X_REP_LR_FREQ_START_DATE": invalid identifier
(Doc ID 2962939.1)
Last updated on AUGUST 31, 2023
Applies to:
Siebel CRM - Version 16.0 [IP2016] to 20.7 [Release V16 to V17]Information in this document applies to any platform.
Symptoms
When attempting to run LocalDBSetup utility through command prompt, the following error occurs in the command line.
Stage 6 of 7: Data import on LOCAL_XE failed
Error: Data import failed. Please check D:/Siebel/16.0.0.0.0/Tools/Bin/LocalDBTemplate/data_3_imp.log for details
The following errors are found in the data_3_imp.log
DBCLog DBCLogError 1 0000000264a30750:0 2023-07-04 18:11:37 [tp][ODBC Oracle driver][Oracle]ORA-00904: "T"."X_REP_LR_FREQ_START_DATE": invalid identifier
SQLDBUtilityLog SQLDBUtilityLog 3 0000000264a30750:0 2023-07-04 18:11:37
SQLDBUtilityLog SQLDBUtilityLog 3 0000000264a30750:0 2023-07-04 18:11:37 S0022: [tp][ODBC Oracle driver][Oracle]ORA-00904: "T"."X_REP_LR_FREQ_START_DATE": invalid identifier
SQLDBUtilityLog SQLDBUtilityLog 3 0000000264a30750:0 2023-07-04 18:11:37
Trace Trace 3 0000000264a30750:0 2023-07-04 18:11:37 DATAIMP-ERR-1124: Unable to import table "S_ASSET" (UTLOdbcOutputBind select).
SQLDBUtilityLog SQLDBUtilityLog 3 0000000264a30750:0 2023-07-04 18:11:37 Error in ProcessImportFile (UTLDataImportFile).
SQLDBUtilityLog SQLDBUtilityLog 3 0000000264a30750:0 2023-07-04 18:11:37 Error in ProcessImportFile...
GenericLog GenericError 1 0000000264a30750:0 2023-07-04 18:11:37 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 =(null), msg3 = (null), msg4 = (null)
Replication steps:
1. Setup Siebel IP16 with Local Database instance
2. Execute the LocalDBSetup.exe script through command prompt using the following syntax.
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 |