Monday, April 15, 2013

Error while performing GET/CHECK OUT




Error:

Siebel-ERR-1109: Unable to read value from export file (Data length (4) > Column definition (1)).
Siebel-ERR-1107: Unable to read row 1 from export file (UTLDataValRead pBuf, col 11: TRANSLATE_FLG ).
Siebel-ERR-1124: Unable to import table "S_LIST_COL_INTL" (UTLDataRowRead).

Solution:

The following registry keys must be created for new Oracle ODBC connections:
[HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ORACLE_CONNECTION_NAME]

PacketSize = 0
EnableScrollableCursors = 0
ColumnsAsChar = 1
ColumnSizeAsCharacter = 1


ORACLE_CONNECTION_NAME is the name of the ODBC database connection.

4 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Following registry also needs to be updated to get this resolved.
    For 64 Bit -
    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ORACLE_CONNECTION_NAME]
    For 32 Bit -
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ORACLE_CONNECTION_NAME]
    PacketSize = 0
    EnableScrollableCursors = 0
    ColumnsAsChar = 1
    ColumnSizeAsCharacter = 1

    ReplyDelete
  3. try the same thing on [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ORACLE_CONNECTION_NAME]

    ReplyDelete
  4. this error will occur , if you change the dbf and forgot to update correct path and dockstring and enterprise server both lo Local and server section CFG. even if you give PacketSize = 0
    EnableScrollableCursors = 0
    ColumnsAsChar = 1
    ColumnSizeAsCharacter = 1 parameters please check dockstring and Entriprise server correctly

    ReplyDelete