SAP Knowledge Base Article - Preview

2077765 - Failed to migrate IQ12.7 database to IQ15.x with an error

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

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

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.