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

Last updated on SEPTEMBER 05, 2017

Applies to:

Siebel CRM - Version 15.4 [IP2015] and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms