Unattended, DataCare reports 4 phase 2 errors
in I/R 6.5A files. A verbose report gives no further details. Error file IRINTERR.* contains no information. DataCare run on a single entry in interactive mode reports no errors. Windowing System Manager SP2 7.0A, Check Data Integrity, reports no errors. Any help to clean up my overnight DataCare report would be appreciated.

Hi Al,

We haven't any specific reports with IR, but in another situation, DataCare erroneously finds an error in AP if AP, JC, and PO are all checked together. The same database checks clean if AP is checked by itself. In fact, the database is OK in that circumstance.

My feeling is that those phase 2 'errors' are in fact false, and that your IR is OK. What other modules are you checking with the overnight check? Are there any outstanding batch files in IR that are waiting to be retrieved (IRxxBTCH.dat)?

If there were no details as to the errors, is there any indication on the DataCare verbose log which file the errors are in?

Thanks for the quick response, and staying after office hours to reply.

The other modules included in the run are:
A/P 6.1A
A/R 6.1A
CONTACT MASTER 6.1D
COUNTER SALES 6.1C
G/L 7.0A
I/C 6.1B
QUICK HISTORY 6.5A

There is no open IR batch.
There is no indication in the verbose log that gives a clue as to which file the errors are in.
After running for several weeks with 4 errors, last night it found two more, so now we have 6.

Hi Al,

I've got a sample data set that is exhibiting similar problems. After running both DataCare and the WSM integrity check, I've found that the errors (in my case) are related to the comparison of Quantity on PO amounts in IC and IR, for the IC Quantity by Location file.

If this happens to be the same for you, verify that for specific items (IC inquiry and Quantity by Location), the numbers match compared to IR. Make sure that Day End has been done in both IC and IR.

I've also found that fixing the errors with WSM simply transfers the errors found to IC, and fixing again puts the errors back to IR.

[This message has been edited by Softrak Support (edited 10-19-2000).]

What led you discover that the problem was with quantities? The verbose report only gives me the error count.
I have approximately 1600 different items on open purchase orders. This makes a comparison between IC quantities on order and IR quantities on order difficult. I suppose it would be possible to write a Quick Report but with the 50,000 item IC file I have it would be very time consuming.
Neither WSM nor DataCare on a single start list entry detect the problem.

Hi Al,

The problem you are running into may or may not be related to quantities; that's what it happened to be for me. On the data set I have, the specific errors are not listed on the verbose DC log, but either while the Integrity check is being done (and the errors fixed one by one on the screen) or the xxINTERR.dat file. The data for a specific module (ie either IC or IR) is absolutely OK, but when DIC is run with both modules, the quantities in both modules can be compared and found to be different.

This sort of problem could only happen if either there was a problem with posting or a portion of the data was restored improperly (the latter being the case with my test data). When IR and IC is run together, the problem items should be listed in the xxINTERR.dat file for one or the other (but not both) of the modules. You will have to determine the next course of action.

Friday night I stayed to watch the unattended DataCare run. The errors showed up when the data being checked was IC Item Data. The records being checked showed 1-PO-nnnnnn. My purchase order number format. I don't know if the 1- record is header or detail record. DataCare didn't make any attempt to fix the errors. I haven't had to restore any files in the past year or so. It is still showing 6 errors with no additional information in the verbose listing or IRINTERR.*.

Hi Al,

When DataCare is run 'unattended', it will not attempt to fix any errors, as you have found. Errors can be fixed only when DataCare is set to run in 'interactive mode' (in the DC company profile), which cannot be done unattended. If the errors are being found in IC rather than IR, the ICINTERR.dat file will be the one written to, rather than IRINTERR.dat.

You can do one of two things to try to determine the specific errors:

1) Run the WSM integrity check because it automatically will ask if you want to fix errors. IC and IR would have to be checked at the same time; you can't use the single item check.

2) Configure DataCare to only check IC and IR, and none of the other Start List items (to speed things up), and run DataCare for all data in Interactive mode.

In either case, I believe that when an error is found, it will display on the screen exactly what the error is for which item, and the values expected in both programs. The same information should be written to the xxINTERR.dat file as well. If you choose to fix the error, it will be fixed for the program but will become a new error for the other program.

I understand this can be frustrating, especially when the full information is not being reported. My instinct is that once you determine which quantity is correct, the data will have to be repaired so that the quantities match on the correct number.

Hi Softrak,

I set up a start list to try both of your suggested solutions. WSM Check Integrity found and corrected the 7 errors. It reported them to be "IC Account Set GL Account number changed". I've had this error before and running WSM Check Integrity on just IR caught and fixed the errors. For whatever reason it missed them when I ran it last week.
Thanks so much for your help.

Al