ISTech Support Forum - SM-J-M Change Customer Code

Welcome, Guest. Please Login.

	05/24/25 at 13:19:46 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›

Pages: 1

SM-J-M Change Customer Code (Read 1492 times)

MikeT Member Posts: 58 Gender:	SM-J-M Change Customer Code 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).
Back to top	Michael Tingle G.R. Manufacturing, Inc. Trussville, AL Windows Server 2008 R2 w/ Pervasive v11 50 Users IP Logged

carie Full Member Posts: 209 Gender:	Re: SM-J-M Change Customer Code Reply #1 - 02/10/11 at 10:25:33 I also had a glitch when I tried to change a customer code last week. Carie
Back to top	Evo-ERP Version 2015.2 with Build 7/02/2015 Pervasive 11.3 - 10 licenses / DBA since 2002 Carie Kirk McDantim Inc Helena, Montana IP Logged

carie Full Member Posts: 209 Gender:	Re: SM-J-M Change Customer Code Reply #2 - 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
Back to top	Evo-ERP Version 2015.2 with Build 7/02/2015 Pervasive 11.3 - 10 licenses / DBA since 2002 Carie Kirk McDantim Inc Helena, Montana IP Logged

dameng

Senior Member

DBA / EVO Software
Consultant

Posts: 275
Gender: male

Re: SM-J-M Change Customer Code
Reply #3 - 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.

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net

IP Logged

cdecker Full Member Posts: 117 Gender:	Re: SM-J-M Change Customer Code Reply #4 - 02/17/11 at 07:55:45 Hi - Is there an easy way of finding the duplicate record? A report of some kind?
Back to top	Cheri Decker Awareness Technology, Inc Evo Version 2015.2; Build 7/2/15 Pervasive 10.12/Win2008/Client-server 43 Full/5 DC Users GOLD Support Member Since 2002 IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: SM-J-M Change Customer Code Reply #5 - 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.
Back to top	IP Logged

cdecker Full Member Posts: 117 Gender:	Re: SM-J-M Change Customer Code Reply #6 - 02/17/11 at 08:16:37 Thanks - scanning manually found 1 duplicate, about 1/4 way down - 3/4 to go!
Back to top	Cheri Decker Awareness Technology, Inc Evo Version 2015.2; Build 7/2/15 Pervasive 10.12/Win2008/Client-server 43 Full/5 DC Users GOLD Support Member Since 2002 IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: SM-J-M Change Customer Code Reply #7 - 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)
Back to top	IP Logged

cdecker Full Member Posts: 117 Gender:	Re: SM-J-M Change Customer Code Reply #8 - 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
Back to top	Cheri Decker Awareness Technology, Inc Evo Version 2015.2; Build 7/2/15 Pervasive 10.12/Win2008/Client-server 43 Full/5 DC Users GOLD Support Member Since 2002 IP Logged

MikeT Member Posts: 58 Gender:	Re: SM-J-M Change Customer Code Reply #9 - 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.
Back to top	Michael Tingle G.R. Manufacturing, Inc. Trussville, AL Windows Server 2008 R2 w/ Pervasive v11 50 Users IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›