sharon krewson
Ex Member
|
Allen Well, we had a very odd thing happen yesterday that is probably related. We had a part correctly appear on a work order traveler but it did not show up on the picklist. When I went to look at the part in IN-A nothing came up. This is an old part (type R) with hundreds of transactions. When I ran an inventory transaction report all of the info was there. I then used Crystal to look at the MTICMSTR and BKICMSTR and sure enough it wasn't in the BKICMSTR. But, it was in the MTICMSTR as well as INTXN, WOBOM, etc. I then added it back into the system through IN-B (probably the wrong thing to do) and all of the history linked up to it. When I used Maintain Database to look at the part again I noticed we now have 2 lines for this part in MTICMSTR and only one in BKICMSTR. Also, both files have the same number of records. I am not sure how to check to see if I have this problem with any other parts. Do you know how we got into this mess? And, as of this morning, we are back to classic DBA (ugh!!!!). We have had a lot of instability and have had to reboot our server daily (sometime more than once!). I am suspecting the instability has to do with adding more users in recent months. And, I suspect that one of the times DBA crashed is when we corrupted the file for that part. Thanks for any help you can provide. Sharon (Dave too)
|