Skip to Content

DBSQL_DUPLICATE_KEY_ERROR in process chain While 'save Hierarchy' step for 0COSTELEMT

Hello ,

I modified existing process Meta chain and added 'SAVE Hierarchy' Process step in Cost element hierarchy which was missing earlier in process chain and then when the process chain executed - i get below mentioned error and also ST22 Dump attached.

ERROR : DBSQL_DUPLICATE_KEY_ERROR in process chain While 'save Hierarchy' step for 0COSTELEMT

Kindly suggest how to resolve this .

Thank you in advance

st22-dump-1.png

st22-dump-2.png

st22-dump-3.png

Best regards,

Naresh

st22-dump-1.png (70.7 kB)
st22-dump-2.png (97.8 kB)
st22-dump-3.png (96.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 21, 2019 at 02:51 PM

    Hi Naresh,

    Have you reviewed your source data to insure there are no duplicates?

    Is the problem replicated when executed manually in RSA1?

    Did you try running a "Check" before running a "Save" or "Activate" manually in RSA1? Sometimes the Check has more verbose error messages than Save or Activate?

    What version of SAP BW are you using?

    Which database?

    John Hawk

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Johan Hawk ,

      Thanks for you reply.

      1. I have replicated the same manually in RSA1 and it is working fine.

      2. It is working fine with 'SAVE or ACTIVATE' is checked in infopackage and when i excute manually in RSA1.

      3. SAP BW 7.4 SP 17

      4. HANA Database

      5. How to find duplicate entries in in source system ?

      Kindly please suggest.

      Best regards,

      Naresh

  • Posted on Oct 30, 2019 at 02:02 PM

    Hi Naresh,

    To determine if duplicates exist in the source system, you need to analyze the DataSource and determine where its data comes from. Then check the the source tables using SE16 for duplicates.

    My guess is that your source system table does not use the same semantic keys as

    0COSTELEMT. If this is a file load, check the source file. Also check the PSA to ensure that you are loading only one request at a time.

    Good luck,

    John Hawk

    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.