Tuesday, May 19, 2020

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

While maintaining dimension data in BPC via web BPC Administration Client there can be following message popping up:

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

There can be many different reasons for this issue. Most likely, there is already a record with same name. E.g., one record is put in lower case whereas second one is in capitals. It is tricky to reveal what is an issue as from the BPC Administration Client the problematic record is normally not shown.

Issue can be solved using ABAP program UJA_REFRESH_DIM_CACHE. To use it just specify environment ID and dimension in which problem occurred.



More information:

2523994 - BPC NW 10.1:Error when processing dimension
2867588 - Error "The system tried to insert a data record, even though a data record with the same primary key already exists" when processing dimension in BPC Web Admin