Cannot insert the value NULL into column 'USER', table 'xxx'; column does not allow nulls. UPDATE fails.
Problem
The following appears in the atlassian-jira.log during database migration to MS SQL server.
java.sql.SQLException: Cannot insert the value NULL into column 'USER', table 'jiradb.JiraDB.AO_60DB71_AUDITENTRY'; column does not allow nulls. UPDATE fails.
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:48)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:74)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:68)
...
Caused by: java.sql.SQLException: Cannot insert the value NULL into column 'USER', table 'jiradb.JiraDB.AO_60DB71_AUDITENTRY'; column does not allow nulls. UPDATE fails.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
...
Diagnosis
JIRA instance has an Agile plugin running on 6.3.13.1.
JIRA Agile : com.pyxis.greenhopper.jira Version : 6.3.13.1 Status : enabled Vendor : Atlassian Description : Agile Project Management for JIRA (Build: #a73d75f118867c66)
Cause
- The above error was thrown because Agile version 6.3.13.1 does not allow null value for the user column, whereby it does in 6.4 version.
Resolution
To rectify this, you can input a dummy username for every null value in USER column under AO_60DB71_AUDITENTRY table.
select * from AO_60DB71_AUDITENTRY where USER is null;
Then insert a dummy username (preferably your username) then restart JIRA Agile plugin.
Last modified on Oct 13, 2016
Powered by Confluence and Scroll Viewport.