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.

Posted by at

5 comments:

  1. AAAAAAAAANovember 6, 2013 at 12:10 AM

    This comment has been removed by the author.

    ReplyDelete
  2. freeantivirusesApril 21, 2015 at 4:51 PM

    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. UnknownSeptember 1, 2015 at 1:40 AM

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

    ReplyDelete
  4. UnknownMay 10, 2016 at 5:50 PM

    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
  5. Amarender Reddy BillaMarch 21, 2018 at 12:33 PM

    jeji

    ReplyDelete

Subscribe to: Post Comments (Atom)