We are trying to update numerous operations using Mass Operation Replace. Some operations update without a problem, others keep giving us the following error. Any suggestions? Error Detail Description: An error occurred while updating the entries. See the inner exception for details. Inner Excep…

From the Data Dictionary… Part Audit History. Records the Date, User and description of changes made to Part Methods of Manufacture. The index is Company,PartNum,RevisionNum,ChangeDate,ChangeTime,AltMethod If you had the same operation multiple times in the MOM, that might try too update both wi…

Hmm. I don’t think that is it because the error only occurs on a handful of part numbers each time (the same part numbers).

Does the error occur on operations with inspection plans? We experienced this error when getting details from a template job that had an inspection plan tied to one of the operations. Maybe there is something buggy with inspection plans. Something to check.

And do those those part numbers have the same Operation specified multiple times? For example: Op 10 - CUT OP 20 - STRIP Op 30 - CUT etc ... if Operation CUT was being replaced with SLICE, it would try to make two changes to the PartAudit table, and if they happened 0.5 seconds apart, they wouldn…

Yes, the part often has the same operation on multiple times… Each time I run it errors with the part number that is the problem. If I open that part in Eng Workbench, I can manually change the operation, then re-run Mass Part Replace. Then, I get the next part number and do the same manual fix. Som…

This post might help you: [image] BPM, requires a pause for 1 second ERP 10 Hi, any suggestions on how to make a bpm pause for 1 second? The bpm auto approves a PO requisition mandatory action if certain conditions have been met, it is triggered just after the requisition…

Thanks for lead! Would have taken a while to track this down. For others, here is SQL to find the offending parts: select PartNum, count(*) from erp.PartOpr where OpCode = 'OPR1' group by PartNum having count(*)>1 I only had 29 parts with the duplicate operations, so I fixed them manually in EWB.…

Mass Operation Replace - Error - Duplicate Key Row?!

Epicor ERP 10

Rick_Bird (Rick Bird) March 1, 2021, 9:22pm 7

This post might help you:

Topic		Replies	Views
Cost roll-up error duplicate key value Epicor ERP 10 costing	12	1749	December 30, 2020
Duplicate Part - Target Part number already exists Epicor ERP 10 bpm	4	1782	September 8, 2021
An error occurred while updating the entries. See the inner exception for details. (UpdateException) Epicor ERP 10 e10	5	5847	April 28, 2021
Business Layer Exception Epicor ERP 10	5	4147	May 10, 2018
Costing Workbench error: Violation of PRIMARY KEY constraint 'PK_CostPart'. Cannot insert duplicate key in object 'Erp.CostPart' Epicor ERP 10 e10	3	2435	May 11, 2023

Mass Operation Replace - Error - Duplicate Key Row?!

Related topics