java.sql.SQLException: Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.


Solutions on the web284

Solution icon of atlassian
via Atlassian JIRA by Keith Brophy, 1 year ago
Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.

Solution icon of atlassian
via Atlassian JIRA by Keith Brophy, 1 year ago
Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.

Solution icon of atlassian
via Atlassian JIRA by Yuri, 1 year ago
Cannot insert the value NULL into column 'ID', table 'jiradb.jiraschema.membershipbase'; column does not allow nulls. INSERT fails.

Solution icon of atlassian
via Atlassian JIRA by Yuri, 1 year ago
Cannot insert the value NULL into column 'ID', table 'jiradb.jiraschema.membershipbase'; column does not allow nulls. INSERT fails.

Solution icon of sourceforge
via jtds by pauer
, 1 year ago
Cannot insert the value NULL into column 'completedFlag', table 'myDB.dbo.Tran'; column does not allow nulls. INSERT fails.

Solution icon of web
Cannot insert the value NULL into column 'PRIORITY', table 'Quartz_Demo.dbo.QRTZ_FIRED_TRIGGERS'; column does not allow nulls. INSERT fails.

Solution icon of web
Cannot insert the value NULL into column 'ADDRESS_ID', table 'sample.dbo.Address2'; column does not allow nulls. INSERT fails.

Solution icon of stackoverflow
Cannot insert the value NULL into column 'created_date', table 'webadmin.dbo.harvesting_task'; column does not allow nulls. INSERT fails.

Solution icon of coderanch
via Coderanch by Babu Singh, 10 months ago
Cannot insert the value NULL into column 'ADDRESS_ID', table 'sample.dbo.Address2'; column does not allow nulls. INSERT fails.

Solution icon of atlassian
via Atlassian JIRA by Piper Keairnes, 1 year ago
Cannot insert the value NULL into column 'POSITION', table 'ConfluenceTest.Confluence.ANCESTORS'; column does not allow nulls. INSERT fails.

Stack trace

java.sql.SQLException: Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:373)
	at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)
	at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
	at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
	at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
	at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
	at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
	at com.atlassian.jira.action.admin.ListenerCreate.execute(ListenerCreate.java:22)
	at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
	at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
	at com.atlassian.jira.upgrade.ConsistencyCheckImpl.ensureSingleListener(ConsistencyCheckImpl.java:669)
	at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkCacheListener(ConsistencyCheckImpl.java:563)
	at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkDataConsistency(ConsistencyCheckImpl.java:306)
	at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl.java:295)
	at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:164)
	at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:27)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:603)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
	at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1195)
	at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

9 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
23 more bugmates