Unable to move an issue

[Defny]

Dear Team,

We are getting the attached error while trying to performing move option in jira issue.

Kindly help. Thanks in advance.

[Ignacio Pulgar]

My first thought on reading the error is that there might be some corrupted data in the database, having a NULL where it is expected to have a value and it's colliding with a table constraint.

After a quick research, I read that empty strings are treated as a NULL value by Oracle DBMS, so that might have something to do with the error.

There's a KB article on how to fix a quite similar error here:

https://confluence.atlassian.com/jirakb/ora-01400-error-when-deleting-an-issue-720639157.html

Also have a look at:

https://jira.atlassian.com/browse/JRASERVER-61007

specially the part about database drivers.

Anyway, the research on this particular issue probably needs a deep research, diving into your logs.

I'd suggest opening a ticket with Atlassian Support describing how to reproduce the issue, attaching to the ticket a screenshot of the error and a Support ZIP file.

If you finally fix it, please, add the correct answer here so that other users experiencing the same issue can benefit from it.

Regards and good luck!

[Mikhail_Kopylov]

Hi, debasruti ghosh, 

did you try this https://confluence.atlassian.com/jirakb/troubleshooting-new-ranking-system-issues-779159221.html?