LOAD TABLE statement fails during the process of migrating the database to a different collation. Rebuilding the database, without changing the collation works fine. SQL Anywhere reported the error message:
Loading (xxx/yyy) <table name>
Could not execute statement.
Cannot convert review and evaluation <number> to a timestamp. The bad value was supplied for column '<column name>' on row <row number> of the data file
SQLCODE=-162, ODBC 3 State="07006"
File: "reload.sql" on line <line number>, column <column number>
LOAD TABLE ...
SAP Sybase SQL Anywhere
dbunload, dbupgrad , KBA , BC-SYB-SQA-SRV , SQL Anywhere - Server , Problem
About this pageThis 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.