Skip to Content

How to find duplicate key in NLS?

Hi experts,

we are using HANA and NLS to archive data.

Currently we are facing the following problem:

due to rebookings in former periods we have load data back from the NLS-archive to the original DSO. This doesn´t work for the given period. According to the error message there´s a duplicate key error.

Our key in the DSO:

- 0FISCVARNT ("Fiscal Year Variant")

- 0DOC_NUMBER ("Sales Document")

- 0S_ORD_ITEM ("Position")

As 0FISCVARNT is set to "K4" and 0S_ORD_ITEM only sorts the lines in 0DOC_NUMBER the latter is the field that seems to be as well in actual BW as well as archived in NLS.

My Task now is to find the specific 0DOC_NUMBER(s) that is (are) doubled. I tried to use one of our BEx-Queries, but the amount of data exceeds data-limits of the infoprovider. I do get data out of the specific DSO.

But how am I able to get data with the keys from NLS to be able to identify the specific duplicate data set?

thx a lot for your help in advance,

Thomas

PS: here the error-message in NLS-protocol (in German, hope that is OK though)

Ausnahmebedingung DBSQL_DUPLICATE_KEY_ERROR in Zeile 15 des Include CL_RSDA_INFOPROV_WRITE

Ausnahmebedingung UNCAUGHT_EXCEPTION in Zeile 1 des Include CL_RSDA_INFOPROV_WRITER_ODSO==

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 03, 2015 at 01:20 PM

    Hi Thomas,

    did you already find your solution?

    I had the same issue and created a copy of the DSO.

    Then extracted the data from source DSO and NLS into the copy.

    Can give you the details, if still open.

    BR, Martin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.