Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-11890

Deleting user or group from Role breaks on Sybase (and other column-case-sensitive databases)

    XMLWordPrintable

Details

    Description

      Deleting a group or role breaks with the following exception in Sybase:

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

      Attachments

        1. jra11890fix.jar
          7 kB
        2. jra11890fix.diff
          1 kB

        Activity

          People

            7ee5c68a815f Jeff Turner
            7ee5c68a815f Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: