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.
SAP Knowledge Base Article - Preview