Issue transition in Jira fails with SQL exception (ERROR: current transaction is aborted, commands ignored until end of transaction block)
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When trying to transition an issue, an error is shown on screen with SQL errors:
1
Could not find current steps for #1234567: root cause: SQL Exception while executing the following:SELECT ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER FROM public.OS_CURRENTSTEP WHERE ENTRY_ID=? (ERROR: current transaction is aborted, commands ignored until end of transaction block)Environment
Jira Software v8.x and onwards
Jira Service Management v4.x and onwards
Diagnosis
The value for one of the field on the transition screen exceeds 255 character
Errors with the following traces appear in the atlassian-jira.log files:
1
SQL Exception while executing the following:INSERT INTO jiraissue (ID, pkey, issuenum, PROJECT, REPORTER, ASSIGNEE, CREATOR, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT, ARCHIVED, ARCHIVEDBY, ARCHIVEDDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255)))Cause
The transition steps contain custom field(s) of type Text and the provided string or value is exceeding the 255 character limit for this field. The Select statement seems to be generated due to after effect of above error i.e. value too long for type character varying(255)
Solution
Edit the Custom field, if any used in the transition steps before performing transition to ensure that it does not exceeds 255 characters, the limit for the field.
Was this helpful?