Why do I get TimesTen error 2683 when loading a character into a char(1) field in 11.2.2.4.1 and not
edited Sep 9, 2013 11:28AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 6 commentsAnswered
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
0