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 | 10 years ago
  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 | 10 years 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 | 10 years 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'. )
  3. 0

    Users who integrate JIRA with a MS SQL database with the case sensitive collation won't be able to perform upgrade of the application. There are a few upgrades task that are failing due to the case sensitive collation. {noformat} 2010-06-07 12:54:50,487 http-8081-1 ERROR anonymous 774x61x1 9l6cw1 127.0.1.1 /secure/SetupImport.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:565) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.calculateResolutionDateForAllIssues(UpgradeTask_Build401.java:214) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.doUpgrade(UpgradeTask_Build401.java:116) {noformat} or {noformat} Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:552) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build437.doUpgrade(UpgradeTask_Build437.java:63) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:508) {noformat} Users experiencing similar problems are recommended to create a new database with a case insensitive collation such as _SQL_Latin1_General_CP437_CI_AI_

    Atlassian JIRA | 7 years ago | Bogdan Dziedzic [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Users who integrate JIRA with a MS SQL database with the case sensitive collation won't be able to perform upgrade of the application. There are a few upgrades task that are failing due to the case sensitive collation. {noformat} 2010-06-07 12:54:50,487 http-8081-1 ERROR anonymous 774x61x1 9l6cw1 127.0.1.1 /secure/SetupImport.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:565) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.calculateResolutionDateForAllIssues(UpgradeTask_Build401.java:214) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.doUpgrade(UpgradeTask_Build401.java:116) {noformat} or {noformat} Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:552) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build437.doUpgrade(UpgradeTask_Build437.java:63) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:508) {noformat} Users experiencing similar problems are recommended to create a new database with a case insensitive collation such as _SQL_Latin1_General_CP437_CI_AI_

    Atlassian JIRA | 7 years ago | Bogdan Dziedzic [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.)
  6. 0

    Users who integrate JIRA with a MS SQL database with the case sensitive collation won't be able to perform upgrade of the application. There are a few upgrades task that are failing due to the case sensitive collation. {noformat} 2010-06-07 12:54:50,487 http-8081-1 ERROR anonymous 774x61x1 9l6cw1 127.0.1.1 /secure/SetupImport.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:565) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.calculateResolutionDateForAllIssues(UpgradeTask_Build401.java:214) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.doUpgrade(UpgradeTask_Build401.java:116) {noformat} or {noformat} Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:552) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build437.doUpgrade(UpgradeTask_Build437.java:63) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:508) {noformat} Users experiencing similar problems are recommended to create a new database with a case insensitive collation such as _SQL_Latin1_General_CP437_CI_AI_

    Atlassian JIRA | 7 years ago | Bogdan Dziedzic [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE jiraschema.jiraissue SET RESOLUTIONDATE = ? WHERE id = ? (Invalid column name 'id'.)

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