SAP Knowledge Base Article - Preview

1887003 - Rebuilding a SQL Anywhere database results in error -162 "Cannot convert review and evaluation <string> to a <column type. ...".

Symptom

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 ...


Read to a more...

Environment

SAP Sybase SQL Anywhere

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP SQL Anywhere, cloud edition 1.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

Keywords

dbunload, dbupgrad , KBA , BC-SYB-SQA-SRV , SQL Anywhere - Server , Problem

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.