Siebel Remote : Generate New Database Job Is Not Getting Completed (Doc ID 2112837.1)

Last updated on JULY 23, 2023

Applies to:

Symptoms

Generate  New database job was QUEUED  through GUI  and  it  failed  with following error message when run through server manager .

GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 Unable to load dictionary data.
GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 Error in MainFunction (ReadAndCreateDDLFile)
GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 (gennewdb.cpp (610) err=524292 sys=2) SBL-GDB-00004: Error in Main function.

GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 Message: GEN-13,
Additional Message: dict-ERR-1109: Unable to read value from export file (Data length (4) > Column definition (3)).

GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 Message: GEN-13,
Additional Message: dict-ERR-1107: Unable to read row 0 from export file (UTLDataValRead pBuf, col 4 ).

GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 Message: Generated SQL statement:,
Additional Message: SQLFetch:

SELECT IND.ROW_ID, IND.NAME, IND.ALIAS, IND.TBL_ID, IND.ISUNIQUE,

IND.USER_PR_KEY, IND.USER_NAME, IND.TYPE, IND.ISCLUSTERED,

TBL.TYPE, IND.ISCLUSTERED2, IND.ALLW_RVRS_SCAN_FLG, IND.NUM_UNIQUE_COLS,

IND.MODULE_NAME, IND.NODE_TYPE_CD, IND.TARGET_DBMS

FROM SIEBEL.S_INDEX IND, SIEBEL.S_TABLE TBL

WHERE IND.REPOSITORY_ID = (SELECT ROW_ID FROM SIEBEL.S_REPOSITORY WHERE NAME = ?)

AND TBL.ROW_ID = IND.TBL_ID

AND (TBL.INACTIVE_FLG = 'N' OR TBL.INACTIVE_FLG IS NULL)

AND (IND.INACTIVE_FLG = 'N' OR IND.INACTIVE_FLG IS NULL)

AND TBL.TYPE <> 'External'

AND TBL.TYPE <> 'External View'

GenericLog GenericError 1 0000000d56c216c0:0 2016-02-16 09:38:51 Message: Error: An ODBC error occurred,
Additional Message: Function: DICGetIndexes; ODBC operation: SQLFetch

Similar error were observed in Srproc*.log  with additional  error message :  SBL-GEN-03006: Error calling function: DICFindTable m_pReqTbl

Cause

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