Skip to Content

SAP BW 7.3(Not HANA) DSO - Adding missing records

I have created a DSO that reads a SQL server's transnational data. This data in by month. I wrote some ABAP that looks at the data and if a month was missed then it adds the record. However I'm getting "Duplicate data record detected". I have bold and italic what i think the issues are but I do not know how to fix. Thanks for your help.

Duplicate data record detected (DS ZKPI_O15, data package: 000001, data record: 145)

Message no. RSODSO_UPDATE019

Diagnosis

During loading, there was a key violation. You tried to save more than one data record with the same semantic key.

The problematic (newly loaded) data record has the following properties:

  • DataStore object: ZKPI_O15
  • Request: 1139153
  • Data package: 000001
  • Data record number: 145

__________________________________________________________________________

Error while writing error stack

Message no. RSODSO_UPDATE029

Diagnosis

An error occurred while data records were being updated to a DataStore object. The incorrect data records should have been written to the DTP error stack. This was not possible.

Possible reasons for this are:

  • The maximum number of data records to be logged was exceeded. Check the setting in the DTP (tab page "Update").
  • The data records to be logged were inconsisistent.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 19, 2017 at 06:12 AM

    does it work without the code? if yes, the issue is the code. but you need to post the code in order to get help.

    if it doesn't work even without the code, the issue is to be found in the file.

    M.

    Add comment
    10|10000 characters needed characters exceeded