com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint))

Atlassian JIRA | Brenden Bain [Atlassian] | 6 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    When starting up JIRA under a Turkish locale you are unable to create issues. It looks like Ofbiz is being hit by http://www.mattryall.net/blog/2009/02/the-infamous-turkish-locale-bug. You get the following warnings and errors: {noformat} 2010-09-29 11:13:57,092 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: ALTER TABLE public.favouriteassociations ADD ID NUMERIC(18,0) Error was: org.postgresql.util.PSQLException: ERROR: column "id" of relation "favouriteassociations" already exists 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "DESCR?PT?ON" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "F?ELD?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "CUSTOMF?ELD" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Field "description" of entity "FieldConfigScheme" is missing its corresponding column "DESCRIPTION" 2010-09-29 11:13:57,093 main ERROR [core.entity.jdbc.DatabaseUtil] Could not add column "DESCRIPTION" to table "public.fieldconfigscheme" 2010-09-29 11:13:57,093 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: {noformat} {noformat} 2010-09-29 11:14:15,285 main WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig' Error was: 2010-09-29 11:14:15,285 main WARN [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?. 2010-09-29 11:14:15,286 main WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig' Error was: 2010-09-29 11:14:15,286 main WARN [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?. 2010-09-29 11:14:15,286 main ERROR [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null 2010-09-29 11:14:15,288 main ERROR [sal.jira.scheduling.JiraPluginScheduler] Error adding service to jira org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ServiceConfig][id,null][time,28800000][name,Service Provider Token Remover][clazz,com.atlassian.sal.jira.scheduling.JiraPluginSchedule rService] (SQL Exception while executing the following:INSERT INTO public.serviceconfig (ID, delaytime, CLAZZ, servicename) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149) {noformat} {noformat} 2010-09-29 12:49:20,291 http-8090-Processor6 ERROR admin 769x2237x1 vqg7s 0:0:0:0:0:0:0:1%0 /secure/CreateIssueDetails.jspa [atlassian.jira.workflow.SimpleWorkflowManager] Error occured while creating issue. com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint)) at com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.createEntry(OfbizWorkflowStore.java:119) {noformat} h5. Work around The only workaround is to start JIRA under a non-Turkish locale. You can still see JIRA in Turkish when you do this. Check out JRA-22386 for details on how to do this.

    Atlassian JIRA | 6 years ago | Brenden Bain [Atlassian]
    com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint))
  2. 0

    When starting up JIRA under a Turkish locale you are unable to create issues. It looks like Ofbiz is being hit by http://www.mattryall.net/blog/2009/02/the-infamous-turkish-locale-bug. You get the following warnings and errors: {noformat} 2010-09-29 11:13:57,092 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: ALTER TABLE public.favouriteassociations ADD ID NUMERIC(18,0) Error was: org.postgresql.util.PSQLException: ERROR: column "id" of relation "favouriteassociations" already exists 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "DESCR?PT?ON" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "F?ELD?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "CUSTOMF?ELD" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Field "description" of entity "FieldConfigScheme" is missing its corresponding column "DESCRIPTION" 2010-09-29 11:13:57,093 main ERROR [core.entity.jdbc.DatabaseUtil] Could not add column "DESCRIPTION" to table "public.fieldconfigscheme" 2010-09-29 11:13:57,093 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: {noformat} {noformat} 2010-09-29 11:14:15,285 main WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig' Error was: 2010-09-29 11:14:15,285 main WARN [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?. 2010-09-29 11:14:15,286 main WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig' Error was: 2010-09-29 11:14:15,286 main WARN [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?. 2010-09-29 11:14:15,286 main ERROR [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null 2010-09-29 11:14:15,288 main ERROR [sal.jira.scheduling.JiraPluginScheduler] Error adding service to jira org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ServiceConfig][id,null][time,28800000][name,Service Provider Token Remover][clazz,com.atlassian.sal.jira.scheduling.JiraPluginSchedule rService] (SQL Exception while executing the following:INSERT INTO public.serviceconfig (ID, delaytime, CLAZZ, servicename) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149) {noformat} {noformat} 2010-09-29 12:49:20,291 http-8090-Processor6 ERROR admin 769x2237x1 vqg7s 0:0:0:0:0:0:0:1%0 /secure/CreateIssueDetails.jspa [atlassian.jira.workflow.SimpleWorkflowManager] Error occured while creating issue. com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint)) at com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.createEntry(OfbizWorkflowStore.java:119) {noformat} h5. Work around The only workaround is to start JIRA under a non-Turkish locale. You can still see JIRA in Turkish when you do this. Check out JRA-22386 for details on how to do this.

    Atlassian JIRA | 6 years ago | Brenden Bain [Atlassian]
    com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint))

    Root Cause Analysis

    1. com.opensymphony.workflow.StoreException

      Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint))

      at com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.createEntry()
    2. com.opensymphony.workflow
      OfbizWorkflowStore.createEntry
      1. com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.createEntry(OfbizWorkflowStore.java:119)
      1 frame