Details

    • Type: Bug Bug
    • Status: Ready for QA Ready for QA (View Workflow)
    • Priority: Normal Normal
    • Resolution: Unresolved
    • Component/s: SRD
    • Labels:
      None Labels
    • Customer:
      OMAN-Tel
    • Product:
      NEP

      Description

      Dear support, Kinly check why solution not highlighted in request 2201

        Activity

        Ayed Bada logged work - 03/Feb/26 12:00 AM
        • Time Spent:
          4 hours
           

          Investigate and fix process

        Abir Messaikeh made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2026-02-06 24:00 (milestone: set planned start date to due date)
        Planned End 2026-02-06 24:00 (milestone: set planned end date to due date)
        Hide
        Abir Messaikeh added a comment -

        as workaround we asked the user to make a start over

        Show
        Abir Messaikeh added a comment - as workaround we asked the user to make a start over
        Ayed Bada made changes -
        Assignee Khaled Khalil [ kkhalil ] Ayed Bada [ abada ]
        Ayed Bada made changes -
        Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
        Ayed Bada made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Ayed Bada made changes -
        Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
        Ayed Bada made changes -
        Attachment SRD_MAIN.bpmn20.xml [ 127414 ]
        Hide
        Ayed Bada added a comment -

        During execution of the SRD process (attached BPMN), i observed the following error:
        ORA-00001: unique constraint (SRD_PROD.SYS_C0063096) violated
        Root Cause:
        This issue occurs in the parallel multi-instance call activity due to a concurrency conflict when Flowable tries to insert multiple activity instances into the database at the same time.
        The problem is intermittent and does not happen on every execution.
        Under high traffic or simultaneous execution, multiple parallel instances may attempt to insert the same activity instance ID, triggering the unique constraint violation.
        When the process is restarted (“Start over”), it usually completes successfully because the timing of the parallel inserts differs, avoiding the collision.
        Solution:
        Remove flowable:completeAsync="true" from the call activity to prevent the activity scope from being completed asynchronously.
        This ensures the multi-instance inserts happen within the same transaction context, eliminating the race condition.

        Show
        Ayed Bada added a comment - During execution of the SRD process (attached BPMN), i observed the following error: ORA-00001: unique constraint (SRD_PROD.SYS_C0063096) violated Root Cause: This issue occurs in the parallel multi-instance call activity due to a concurrency conflict when Flowable tries to insert multiple activity instances into the database at the same time. The problem is intermittent and does not happen on every execution. Under high traffic or simultaneous execution, multiple parallel instances may attempt to insert the same activity instance ID, triggering the unique constraint violation. When the process is restarted (“Start over”), it usually completes successfully because the timing of the parallel inserts differs, avoiding the collision. Solution: Remove flowable:completeAsync="true" from the call activity to prevent the activity scope from being completed asynchronously. This ensures the multi-instance inserts happen within the same transaction context, eliminating the race condition.
        Ayed Bada made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 4 hours [ 14400 ]
        Worklog Id 290531 [ 290531 ]
        Ayed Bada made changes -
        Baseline Start 2026-02-06 24:00 (set baseline based of initial work logging)
        Baseline End 2026-02-06 24:00 (set baseline based of initial work logging)
        Khaled Khalil made changes -
        Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
        Assignee Ayed Bada [ abada ] Abir Messaikeh [ amessaikeh ]
        Hide
        Abir Messaikeh added a comment -

        pending stress test or further tests for variable on staging b4 apply new process on PROD

        Show
        Abir Messaikeh added a comment - pending stress test or further tests for variable on staging b4 apply new process on PROD
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Dev Scheduled Dev Scheduled
        3m 4s 1 Ayed Bada 03/Feb/26 2:20 PM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        8s 1 Ayed Bada 03/Feb/26 2:20 PM
        Implementation in progress Implementation in progress To Be Released To Be Released
        6s 1 Ayed Bada 03/Feb/26 2:20 PM
        To Be Released To Be Released Ready for QA Ready for QA
        7m 50s 1 Khaled Khalil 03/Feb/26 2:28 PM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Abir Messaikeh
            Reporter:
            Abir Messaikeh
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Planned Start:
              Planned End:
              Actual Start:
              Date of Baselining:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 hours
              4h

                Drag and Drop