Data Load error to Accpac 5.6

[vincejci]

Hi All,

I encountered the error below when loading the dump file in Accpac 5.6

Error Message:

INSERT (error=49153,native code=12899) message:[Oracle][ODBC][Ora]ORA-12899:value too large for column "BC256D"."APBTA"."BATCHDESC"(actual:61,maximum:60)

I use ORACLE 11g as database.
Any ideas of this error?
Any help will greatly be appreciated.

Thanks guys.

 

[Jay Converse]

BATCHDESC is a 60 character field, so you have bad data. What was the original database? What language?

 

[vincejci]

The original database is also Oracle 11g. I checked the record where the loading stopped the field contains less than 60 length. This is data from Accpac 5.6 and the app ensures you are not saving longer than length 60 when saving.

Thanks