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))

Atlassian JIRA | Brenden Bain [Atlassian] | 7 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 7 years ago | Brenden Bain [Atlassian]
    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))
  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 | 7 years ago | Brenden Bain [Atlassian]
    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))
  3. 0

    [CWD-3147] If a user exists in two directories in an application, and is added to a group in one directory that it was already in the other, clients get duplicate key errors - Atlassian JIRA

    atlassian.com | 2 years ago
    com.atlassian.jira.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Membership][id,10067][membershipType,GROUP_USER][lowerParentName,jira-users][parentId,10013][childId,10014][childName,dmason][lowerChildName,dmason][directoryId,10001][parentName,jira-users] (SQL Exception while executing the following:INSERT INTO public.cwd_membership (ID, parent_id, child_id, membership_type, group_type, parent_name, lower_parent_name, child_name, lower_child_name, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "uk_mem_parent_child_type" Detail: Key (parent_id, child_id, membership_type)=(10013, 10014, GROUP_USER) already exists.))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [JRA-40757] JIRA upgrade fails when DB contains rows in QuartzScheduledJobDetails, FATAL upgrade failure with SQLException ...from com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302 - Atlassian JIRA

    atlassian.com | 1 year ago
    org.ofbiz.core.entity.GenericEntityException: inserting: [GenericEntity:JQRTZJobDetails][jobName,TIMESH EET_SUBSCRIPTION][requestsRecovery, ][isVolatile, ][className,jira.timesheet.plugin.job.TimesheetJob] [isDurable, ][jobGroup,TIMESHEET_SUBSCRIPTION][isStateful, ] (SQL Exception setting value: (Inv alid column type: 2000))
  6. 0

    This error appears when upgrading to 3.2 Enterprise by pointing JIRA to the existing 2.5.3 Professional database 2005-05-16 13:00:05,375 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: null java.lang.NullPointerException at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build83.doUpgrade(UpgradeTask_Build83.java:72) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:669) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:565) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doEditionUpgrade(UpgradeManagerImpl.java:508) at com.atlassian.jira.web.action.admin.SetupLicense.doExecute(SetupLicense.java:103) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) On restart: 2005-05-16 13:02:26,312 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')])) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')])) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:153) at com.atlassian.jira.issue.fields.screen.DefaultFieldScreenStore.createFieldScreen(DefaultFieldScreenStore.java:65) at com.atlassian.jira.issue.fields.screen.CachingFieldScreenStore.createFieldScreen(CachingFieldScreenStore.java:41) at com.atlassian.jira.issue.fields.screen.DefaultFieldScreenManager.createFieldScreen(DefaultFieldScreenManager.java:59) at com.atlassian.jira.issue.fields.screen.FieldScreenImpl.store(FieldScreenImpl.java:185) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build83.doUpgrade(UpgradeTask_Build83.java:68) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:669) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:565) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:393) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:341) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:301) at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:65) at com.caucho.server.http.Application.init(Application.java:1843) at com.caucho.server.http.VirtualHost.init(VirtualHost.java:728) at com.caucho.server.http.ServletServer.initHosts(ServletServer.java:874) at com.caucho.server.http.ServletServer.initInternal(ServletServer.java:719) at com.caucho.server.http.ServletServer.init(ServletServer.java:530) at com.caucho.server.http.ResinServer.init(ResinServer.java:393) at com.caucho.server.http.ResinServer.main(ResinServer.java:1154) at com.caucho.server.http.HttpServer.main(HttpServer.java:103) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')])) 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.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:149) ... 19 more

    Atlassian JIRA | 1 decade ago | Brian Nguyen (HipChat)
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')]))

    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: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()
    2. org.ofbiz.core
      GenericDAO.singleInsert
      1. org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149)
      1 frame