Database Load Error 1

[phillipnc]

I have a client using ACCPAC 5.6, If I upgrade the Data to 6.0 and do a database dump, the dump fails to load, it gives a error = 64288, native code = 15911 message. While processing ICXLHIS. In 5.6 I can dump and load without any problems.

ACCPAC 6.0 with PU1
Database MSSQL R2

 

[Jay Converse]

Assuming 2008 R2, since you didn't specify.

Are you sure about that native error code?
What collation order?
What recovery model?
What do you see in records of that table when the load fails?

 

[phillipnc]

Assuming 2008 R2, since you didn't specify. = Yes, MSSQL 2008 R2

Are you sure about that native error code? = Yes.
What collation order? = Latin1_General_BIN
What recovery model? = Default not changed.

Database size = 4383.06MB

 

[phillipnc]

Module List:
AP, AR, GL, IC, Lot Tracking, PO, OE, Pacific Audit logger.

 

[ettienne]

Set recovery model to simple.

 

[DjangMan]

Try not using the V10 client and look at the settings to make sure your database is not expanding by only 1mb.

 

[phillipnc]

Hi

Ettienne's solution to Set recovery model to simple, soved the client's problem.

Thank you Ettienne.

 

[phillipnc]

Database load error again, This time its failing while processing ICUNIT, error = 59176, native code = 20263, message

Recovery model is Set to Simple,

 

[Jay Converse]

Mixed case data: Each, each, EACH.

Fix data in source before Dbdump, or change collation to binary.

 

[phillipnc]

Thank you, I am currently using Latin1_General_BIN. Which one should I use? I also want the search to be case insensitive.Also Tried using Latin1_General_C1_AS but did not solve the Case sensitivity issue.

 

[Jay Converse]

Then that's not the problem, BIN would have loaded case sensitive data.

Does ICUNIT have any data after the crash? Count the last record, then look at record +1 in the source database for clues.

 

[phillipnc]

I have tried loading the data on Pervasive and its working, What could be the problem will MSQL?

 

[Jay Converse]

Run RVSPY to see details of the bad record.