Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-1735

Oracle does not remove memberships when the Users are deleted

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Low
    • None
    • 2.0, 2.0.1, 2.0.2
    • Database

    Description

      Oracle does not remove memberships when the Users are deleted.

      The membership is kept in the CWD_MEMBERSHIP table and the records child_id fields are updated to null.

      Sometimes the User and the Membership are still in the DB, however, the child_id field is also updated to null.

      The problem is being detected when the Admins try to create an XML Backup. The following stack-trace is displayed:

      java.lang.NullPointerException
      	at com.atlassian.crowd.migration.MembershipMapper.addMembershipToXml(MembershipMapper.java:58)
      	at com.atlassian.crowd.migration.MembershipMapper.exportXml(MembershipMapper.java:44)
      	at com.atlassian.crowd.migration.XmlMigrator.exportXml(XmlMigrator.java:30)
      	at com.atlassian.crowd.migration.XmlMigrationManagerImpl.exportXml(XmlMigrationManagerImpl.java:96)
      	at com.atlassian.crowd.console.action.admin.Backup.doExport(Backup.java:71)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
      	at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
      

      Workaround:

      Delete from table CWD_MEMBERSHIP the problematic entries:

      delete from CWD_MEMBERSHIP where child_id = null
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rbattaglin Renan Battaglin
              Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: