Atlassian Importer is not working correctly with Oracle 11g

XMLWordPrintable

    • Type: Bug
    • Resolution: Not a bug
    • Priority: High
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      Hello there,

      as described in CWD-1709 it is not correctly possible to import users and especially memberships from Jira, when Crowd and Jira is using an Oracle 11g-Database.

      Szenario:
      Create a new directory called: Jira-Atlassian-Test
      Now go to: Users --> Import Users --> Atlassian Product Importer

      Choose:
      Product: Jira
      Directory: Jira-Atlassian-Test
      Import Passwords: does not care
      DB-Connection: Jira's 11g-Database-Connection

      --> Continue

      Result:

      The import is now complete. If there were any users or groups that failed to import please consult the log files for more information.

      Users imported: 143

      Groups imported: 505

      Group Memberships imported: 181

      First: Only 181 Memberships with 505 Groups?
      Second: The connected Jira-System has: 857 total user(s), 505 Groups and much more memberships!

      Info: Both are connected to an LDAP-Server and it is irrelevant if i use the ldap-directory or an internal one.

      Here is the log - nothing interesting .

      2011-12-06 12:55:11,868 http-3389-1 INFO [crowd.importer.importers.BaseImporter] Importing 505 groups.
      2011-12-06 12:55:12,592 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 26 ] [ 03.8% ]
      2011-12-06 12:55:12,612 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 2 ] of [ 26 ] [ 07.7% ]
      2011-12-06 12:55:12,624 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 3 ] of [ 26 ] [ 11.5% ]
      2011-12-06 12:55:12,635 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 4 ] of [ 26 ] [ 15.4% ]
      2011-12-06 12:55:12,644 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 5 ] of [ 26 ] [ 19.2% ]
      2011-12-06 12:55:12,654 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 6 ] of [ 26 ] [ 23.1% ]
      2011-12-06 12:55:12,661 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 7 ] of [ 26 ] [ 26.9% ]
      2011-12-06 12:55:12,670 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 8 ] of [ 26 ] [ 30.8% ]
      2011-12-06 12:55:12,704 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 9 ] of [ 26 ] [ 34.6% ]
      2011-12-06 12:55:12,712 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 10 ] of [ 26 ] [ 38.5% ]
      2011-12-06 12:55:12,722 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 11 ] of [ 26 ] [ 42.3% ]
      2011-12-06 12:55:12,730 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 12 ] of [ 26 ] [ 46.2% ]
      2011-12-06 12:55:12,753 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 13 ] of [ 26 ] [ 50.0% ]
      2011-12-06 12:55:12,762 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 14 ] of [ 26 ] [ 53.8% ]
      2011-12-06 12:55:12,770 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 15 ] of [ 26 ] [ 57.7% ]
      2011-12-06 12:55:12,777 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 16 ] of [ 26 ] [ 61.5% ]
      2011-12-06 12:55:12,786 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 17 ] of [ 26 ] [ 65.4% ]
      2011-12-06 12:55:12,807 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 18 ] of [ 26 ] [ 69.2% ]
      2011-12-06 12:55:12,815 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 19 ] of [ 26 ] [ 73.1% ]
      2011-12-06 12:55:12,823 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 20 ] of [ 26 ] [ 76.9% ]
      2011-12-06 12:55:12,832 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 21 ] of [ 26 ] [ 80.8% ]
      2011-12-06 12:55:12,840 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 22 ] of [ 26 ] [ 84.6% ]
      2011-12-06 12:55:12,849 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 23 ] of [ 26 ] [ 88.5% ]
      2011-12-06 12:55:12,857 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 24 ] of [ 26 ] [ 92.3% ]
      2011-12-06 12:55:12,867 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 25 ] of [ 26 ] [ 96.2% ]
      2011-12-06 12:55:12,871 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 26 ] of [ 26 ] [ 100.0 % ]
      2011-12-06 12:55:12,906 http-3389-1 INFO [crowd.importer.importers.BaseImporter] Importing 143 users.
      2011-12-06 12:55:13,317 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 8 ] [ 12.5% ]
      2011-12-06 12:55:13,385 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 2 ] of [ 8 ] [ 25.0% ]
      2011-12-06 12:55:13,459 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 3 ] of [ 8 ] [ 37.5% ]
      2011-12-06 12:55:13,530 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 4 ] of [ 8 ] [ 50.0% ]
      2011-12-06 12:55:13,594 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 5 ] of [ 8 ] [ 62.5% ]
      2011-12-06 12:55:13,663 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 6 ] of [ 8 ] [ 75.0% ]
      2011-12-06 12:55:13,730 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 7 ] of [ 8 ] [ 87.5% ]
      2011-12-06 12:55:13,743 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 8 ] of [ 8 ] [ 100.0 % ]
      2011-12-06 12:55:13,770 http-3389-1 INFO [crowd.importer.importers.BaseImporter] Importing user-to-group memberships.
      2011-12-06 12:55:13,841 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,867 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,875 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,896 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,910 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,927 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,933 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,941 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,947 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,960 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,967 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:13,975 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,030 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 4 ] [ 25.0% ]
      2011-12-06 12:55:14,067 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 2 ] of [ 4 ] [ 50.0% ]
      2011-12-06 12:55:14,099 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 3 ] of [ 4 ] [ 75.0% ]
      2011-12-06 12:55:14,107 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 4 ] of [ 4 ] [ 100.0 % ]
      2011-12-06 12:55:14,116 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,124 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,133 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,141 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,149 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,156 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,164 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,171 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,179 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,187 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,194 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,225 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,236 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,244 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,251 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,261 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,267 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,275 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,282 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,289 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,297 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,303 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,316 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,324 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,331 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,339 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,394 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,405 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,413 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,420 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,428 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,435 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,443 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,451 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,459 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,478 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,487 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,494 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,504 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,511 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,517 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,524 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,530 http-3389-1 INFO [persistence.hibernate.batch.AbstractBatchProcessor] processed batch [ 1 ] of [ 1 ] [ 100.0 % ]
      2011-12-06 12:55:14,531 http-3389-1 INFO [crowd.importer.importers.BaseImporter] Completed importing 181 user-to-group memberships.

            Assignee:
            Unassigned
            Reporter:
            Thomas Soring
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: