SAP Knowledge Base Article - Preview

2392244 - Performance drops after conversion error to insert NULL into a column through ODBC - SAP IQ16.x

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

SAP IQ 16.0

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.