ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Part Missing, unable to re-add
http://www.istechforum.com/YaBB.pl?num=1626891210

Message started by gtladmin on 07/21/21 at 11:13:30

Title: Part Missing, unable to re-add
Post by gtladmin on 07/21/21 at 11:13:30

Something happened in Evo and we have a part L521-G that at the DB level is in the MTICMSTR and BKICLOC table, but missing from the BKICMSTR. In our test company
trying to re-add it to the BKICMSTR table (using MDB, just the part #) going into IN-B and attempting to add it or have it re-create itself does not work. In fact, in IN-B (or IN-A), typing in the part # brings up a completely different part #! WT? We tried to delete the different part # in the test company via MDB (it's obsolete) and it displays an error wtasdatam.src line 1090 and says there is no active record in the table so you cannot delete it. We click on OK. The error goes away. We go into IN-A or IN-B and it still insists on bringing up the different part #, so we cannot create the part #.

We have orders we need to fulfill for the L521-G part and need help figuring out how to fix or at least get around this. They also tried copying the base part L521 to a new part L521-G and when you click on OK to create the part that darn different part # shows and a message comes up and tells us the part # already exists in inventory. ????? :o :'(

HELP!!!

Val

Title: Re: Part Missing, unable to re-add
Post by AllanMac on 07/21/21 at 19:19:54

Maybe delete from MTICMSTR and BKICLOC then re-create using IN-B.

Has someone done a change to an item number through SM-J-D?

Title: Re: Part Missing, unable to re-add
Post by gtladmin on 07/22/21 at 05:45:28

So do you mean delete from BOTH tables before trying to re-add? We can try that in our test company.

We are seeing that this may be an index or key issue as there are other things going on. Specifically, when in IN-A and in the list or lookup mode, scrolling thru the records seems to "loop", getting to a certain point in the table and then the records seem to jump back to a previously scrolled by record. It happens at different points in the lookup list. Also, running SM-J-C seems to do that same thing, getting stuck at one point in the process and staying there forever.

Would this be a index or key issue, and if so how do we fix that? There are no reported Btrieve errors, corruption or otherwise, in the log files.

Anybody? We are getting more desperate here, it's killing us.

Title: Re: Part Missing, unable to re-add
Post by gtladmin on 07/22/21 at 07:39:03

Fixed it ourselves. :)

In the test company we deleted what we determined to be the culprit part, and then ran a reindex on the table. Verified we could scroll thru the part list top to bottom and bottom to top without the looping. Successfully re-added the part in IN-B, and it looked good. Reversed the work in the test co, and had showed what we did for the manufacturing dir, asking him to re-do our steps in the test co to make sure they were reproducible. They were, he successfully re-added the part. Performed the same delete part then reindex the table then test the part list scrolling then added the part all in the production company and everything looks fine now.

Val

Title: Re: Part Missing, unable to re-add
Post by gtladmin on 07/22/21 at 08:01:47

OMG spoke too soon.

Holly just went to run an inventory report (in-f?) and she's getting errors "unable to find the BKICMSTR record" for many parts. This didn't work at all.
rolling back to a backup. :-( Not sure why a reindex would cause this mess!!!

Anybody had this happen before?

What a mess

Title: Re: Part Missing, unable to re-add
Post by gtladmin on 07/22/21 at 11:04:49

So we did a few backup restores of the BKICMSTR table, back to a point where the problem appears to have started (on 7/9). We are running an SM-J-C (B) (report mode first) to see what it finds and what will need to be fixed, and then finance will review everything and likely run it for real and then a UT-K-G after that. we found that from the 9th to today, the problem appears to have been worse with records missing in the table. I can't believe no one noticed this when it first occurred. :o

Hopefully these actions of restoring to a known good version and SM-J-C/UT-K-G gets us back to where we should be with the inventory. At least we test our backups to make sure we can restore.

I suppose we'll never know what happened on the 9th to cause all this mess with the BKICMSTR table. :-?

Val

Title: Re: Part Missing, unable to re-add
Post by gtladmin on 07/22/21 at 14:13:05

FYI for anyone reading this: the actions resolved our issue, with one change:. Walter suggested SM-J-C report mode B and clearly that was not correct after we reviewed his report. So we had him run SM-J-C report only for A mode, and that was correct. Ran that for real and once done reviewed the report, looked good according the manufacturing and finance. Holly ran UT-K-G and did an inventory reconciliation, and that also showed things were back to normal and numbers correct for parts. Only 2 missing parts that were just added after the date of the restored BKICMSTR file needed to be re-added.

Everyone is in agreement we are in good shape, so hopefully we have not missed anything else that should have been done!

FWIW, sharing this in case anyone else runs into the same thing in the future.

Val