Database load error ICXLHIS

Hi,

We are trying to load database and it fails. Getting the following error while processing ICXLHIS

error = 0
native code = -1677721600

SAGE 300 ERP ACCPAC with PU3
Database MSSQL 2008 R2

Extra info:

Old Collation order: Latin1_General_Bin
New Collation order: Arabic_CI_AS
Recovery model: Simple
Database Autogrowth for MDF file is: By 1 MB, unrestricted growth

Total records we see in ICXLHIS table when the load fails is 197000 and in the original database total records are 197172. I verified there are no corrupt data in the original database

Initially had the load error on ICUNIT table and fixed the duplicate unit codes due to insensitive data. Then ICUNIT table was passed during the load. Now the error is in ICXLHIS.

Any help and guidance is highly appreciated.

Parents Reply Children
  • 0 in reply to Jay Converse Acumen

    Thank you Jay!

    I asked ettienne at www.tek-tips.com if he meant to Run SQL Server Profiler or SQL Query Analyzer. Still waiting for his reply.

    Anyway I had started the database load again and it will take a while due to 19 GB database size. I will run SQL Server Profiler when I reach ICXLHIS table and report my findings here.

    Any help from you is greatly appreciated!