ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> SM-J-M Change Customer Code
http://www.istechforum.com/YaBB.pl?num=1297195410

Message started by MikeT on 02/08/11 at 13:03:30

Title: SM-J-M Change Customer Code
Post by MikeT on 02/08/11 at 13:03:30

When we tried Changing Customer code, it got to INVTXN and stopped. We let it run for about and hour and a half but it was still working on that file. Is it going to have to go through all Inventory transactions to change each customer code? We have about 600 we want to change, and it would take forever to do at this rate (if it works).

Title: Re: SM-J-M Change Customer Code
Post by carie on 02/10/11 at 10:25:33

I also had a glitch when I tried to change a customer code last week.

Carie

Title: Re: SM-J-M Change Customer Code
Post by carie on 02/10/11 at 10:34:27

It stuck at the INVTXN. I just went in to try it again - skipped to INVTXN then I got this error when it hit the BKCMCUST file

BTRIEVE error - P;\T2\BKCMCUST.BT2-5

Title: Re: SM-J-M Change Customer Code
Post by dameng on 02/16/11 at 19:50:16

5: The record has a key field containing a duplicate key value
The MicroKernel cannot add or update a record because the record has a key field that contains a duplicate key value for an index that does not allow duplicate values. The MicroKernel also returns this status code when it cannot create an index that does not allow duplicate key values because a duplicate key value already exists.

use MainTain Database to find the record that is duplicated and delete.

Title: Re: SM-J-M Change Customer Code
Post by dbernhard on 02/17/11 at 07:55:45

Hi - Is there an easy way of finding the duplicate record? A report of some kind?

Title: Re: SM-J-M Change Customer Code
Post by GasGiant on 02/17/11 at 08:08:50

Hmmm... maybe grouping of the table... let me think about that. Or maybe PSQL has a duplicate record finder, like Oracle or MSSQL. Looking.

Title: Re: SM-J-M Change Customer Code
Post by dbernhard on 02/17/11 at 08:16:37

Thanks - scanning manually found 1 duplicate, about 1/4 way down - 3/4 to go!

Title: Re: SM-J-M Change Customer Code
Post by GasGiant on 02/17/11 at 08:20:36

Using this query in the Pervasive SQL Data Manager should find dupes

SELECT bkar_custcode FROM BKARCUST GROUP BY bkar_custcode HAVING (COUNT(bkar_custcode) > 1)

Title: Re: SM-J-M Change Customer Code
Post by dbernhard on 02/17/11 at 09:24:32

Thank you
I did not find any customer file names duplicated
But I did find 9 part numbers that were duplicated in the inventory master, and that is where we seem to lock up

Title: Re: SM-J-M Change Customer Code
Post by MikeT on 02/22/11 at 12:07:36

We never got this to work.... but also never got an actual error returned. The program just locks up and we have to kill it in Windows task manager. I will try to see if we have duplicates if that causes problems.