I update my inventory this morning with your new service pack 2009.02.17. When i do my check integrity after, this error apear:

ADA-09900-10 has orphan history records

i have 4609 errors with this error (all of my item in inventory)

my last version of inventory was 2008.08.29

Help me !

Hi, Monique,

There's nothing in the service pack that would have caused the errors. When was the last time (before this) you did a data integrity check?

Did the Rebuild button present itself? If so and you have made a current backup, click the button and it will try to fix the errors. When it's finished, run the DIC again. You're looking for it to report no errors.

Hi, Monique,

There is actually a change we made to how the DIC works in this SP that may well be why all the errors were reported when you ran the DIC after installing it.

Prior to this SP (in an earlier release or older 3rd party program), if someone had deleted items that had history, the DIC did not detect the orphan history files. This could cause problems if the deleted item codes were later reused.

The DIC in the new SP does detect and rebuild (in this case delete) the orphan files. We did this an an enhancement to the Inventory program.

Deleting an item is not recommended as history for the item may still exist in Adagio SalesAnalysis, OrderEntry and Invoices.

Hello Support:

From which History table does Data Integrity Check delete those orphans?

Thank you.

Hi Bruce,

The orphan records will be deleted from the Item Transaction History. The files are:
ICHIST'1
ICHIST'2
ICHIST'3
ICHIST'R