1749556 - BPC10 NW: The system tried to insert a data record, even though a data record with the same primary key already exists

A specific member was added to a dimension and when processing the dimension the user receives “Error while processing dimension”. Detail log culminates with it cannot be inserted and the error message is:

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

The Master Data Table for this BPC dimension (on RSA1) does not contain this member.

Other members can be added and the dimension is processed without errors.

Note that related dimensions may appear with status "Yellow" (requiring processing), which can be done successfully.

Additionally, no clear error message is displayed on SLG1, but on SM37, the job logs shows the same error message plus an exception (below)

 
Message text                                                                                                
Message class
Message no.
Message type
The system tried to insert a data record, even though a data record with the same primary key already exists
     00      
    001    
     E      
Job cancelled after system exception ERROR_MESSAGE                                                          
     00      
    564    
     A      

Business Planning and Consolidation 10 for NetWeaver

Cannot add specific Dimension Member process , KBA , EPM-BPC-NW-ADM , Admin , Problem