My Oracle Support Banner

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.

C:\Siebel\Tools\BIN>localdbsetup.exe -s C:\Siebel\Tools -u XXXXX -p XXXXX -o XXXX_DSN -t SIEBEL -d LOCAL_XE -x C:\Siebel\Tools\oraclexe -y DCRS -z N

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. 

C:\Siebel\Tools\BIN>localdbsetup.exe -s C:\Siebel\Tools -u XXXXX -p XXXXX -o XXXX_DSN -t SIEBEL -d LOCAL_XE -x C:\Siebel\Tools\oraclexe -y DCRS -z N
 

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


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