kb:kb_item_150
Table of Contents
KB Item 150
Product
SAP BUSINESS ONE
Product Version (if applicable)
None Defined
Issue
Can not edit BP
Symptom
This entry already exists in the following tables (ACPR) (ODBC-20350 [Message 131-183]
Cause
This problem occurs because of old data in the history table ACPR (Contact Persons - History) that conflicts with current data in OCPR table (Contact Persons).
Resolution Notes
Run the following query on the db. Should be done off hours and db should be backed up prior to running.
DELETE T0 FROM ACPR T0 INNER JOIN OCPR T1 ON T0.CntctCode = T1.CntctCode AND T0.CardCode <> T1.CardCode
KB Type
Solution
Item Date
26 Feb 2013
kb/kb_item_150.txt · Last modified: 2019/01/24 09:44 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
