Symptom
- An unexpected conversion error happens when trying to insert NULL into a datetime column, or any other datatype.
- After this error, rows are inserted 1 by 1 instead of by chuncks.
- This erros occurs when using ODBC.
[ IQ message file ]
I. 11/15 14:15:37. 0000008815 : Insert for 't44' completed in 3 seconds.65535 rows inserted.
I. 11/15 14:15:37. 0000008815 Exception Thrown from dblib/db_sqlins.cxx:2821, Err# 43, tid 2 origtid 2
I. 11/15 14:15:37. 0000008815 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -157, SQLState: '53018', Severity: 16
I. 11/15 14:15:37. 0000008815 [2104]: Cannot convert ":=@KL to a datetime(26) (column dtime)
I. 11/15 14:15:37. 0000008815 Exception Thrown from dblib/db_sqlins.cxx:2821, Err# 43, tid 2 origtid 2
I. 11/15 14:15:37. 0000008815 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -157, SQLState: '53018', Severity: 16
I. 11/15 14:15:37. 0000008815 [2104]: Cannot convert ":=@KL to a datetime(26) (column dtime)
I. 11/15 14:15:37. 0000008815 [20896]: Insert for 't44' completed in 0 seconds. 1 rows inserted.
I. 11/15 14:15:37. 0000008815 [20896]: Insert for 't44' completed in 0 seconds. 1 rows inserted.
I. 11/15 14:15:37. 0000008815 [20896]: Insert for 't44' completed in 0 seconds. 1 rows inserted.
I. 11/15 14:15:37. 0000008815 [20896]: Insert for 't44' completed in 0 seconds. 1 rows inserted.
....
I. 11/15 20:30:16. 0000008815 [20896]: Insert for 't44' completed in 0 seconds. 1 rows inserted.
[ srvlog ]
I. 11/15 14:15:37. <,2,PREPARE,insert into "t44"( "ID","dtime" ) values( :?,:? )
I. 11/15 14:15:37. >,2,PREPARE,65538
I. 11/15 14:15:37. <,2,EXEC,65538
I. 11/15 14:15:37. E,2,-157,Cannot convert ":=@KL to a datetime(26) (column dtime)
Read more...
Environment
- SAP IQ16.0 SP11.x
- BO DS version : 4.2
Product
Keywords
"Cannot convert"; "ErrID: 4098"; "db_sqlexception"; "conversion_error"; "conversion"; , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.