org.ofbiz.core.entity.GenericEntityException in Jira 4.4.5

Hi Team,

I am facing the org.ofbiz.core.entity.GenericEntityException in Jira 4.4.5

When a user tries to Withdraw a defect ( Withdraw is one of the Workflow transitions after creating a defect). then the below error message is thrown:

org.ofbiz.core.entity.GenericEntityException ( SQL Exception while executing the following ; INSERT INTO changegroup ( ID, issueid, Author, Created) values ( ?,?,?,? ) ( ORA-01400 : Cannot insert NULL into ('JIRADB,"CHANGEGROUP","ID")))

Please let me know how to resolve this error.



2 answers

Hi Team,

Any update on this! ?

0 votes
Richie Gee Atlassian Team Aug 12, 2013

Hi Harish,

I have noticed this question far too late, from what I can understand from the logs, the reason behind this error is:

ORA-01400 : Cannot insert NULL into ('JIRADB,"CHANGEGROUP","ID")

Which means during the action, it attempts to insert NULL value into a column that restricts NULL therefore it return this error.

It could be due to various reason behind this, and for database related problem, you could write in to and our support team will be there to assist you troubleshoot further what could have caused this.

If you have managed to find a solution to this, please do share your resolution so that the community can benifit from there :) Cheers :)

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,887 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot