Skip to Content

Sybase IQ 15.4 to 16 Sp8 PL10

Jul 17, 2017 at 06:50 AM


avatar image


We are in the processing of migrating Sybase IQ 15.4 to 16Sp8 PL10.

SIQ 16 is on a new windows server and we are trying to use BODS to migrate the tables.

we are getting errors like below in BODS for most of the tables

Number of bytes (49152) for a column from an input file has exceeded the maximum allowed (32767).

We verified the column lengths in Sybase 15 & 16 are same.

tried to extract table to a file and Load , but the same issues occurs.

We have Decimal(15,0) for columns, is this datatype no more supported in IQ16?

Can someone help us to fix this. Ours is a small environment and we dont have a Sybase Admin to assist.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kirby Gehman
Oct 02, 2017 at 07:26 PM

This error is essentially saying that SAP IQ is trying to read the data for a column, and it found a "chunk" of data that is too large to fit in that column.

It usually means that there is a problem with delimiters, so that SAP IQ is considering the entire row (or the entire file) as the data to insert into the first column because it can't tell where the first column ends.

I'd suggest starting smaller. Create a similar table, insert two simple lines of data into it manually and then export it. Then play with LOAD TABLE until you find the right combination of delimiters and column specs to load it. That will help you load the rest of your data.

10 |10000 characters needed characters left characters exceeded