Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-2700

SQL Error: Violation of unique index: SYS_PK_OS_CURRENTSTEP in statement

    XMLWordPrintable

Details

    Description

      Fails to create issues on the following errors:

      com.opensymphony.workflow.InternalWorkflowException: Could not create new current step for #10326

      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSCurrentStep][startDate,2003-11-18 11:09:09.959][owner,null][s\
      tepId,1][finishDate,null][actionId,0][dueDate,null][entryId,10326][status,Un-assigned][id,11236] (SQL Exception while executing the following\
      :INSERT INTO OS_CURRENTSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, \
      ?, ?, ?, ?, ?, ?) (Violation of unique index: SYS_PK_OS_CURRENTSTEP in statement [INSERT INTO OS_CURRENTSTEP (ID, ENTRY_ID, STEP_ID, ACTION_I\
      D, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (11236, 10326, 1, 0, NULL, '2003-11-18 11:09:09.959', NULL, NULL, 'Un-ass\
      igned', NULL)]))

      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OS_CURRENTSTEP (ID, ENTRY_ID, STEP_\
      ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Violation of unique index: SY\
      S_PK_OS_CURRENTSTEP in statement [INSERT INTO OS_CURRENTSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STA\
      TUS, CALLER) VALUES (11236, 10326, 1, 0, NULL, '2003-11-18 11:09:09.959', NULL, NULL, 'Un-assigned', NULL)])

      java.sql.SQLException: Violation of unique index: SYS_PK_OS_CURRENTSTEP in statement [INSERT INTO OS_CURRENTSTEP (ID, ENTRY_ID, STEP_ID, ACTI\
      ON_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (11236, 10326, 1, 0, NULL, '2003-11-18 11:09:09.959', NULL, NULL, 'Un\
      -assigned', NULL)]

      Attachments

        1. Sample.jpg
          10 kB
          abarolia
        2. os_wfentry-query.txt
          8 kB
          Jeremy Wohl
        3. jiraissue-query.txt
          8 kB
          Jeremy Wohl
        4. unique_violation.txt
          30 kB
          Jeremy Wohl

        Issue Links

          Activity

            People

              anton@atlassian.com AntonA
              bffd219104ac Jeremy Wohl
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: