SAP Customer Checkout update issue

[ogperalta]

Hi everybody

I'm trying to update CCO from FP6PL06 to FP8PL16, however, the process get an issue and the update can't finish.

The log show the next message:

ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNQ_IDX_BUSINESSPARTNER_EXTERNALID' defined on 'BUSINESSPARTNER'

[anderson_schmitt]

Hello Omar,

Check in the CCO database if there is any customer with duplicate ExternalID

select ExternalID, count(ExternalID) from BUSINESSPARTNER group by ExternalID having count(ExternalID) >1

Regards,

Anderson

[anderson_schmitt]

HI ogperalta

OK, I suggest you to open an incident, then the support may do a deeper analyze in this case.

Regards,
Anderson

[ogperalta]

Hi anderson.schmitt

I did the exercise with both cases, that is,

1. from FP06PL06 to FP08PL16
2. from FP06PL06 to FP07PL10 and then to FP08PL16

[anderson_schmitt]

Hi ogperalta,

You're welcome.

Now, you're trying to update from FP07 to FP08 and the issue also happens, right?

Share with us the cco log files, please.

Regards,
Anderson

[ogperalta]

Hi anderson.schmitt

Thanks for the reply. The query does not show any duplicate business partners.

In addition to this, the upgrade from FP06PL06 to FP07PL10 completes successfully. The problem occurs when updating to any PL of the FP08