org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,10000][propertyKey,login.previousLoginMillis][type,5][entityName,OSUser] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null))

Atlassian JIRA | Ruchi Tandon[Atlassian] | 5 years ago
  1. 0

    h3. Summary In certain situations it is possible for OfBiz sequences to reach a certain size that prevents additional sequences from being created. h3. Steps to Reproduce # Install JIRA with a MySQL database. # Shutdown JIRA. # Log into MySQL. # Perform the below query: {code:SQL} UPDATE SEQUENCE_VALUE_ITEM SET SEQ_ID = 2147483648; {code} (i) This will update all sequences to that sequence ID. # Start JIRA. h3. Expected Results JIRA will continue to operate as normal. h3. Actual Results Either of the following: * JIRA will be locked * You'll be unable to login, due to errors in inserting into {{propertyentry}} table. The below errors can be found in the Catalina log: {noformat}2011-12-21 16:02:37,239 http-5555-2 WARN anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='OSPropertyEntry' Error was: 2011-12-21 16:02:37,319 http-5555-2 WARN anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [ofbiz.core.entity.SequenceUtil] '2.147483648E9' in column '1' is outside valid range for the datatype INTEGER. 2011-12-21 16:02:37,319 http-5555-2 ERROR anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null 2011-12-21 16:02:37,322 http-5555-2 ERROR anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [module.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,10000][propertyKey,login.previousLoginMillis][type,5][entityName,OSUser] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149) at org.ofbiz.core.entity.GenericDAO.singleStore(GenericDAO.java:268) at org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:311) at org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182) at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570) at com.opensymphony.module.propertyset.AbstractPropertySet.setString(AbstractPropertySet.java:368) at com.atlassian.jira.propertyset.JiraCachingPropertySet.setString(JiraCachingPropertySet.java:615) {noformat} h3. Notes According to entitymodel.xml column SEQ_ID in table SEQUENCE_VALUE_ITEM defined with numeric type {code} <entity entity-name="SequenceValueItem" table-name="SEQUENCE_VALUE_ITEM" package-name=""> <field name="seqName" type="id-long-ne"/> <field name="seqId" type="numeric"/> <prim-key field="seqName"/> </entity> {code} Which for Mysql defined (in fieldtype-mysql.xml) as decimal(18,0) and mapped to a Java Long: {code} <field-type-def type="numeric" sql-type="DECIMAL(18,0)" java-type="Long"><validate name="isSignedLong" /></field-type-def> {code} In {{SequenceUtil}} in {{ofbcore-jira-entity-2.1.7.jar}} in lines 205, 237 called method {{ResultSet.getInt}}, instead of {{ResultSet.getLong}}. This causes total JIRA unavailability after one of Sequence (in our case {{OSPropertyEntry}}) surpasses the border of the upper signed integer limit. This limit is {{Integer.MAX_VALUE, 2147483647}}.

    Atlassian JIRA | 5 years ago | Ruchi Tandon[Atlassian]
    org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,10000][propertyKey,login.previousLoginMillis][type,5][entityName,OSUser] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null))
  2. 0

    h3. Summary In certain situations it is possible for OfBiz sequences to reach a certain size that prevents additional sequences from being created. h3. Steps to Reproduce # Install JIRA with a MySQL database. # Shutdown JIRA. # Log into MySQL. # Perform the below query: {code:SQL} UPDATE SEQUENCE_VALUE_ITEM SET SEQ_ID = 2147483648; {code} (i) This will update all sequences to that sequence ID. # Start JIRA. h3. Expected Results JIRA will continue to operate as normal. h3. Actual Results Either of the following: * JIRA will be locked * You'll be unable to login, due to errors in inserting into {{propertyentry}} table. The below errors can be found in the Catalina log: {noformat}2011-12-21 16:02:37,239 http-5555-2 WARN anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='OSPropertyEntry' Error was: 2011-12-21 16:02:37,319 http-5555-2 WARN anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [ofbiz.core.entity.SequenceUtil] '2.147483648E9' in column '1' is outside valid range for the datatype INTEGER. 2011-12-21 16:02:37,319 http-5555-2 ERROR anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null 2011-12-21 16:02:37,322 http-5555-2 ERROR anonymous 962x10x1 1hglwcn 0:0:0:0:0:0:0:1%0 /rest/gadget/1.0/login [module.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,10000][propertyKey,login.previousLoginMillis][type,5][entityName,OSUser] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149) at org.ofbiz.core.entity.GenericDAO.singleStore(GenericDAO.java:268) at org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:311) at org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182) at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570) at com.opensymphony.module.propertyset.AbstractPropertySet.setString(AbstractPropertySet.java:368) at com.atlassian.jira.propertyset.JiraCachingPropertySet.setString(JiraCachingPropertySet.java:615) {noformat} h3. Notes According to entitymodel.xml column SEQ_ID in table SEQUENCE_VALUE_ITEM defined with numeric type {code} <entity entity-name="SequenceValueItem" table-name="SEQUENCE_VALUE_ITEM" package-name=""> <field name="seqName" type="id-long-ne"/> <field name="seqId" type="numeric"/> <prim-key field="seqName"/> </entity> {code} Which for Mysql defined (in fieldtype-mysql.xml) as decimal(18,0) and mapped to a Java Long: {code} <field-type-def type="numeric" sql-type="DECIMAL(18,0)" java-type="Long"><validate name="isSignedLong" /></field-type-def> {code} In {{SequenceUtil}} in {{ofbcore-jira-entity-2.1.7.jar}} in lines 205, 237 called method {{ResultSet.getInt}}, instead of {{ResultSet.getLong}}. This causes total JIRA unavailability after one of Sequence (in our case {{OSPropertyEntry}}) surpasses the border of the upper signed integer limit. This limit is {{Integer.MAX_VALUE, 2147483647}}.

    Atlassian JIRA | 5 years ago | Ruchi Tandon[Atlassian]
    org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,10000][propertyKey,login.previousLoginMillis][type,5][entityName,OSUser] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null))
  3. 0

    While importing a project from a JIRA backup the import fails with the following error. {noformat} The import was aborted because there were too many errors. Some errors are listed below. For full details about the errors please see your logs. Please note that some elements have been created. You may want to consult your logs to see what caused the errors, delete the project, and perform the import again. {noformat} A few of the following errors can be found in the JIRA logs {noformat} 2015-01-17 15:01:50,542 ProjectImport: CreateIssueRelatedData-10 ERROR admin 901x156x1 4bmvmr 127.0.0.1 /secure/admin/ProjectImportSummary.jspa [jira.imports.project.DefaultProjectImportPersister] DataAccessException occured while trying to create Entity type 'EntityProperty' . {id=10031, entityName=IssueProperty, entityId=10115, propertyKey=request.channel.type, value="Portal", created=2015-01-08 18:51:44.178, updated=2015-01-08 18:51:44.178} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:397) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.imports.project.DefaultProjectImportPersister.createEntity(DefaultProjectImportPersister.java:192) at com.atlassian.jira.imports.project.handler.EntityPropertiesPersisterHandler$1.run(EntityPropertiesPersisterHandler.java:63) at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:695) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:392) ... 7 more {noformat} *Steps to reproduce* # Get a JIRA backup from an instance with at least 20 Issue entities for a single project. e.g. create 10 issues with JIRA Service Desk. Each will add 3 issue entities ** You can verify that with the following SQL query {code:SQL}select * from entity_property where entity_name = 'IssueProperty'{code} # Import the project into another JIRA instance already containing data in the entity_property for the same IDs displayed in the query above *Expected results* JIRA Should import the project without any problems, using the next ID available for the entity_property table *Actual results* JIRA aborts the import as it tries to use the same IDs to add the respective Issue properties to the entity_properties table *Workaround* As a workaround you can change the EntityProperty IDs _directly in the entities.xml file of the backup_. # Find entity IDs to change for the project. Run this at source JIRA Insert your project key into this query: {code:sql} SELECT EP.id FROM entity_property EP, jiraissue I, project P WHERE EP.entity_name = 'IssueProperty' AND I.id = EP.entity_id AND P.id = I.project AND P.pkey = 'YOUR_PROJECT_KEY' ORDER BY EP.id; {code} # Determine the current MAX(id), run this at target JIRA: {code:sql} SELECT MAX(id) FROM entity_property {code} # Modify the XML backup file, replacing the entity_property IDs with sequential numbers higher than MAX(id) from the entity_property table. #* Make sure you only modify XML nodes that begin with "<EntityProperty id=". If the entities.xml file is large you may need to use vi or another editor that can handle really big files. # Complete the import # Shut down the target instance # Reset the sequence_value_item table for EntityProperty types, run this at target JIRA: {code:sql} UPDATE sequence_value_item SET seq_id = (SELECT MAX(id)+100 FROM entity_property) WHERE seq_name = 'EntityProperty'; {code} # Restart the target instance See KB for more detailed steps and simplified option to modify the XML backup file: [Project Import fails due to too many errors|https://confluence.atlassian.com/display/JIRAKB/Project+Import+fails+due+to+too+many+errors]

    Atlassian JIRA | 2 years ago | Marcus Silveira [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    While importing a project from a JIRA backup the import fails with the following error. {noformat} The import was aborted because there were too many errors. Some errors are listed below. For full details about the errors please see your logs. Please note that some elements have been created. You may want to consult your logs to see what caused the errors, delete the project, and perform the import again. {noformat} A few of the following errors can be found in the JIRA logs {noformat} 2015-01-17 15:01:50,542 ProjectImport: CreateIssueRelatedData-10 ERROR admin 901x156x1 4bmvmr 127.0.0.1 /secure/admin/ProjectImportSummary.jspa [jira.imports.project.DefaultProjectImportPersister] DataAccessException occured while trying to create Entity type 'EntityProperty' . {id=10031, entityName=IssueProperty, entityId=10115, propertyKey=request.channel.type, value="Portal", created=2015-01-08 18:51:44.178, updated=2015-01-08 18:51:44.178} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:397) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.imports.project.DefaultProjectImportPersister.createEntity(DefaultProjectImportPersister.java:192) at com.atlassian.jira.imports.project.handler.EntityPropertiesPersisterHandler$1.run(EntityPropertiesPersisterHandler.java:63) at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:695) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:392) ... 7 more {noformat} *Steps to reproduce* # Get a JIRA backup from an instance with at least 20 Issue entities for a single project. e.g. create 10 issues with JIRA Service Desk. Each will add 3 issue entities ** You can verify that with the following SQL query {code:SQL}select * from entity_property where entity_name = 'IssueProperty'{code} # Import the project into another JIRA instance already containing data in the entity_property for the same IDs displayed in the query above *Expected results* JIRA Should import the project without any problems, using the next ID available for the entity_property table *Actual results* JIRA aborts the import as it tries to use the same IDs to add the respective Issue properties to the entity_properties table *Workaround* As a workaround you can change the EntityProperty IDs _directly in the entities.xml file of the backup_. # Find entity IDs to change for the project. Run this at source JIRA Insert your project key into this query: {code:sql} SELECT EP.id FROM entity_property EP, jiraissue I, project P WHERE EP.entity_name = 'IssueProperty' AND I.id = EP.entity_id AND P.id = I.project AND P.pkey = 'YOUR_PROJECT_KEY' ORDER BY EP.id; {code} # Determine the current MAX(id), run this at target JIRA: {code:sql} SELECT MAX(id) FROM entity_property {code} # Modify the XML backup file, replacing the entity_property IDs with sequential numbers higher than MAX(id) from the entity_property table. #* Make sure you only modify XML nodes that begin with "<EntityProperty id=". If the entities.xml file is large you may need to use vi or another editor that can handle really big files. # Complete the import # Shut down the target instance # Reset the sequence_value_item table for EntityProperty types, run this at target JIRA: {code:sql} UPDATE sequence_value_item SET seq_id = (SELECT MAX(id)+100 FROM entity_property) WHERE seq_name = 'EntityProperty'; {code} # Restart the target instance See KB for more detailed steps and simplified option to modify the XML backup file: [Project Import fails due to too many errors|https://confluence.atlassian.com/display/JIRAKB/Project+Import+fails+due+to+too+many+errors]

    Atlassian JIRA | 2 years ago | Marcus Silveira [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.))
  6. 0

    Add a doc that the *no count* setting should not be set for MS SQL Server. Further details on this setting are available at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_3ed0.asp This setting will result in errors where JIRA attempts to retrieve the next sequential ID based on the value returned from executed statements. The doc should include screenshots as how to unset this setting following these instructions: This can be verified by clicking on the server from within the SQL Server Management screen. From here, please select the *Connections* option and verify that the *no count* setting is not checked within the *Default connection options* section. The following stacktrace relates to this issue and should be referenced in the doc: {code} 2006-05-03 15:51:24,331 INFO [atlassian.jira.upgrade.ConsistencyCheckImpl] Could not find Issue Cache Listener, adding. 2006-05-03 15:51:26,088 WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] first select failed: trying to add row, result set was empty for sequence: ListenerConfig 2006-05-03 15:51:26,093 WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] first select failed: trying to add row, result set was empty for sequence: ListenerConfig 2006-05-03 15:51:26,094 ERROR [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null 2006-05-03 15:51:26,112 ERROR [atlassian.jira.upgrade.ConsistencyCheckImpl] Error adding listener: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ListenerConfig][clazz,com.atlassian.jira.event.listeners.cache.IssueCacheListener][name,Issue Cache Listener][id,null] (SQL exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.)) org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ListenerConfig][clazz,com.atlassian.jira.event.listeners.cache.IssueCacheListener][name,Issue Cache Listener][id,null] (SQL Exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123) 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) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:375) 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) 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) {code}

    Atlassian JIRA | 1 decade ago | Keith Brophy
    org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ListenerConfig][clazz,com.atlassian.jira.event.listeners.cache.IssueCacheListener][name,Issue Cache Listener][id,null] (SQL Exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.ofbiz.core.entity.GenericEntityException

      while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,10000][propertyKey,login.previousLoginMillis][type,5][entityName,OSUser] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null))

      at org.ofbiz.core.entity.GenericDAO.singleInsert()
    2. org.ofbiz.core
      GenericDelegator.storeAll
      1. org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149)
      2. org.ofbiz.core.entity.GenericDAO.singleStore(GenericDAO.java:268)
      3. org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:311)
      4. org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221)
      5. org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482)
      6. org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428)
      6 frames
    3. com.opensymphony.module
      AbstractPropertySet.setString
      1. com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182)
      2. com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570)
      3. com.opensymphony.module.propertyset.AbstractPropertySet.setString(AbstractPropertySet.java:368)
      3 frames
    4. com.atlassian.jira
      JiraCachingPropertySet.setString
      1. com.atlassian.jira.propertyset.JiraCachingPropertySet.setString(JiraCachingPropertySet.java:615)
      1 frame