Unable to Delete the issues in jira

Question

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:

Divya TV · Answer

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

Anshuman Bakshi_687x5q · Answer

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 ?

Nic Brough -Adaptavist- · Answer

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