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

      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)]

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

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

              Created:
              Updated:
              Resolved: