This entry already exist in the following table " (ACPR) in SBO 2005A

[Former Member]

Hi All,

I use training database of SBO 2005A SP 01 PL 39.

When updating new business partner (BP), the error message appears from system is this entry already exist in the following table " (ACPR) [ODBC 2035] (message 131-138).

This error is happened after I finished define the contact person. If I skip contact person, BP could be updated. I do creating business partner manually.

When I delete the ACPR entry, it could work well. I use query : delete from acpr where cardcode between 'xx' and 'yy'.

How to resolve the problem without deleting the entry ? does the table has maximum entry in the ACPR ? Thanks in advance

Rgd

John

[Former Member · Accepted solution]

Hi John,

Here are the details of note number 991296.

I hope it helps.

Adrian

Symptom

In certain cases, when trying to update a business partner master data the following error message appears: "This entry already exists in the following table (ACPR)".

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).

Other terms

Update, BP Master Data, History, ACPR, OCPR, "This entry already exists in the following table (ACPR)".

Reason and Prerequisites

Application error.

Solution

In order to confirm whether the above issue affects your DB, please run the following queries:

SELECT T0.CntctCode, T1.Name, T0.CardCode AS 'History Card Code', T1.CardCode AS 'Current Card Code' FROM ACPR T0 INNER JOIN OCPR T1 ON T0.CntctCode = T1.CntctCode AND T0.CardCode <> T1.CardCode

If the query retrieves any results, please contact your Support Center.

[Former Member · Accepted solution]

Hi John,

I am facing the same problem while entering new customer group.

How should I over come it

regards,

Kumar