Unable to Delete the issues in jira

Anshuman Bakshi April 18, 2019

We are getting below error while trying to delete the issues. 

Request assistance

Copy the content below and send it to your JIRA Administrator

Technical details

Log's referral number: 0664da61-bc11-4786-b66d-4368f40393f9

Cause

 

com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
	- name:Oracle
	- version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
	- minor version:1
	- major version:12
Driver:
	- name:Oracle JDBC driver
	- version:12.2.0.1.0

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("JIRA_DB_USER"."AO_60DB71_LEXORANK"."ID")
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: 

2 answers

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 22, 2019

I suspect a bug in the Oracle database driver you have.  What version of Jira do you have?

Anshuman Bakshi April 23, 2019

We are using Jira 7.6 Version. We performed Alignment of UAT server with Prod and restored the Prod data to UAT. 

I checked the JDBC driver of Prod and UAT server and both are same. 

 

Any thoughts ?

Divya TV June 30, 2020

We have the same problem. Do you have any solutions?

0 votes
Anshuman Bakshi April 22, 2019

Any Suggestions for this ?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events