Wondering if anyone can tell me why we get so many Integrity Errors? Once or twice a week we aren't able to finish our Day End processing and have to run through DataCare, rebuild the errors, run through DataCare again and when it comes back with no errors, we can proceed to the Day End. Thankfully we can rebuild them, but this is really time consuming, especially since we've been warned not to run Adagio from the Server. DataCare takes 30 - 45 minutes each time from a Workstation. Our Day End which should take about 10 minutes but in these situations takes about 1 1/2 hours instead.

I don't know what is causing the errors and how to avoid them. They are different all the time.

Here are the most current errors:

Data Integrity of:

Adagio Inventory:File Integrity
Items (1) ... 51 error(s) found ................................................ FAILED

Adagio OrderEntry: Application Integrity
Invalid item TV 32V432TRB on line 1 of I 177781
Invalid item TV 37HL57 on line 1 of O 173844
Invalid item TV 24E401 on line 2 of O 175941
Orders/Invoice headers ... 3 error(s) found
Item TV 32V432TRB ShipNotCosted at loc KI is 1.00 calc 0.00
Item TV 37HL57 OnSalesOrder at loc WA is 1.00 calc 0.00
Item TV 20F512T ShipNotCosted at loc WA is 1.00 calc 0.00
Item TV 24E401 OnSalesOrder at loc WA is 2.00 calc 0.00
Items ... 4 error(s) found

Summary
File Integrity ... 51 error(s) found ........................................... FAILED
Application Integrity ... 7 error(s) found ..................................... FAILED

Finshed at: 2008.04.29 17:16

One more note is that our DataCare Job is set to "Compact" Inventory and OE. Maybe I should start by removing the compacting?

Hi Susan,

There are many reason why data may produce integrity errors, some of which are problems related to the network, workstation, multi-user collisions, power surges or outages, closing the program before a function is complete, or application issues.

For the first (file integrity) set of errors, there are 51 occurences in the item file where there may be index mismatching or problems that the Adagio users have no control over.

For the second (application integrity) set of errors, it appears that 3 particular items may have been deleted but still exist on open orders. Users potentially have some influence over these type of errors, but not always.

Make a backup of your data, and then the next time you run an integrity check, you can try Rebuilding the errors to fix them. Some errors are fixable in this way and some are not, depending on the nature of the error.

Compacting shouldn't be causing this problem - this process removes the 'blank space' in a data file after records are deleted or purged. If you wish to disable the Compacting option in DataCare to see if makes a difference, then it is certainly worth a try.

If all the errors are fixed, yet they re-occur again, please let us and your Adagio consultant know, as we all want to help determine what is happening and find a way to make these errors stop occuring.