Assignment Manager Unavailable (DICT-ERR-1109) (DICT-ERR-1107) (Doc ID 540799.1)

Symptoms

After performing 7.7 to 7.8.2.1 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,
          IND.MODULE_NAME
     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'

Changes

Cause

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