2169901 - Binary extract column gives "Cannot convert" error on load - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2169901 - Binary extract column gives "Cannot convert" error on load - SAP IQ

Symptom

  • Loading a file created with IQ Binary Extract that contains a varchar or varbinary column may fail with a conversion error.: 
    "Cannot convert scri to a date(10) (column begin_dt) SQLCODE=-157, ODBC 3 State="07006" Line 1, column 1"
  • In this example "scri" is part of the varchar field's contents and it's name ("description").

Read more...

Environment

SAP IQ 16.0 SP08.20

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.