SAP Knowledge Base Article - Preview

2399027 - BPC NW Error: Data record with the same primary key already exists

Symptom

After upgrading to a higher Service Pack level in BW, BPC and EPM Add-In, the following error occurs when running Data Manager Package "Import Hierarchy from BW Infoprovider" and "Import Mater Data from BW Infoprovider":

"An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause.

The system tried to insert a data record, even though a data record with the same primary key already exists.

Package status: ERROR"

Capture.JPG

The packages run successfully when executed in the backend via UJ_PACKAGE_TEST.


Read more...

Environment

SAP Business Planning and Consolidation (BPC) version for SAP Netweaver (NW) 10.0

SAP Business Planning and Consolidation (BPC) version for SAP Netweaver (NW) 10.1

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP NetWeaver 7.4

Keywords

Business Planning and Consolidation, upgrade, DM, Data Manager, package link, import package, CX_SY_OPEN_SQL_DB , KBA , problem , EPM-BPC-NW , NetWeaver Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.