Monday, 26 June 2017

Unable to read value from export file - Siebel-ERR-1109

While we are doing a Full Get in Siebel Tools for first time or while setting a new ODBC Connection, many times we faced an error like below

Siebel-ERR-1109 : Unable to
read value from export file ( myLen (8) > valueLen (2))

This error caused due to some missing registry key entries in ODBC connection.
To resolve this error add below registry keys for new Oracle ODBC connections:

Registry editing path for 64 bit:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ORACLE_CONNECTION_NAME]

Registry editing path for 32 Bit:
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ORACLE_CONNECTION_NAME]
Registry keys:
  • PacketSize = 0
  • EnableScrollableCursors = 0
  • ColumnsAsChar = 1
  • ColumnSizeAsCharacter = 1



ORACLE_CONNECTION_NAME is the name of the ODBC database connection.