Year End Data Conversion Problem

[bojimuncher]

Hey all,
At the end of every fiscal year, my company creates a new "Year End" database so if they need to see anything with the way things were at that time, they have a static, different company with that information in it.
We have just upgraded to Sage Accpac ERP v5.6 and our Live data, 2008 and 2009 databases have all converted successfully, but our 2007 data is giving us the following error when activating the main group of modules.

Internal Error. ICUPGD.VerifyKeysToBeAdded: Cannot add key 5 for table ICHIST because 5 keys are expected but 4 exist(s) in the table. (3360 ICUPGD1.C)

I brought up the ICHIST table in both the 2007 year end data as well as the live data, and both seem to be somewhat similar, and realize that this is probably happening bc the 2007 data is a conversion of a conversion from v5.4 but is there anyway to get this to be able to convert to v5.6?

Thanks!

 

[Jay Converse]

Forget it. Leave the year end companies in the version in which they were at the time. This is a known error message, but the cost to fix it and upgrade has zero benefit.

 

[bojimuncher]

Thanks for the reply, but if I'm going to tell the owners that I can't convert their data, they are going to want to know how much work it is to convert. Can you give me an outline of the process?

Thanks

 

[ettienne]

RTFM - it's outlined in the documentation.

 

[Jay Converse]

I'm putting on my IT auditor's hat, and I still say forget it. These are year-end snapshots that should remain as they were when the snapshot was taken. If you upgrade them, you've changed them.

 

[bojimuncher]

Thanks ettienne for as valuable post as always, and a more genuine thanks to tuba, ill try and convince him to give it up.

 

[ettienne]

Screw you mate, my answer is valid, all the info is there and if you are too &^%$&^$ lazy to read it for yourself then I don't see why someone else should do the effort to feed it to you.

 

[Bluejay07]

This can also be accomplished with the Software Development Kit (SDK) if you have access to it.

I recently had to do something similar for another company, although it was time consuming.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[ettienne]

I have done many of these upgrades without needing any special tools or the SDK, if you follow the upgrade instructions in the documentation then you will not run into problems.