com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM projectroleactor WHERE id IN (?) (Invalid column name 'id'. )

Atlassian JIRA | Jeff Turner | 1 decade 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

    Deleting a group or role breaks with the following exception in Sybase: {noformat} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM projectroleactor WHERE id IN (?) (Invalid column name 'id'. ) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByOr(DefaultOfBizDelegator.java:210) at com.atlassian.jira.security.roles.OfBizProjectRoleAndActorStore.updateRoleActors(OfBizProjectRoleAndActorStore.java:413) at com.atlassian.jira.security.roles.OfBizProjectRoleAndActorStore.updateDefaultRoleActors(OfBizProjectRoleAndActorStore.java:183) at com.atlassian.jira.security.roles.CachingProjectRoleAndActorStore.updateDefaultRoleActors(CachingProjectRoleAndActorStore.java:169) at com.atlassian.jira.security.roles.DefaultProjectRoleManager.updateDefaultRoleActors(DefaultProjectRoleManager.java:161) at com.atlassian.jira.bc.projectroles.DefaultProjectRoleService.updateActorsToDefaultRole(DefaultProjectRoleService.java:854) at com.atlassian.jira.bc.projectroles.DefaultProjectRoleService.removeDefaultActorsFromProjectRole(DefaultProjectRoleService.java:453) at com.atlassian.jira.web.action.admin.roles.GroupRoleActorAction.doUpdate(GroupRoleActorAction.java:64) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) .... {noformat}

    Atlassian JIRA | 1 decade ago | Jeff Turner
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM projectroleactor WHERE id IN (?) (Invalid column name 'id'. )
  2. 0

    Deleting a group or role breaks with the following exception in Sybase: {noformat} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM projectroleactor WHERE id IN (?) (Invalid column name 'id'. ) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByOr(DefaultOfBizDelegator.java:210) at com.atlassian.jira.security.roles.OfBizProjectRoleAndActorStore.updateRoleActors(OfBizProjectRoleAndActorStore.java:413) at com.atlassian.jira.security.roles.OfBizProjectRoleAndActorStore.updateDefaultRoleActors(OfBizProjectRoleAndActorStore.java:183) at com.atlassian.jira.security.roles.CachingProjectRoleAndActorStore.updateDefaultRoleActors(CachingProjectRoleAndActorStore.java:169) at com.atlassian.jira.security.roles.DefaultProjectRoleManager.updateDefaultRoleActors(DefaultProjectRoleManager.java:161) at com.atlassian.jira.bc.projectroles.DefaultProjectRoleService.updateActorsToDefaultRole(DefaultProjectRoleService.java:854) at com.atlassian.jira.bc.projectroles.DefaultProjectRoleService.removeDefaultActorsFromProjectRole(DefaultProjectRoleService.java:453) at com.atlassian.jira.web.action.admin.roles.GroupRoleActorAction.doUpdate(GroupRoleActorAction.java:64) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) .... {noformat}

    Atlassian JIRA | 1 decade ago | Jeff Turner
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM projectroleactor WHERE id IN (?) (Invalid column name 'id'. )

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM projectroleactor WHERE id IN (?) (Invalid column name 'id'. )

      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByOr()
    2. com.atlassian.jira
      GroupRoleActorAction.doUpdate
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByOr(DefaultOfBizDelegator.java:210)
      2. com.atlassian.jira.security.roles.OfBizProjectRoleAndActorStore.updateRoleActors(OfBizProjectRoleAndActorStore.java:413)
      3. com.atlassian.jira.security.roles.OfBizProjectRoleAndActorStore.updateDefaultRoleActors(OfBizProjectRoleAndActorStore.java:183)
      4. com.atlassian.jira.security.roles.CachingProjectRoleAndActorStore.updateDefaultRoleActors(CachingProjectRoleAndActorStore.java:169)
      5. com.atlassian.jira.security.roles.DefaultProjectRoleManager.updateDefaultRoleActors(DefaultProjectRoleManager.java:161)
      6. com.atlassian.jira.bc.projectroles.DefaultProjectRoleService.updateActorsToDefaultRole(DefaultProjectRoleService.java:854)
      7. com.atlassian.jira.bc.projectroles.DefaultProjectRoleService.removeDefaultActorsFromProjectRole(DefaultProjectRoleService.java:453)
      8. com.atlassian.jira.web.action.admin.roles.GroupRoleActorAction.doUpdate(GroupRoleActorAction.java:64)
      8 frames
    3. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame