Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

Why do I get TimesTen error 2683 when loading a character into a char(1) field in 11.2.2.4.1 and not

 TimesTen release 11.2.1.8.4 and backward worked fine loading a character, like 'T' into a char(1) field.   Now the same code in 11.2.2.4.1, gives native_error 2683 and odbc_error 22001.<ERROR in TTCommand.cpp, line 321: Error in TTCmd::Execute() while executing statement
[TimesTen][TimesTen 11.2.2.4.1 ODBC Driver]String data right truncation
*** ODBC Error/Warning = 22001, TimesTen Error/Warning = 2863
*** Command execution of statement <INSERT into idb_index_description (index_name, table_name, column_name, pk_name, data_type, uniqueness, index_state) VALUES(?, ?, ?, ?, ?, ?, ?)> failed.>
The field getting the error is 'UNIQUENESS'
Table ISCPADM.IDB_INDEX_DESCRIPTION:
  Columns:
    INDEX_NAME                      VARCHAR2 (128) INLINE UNIQUE NOT NULL
    TABLE_NAME                      VARCHAR2 (128) INLINE NOT NULL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center