Assignment Manager Unavailable with errors dict-ERR-1109 - dict-ERR-1107
Last updated on MARCH 02, 2017
Applies to:Siebel Assignment Manager - Version 18.104.22.168  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 22.214.171.124 
Database: Oracle 126.96.36.199
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: HP 9000 Series HP-UX
This document was previously published as Siebel SR 38-2927882751.
After performing 7.7 to 188.8.131.52 Upgrade, Assignment Manager stays in Unavailable state, all other Obj Mgrs can be started.
Error starts: GenericLog GenericError 1 0 2006-02-22 11:27:54 Message: Internal error occurred in a procedure.,
Additional Message: dict-ERR-1109: Unable to read value from export file (Data length (4) > Column definition (3)).
GenericLog GenericError 1 0 2006-02-22 11:27:54 Message: Internal error occurred in a procedure.,
Additional Message: dict-ERR-1107: Unable to read row 0 from export file (UTLDataValRead pBuf, col 4 ).
GenericLog GenericError 1 0 2006-02-22 11:27:54 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,
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'
///// Please Advise,
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