Symptom
When you migrate IQ 12.7 database to IQ 15.x via iqunload, there are cases where the below error message will be reported.
Error message
***** SQL error: Right truncation of string data
Error Sample
$ iqunload -au -c "UID=DBA;PWD=SQL;DBF=xxxxxx"
Sybase IQ Unload Utility Version 15.4.1.3038
Connecting and initializing
=============================================================
IQ server starting with:
1 connections ( -gm )
14 cmd resources ( -iqgovern )
127 threads ( -iqmt )
512 Kb thread stack size ( -iqtss )
65024 Kb thread memory size ( -iqmt * -iqtss )
2 IQ number of cpus ( -iqnumbercpus )
0 MB maximum size of IQMSG file ( -iqmsgsz )
0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================
=============================================================
IQ server starting with:
1 connections ( -gm )
14 cmd resources ( -iqgovern )
127 threads ( -iqmt )
512 Kb thread stack size ( -iqtss )
65024 Kb thread memory size ( -iqmt * -iqtss )
2 IQ number of cpus ( -iqnumbercpus )
=============================================================
Licensing error: Code = -201.
Wrapping iqmsg: Disabled.
Wrapping iqmsg: Disabled.
=============================================================
IQ server starting with:
1 connections ( -gm )
14 cmd resources ( -iqgovern )
127 threads ( -iqmt )
512 Kb thread stack size ( -iqtss )
65024 Kb thread memory size ( -iqmt * -iqtss )
2 IQ number of cpus ( -iqnumbercpus )
0 MB maximum size of IQMSG file ( -iqmsgsz )
0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================
***** SQL error: Right truncation of string data
Read more...
Environment
SAP IQ 15.x
Product
Keywords
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.