XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.11.3
    • 1.11.4
    • None

    Description

      Current Situation

      Sometimes when running the fact plugin an error occured

      [ERROR] - execute: java.lang.Exception: executeFacts: java.lang.Exception: process: java.lang.Exception: synchronizeOrders: java.lang.Exception: synchronizeOrderHistory: java.lang.Exception: error on getInventoryOrderInfoByJobChain: com.sos.hibernate.exceptions.SOSHibernateQueryException: could not extract ResultSet: 1205 Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [select ijc.[NAME] ,ijc.[TITLE] ,io.[IS_RUNTIME_DEFINED] from INVENTORY_ORDERS io ,INVENTORY_JOB_CHAINS ijc ,INVENTORY_INSTANCES ii  where io.[INSTANCE_ID]=ii.[ID] and ijc.[INSTANCE_ID]=ii.[ID] and io.[JOB_CHAIN_NAME]=ijc.[NAME] and ii.[SCHEDULER_ID]= :schedulerId and upper(ii.[HOSTNAME])= :schedulerHostname and ii.[PORT]= :schedulerHttpPort and io.[ORDER_ID]= :orderId and io.[JOB_CHAIN_NAME]= :jobChainName]
      

      Desired Behavior

      The error should not occurr

      Attachments

        Issue Links

          Activity

            People

              re Robert Ehrlich
              ur Uwe Risse
              Santiago Aucejo Petzoldt Santiago Aucejo Petzoldt
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: