Skip to main content
Solved

Update flow for Delta Export

  • October 24, 2024
  • 2 replies
  • 13 views
D
Data Pioneer

We are getting errors in the delta update flow for party and policy master and this is the error message.

 

“com.ataccama.nme.core.NmeExecutionException: Plan "/opt/ataccama/one/mdm-server-config-13.9.1.221107-11165-6e37fd24/Files/engine/export/Party_Master_Delta.comp" execution failed: runtime.error.sql.instance.processError - Transaction (Process ID 901) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim.”

 

Please advice if any help can be provided.Thanks !!

Best answer by ivysakh

Hi @debashishghosh ,

Could you provide a quick overview of the steps in this export plan? Since it is a deadlock error, I suspect it might be related to some custom database operations.

Is it possible that you're updating or inserting into the same table from two different steps within the plan? This could potentially lead to the deadlock situation we're encountering.

Any insights you can share about the plan's logic and database interactions would be greatly appreciated.

View original
    Did this topic help you find an answer to your question?

    2 replies

    ivysakh
    Space Explorer
    Forum|alt.badge.img+3
    • ivysakhSpace Explorer
    • Space Explorer
    • 22 replies
    • Answer
    • October 30, 2024

    Hi @debashishghosh ,

    Could you provide a quick overview of the steps in this export plan? Since it is a deadlock error, I suspect it might be related to some custom database operations.

    Is it possible that you're updating or inserting into the same table from two different steps within the plan? This could potentially lead to the deadlock situation we're encountering.

    Any insights you can share about the plan's logic and database interactions would be greatly appreciated.

    Vysakh Indrasenan
    Cansu
    1 person likes this
    • Cansu
      Cansu
    Cansu
    Community Manager
    Forum|alt.badge.img+3
    • CansuCommunity Manager
    • Community Manager
    • 608 replies
    • November 21, 2024

    Hi ​@debashishghosh I’m closing this thread for now, if you have any follow up questions please share them in the comments or create a new post 🙋‍♀️

    Check out our Quick Start Guide to get started on the community 🙋‍♀️

    Reply


    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings