JIRA importer Queries are broken when importing from Oracle

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 2.2.7
    • Affects Version/s: 2.2.2
    • Component/s: Import & Export
    • None
    • Environment:

      Oracle 11g

      Running in Crowd or directly in the Oracle command line, an error is reported:

      SELECT 
      usr.user_name AS user_name, 
      grp.group_name as group_name 
      FROM 
      cwd_membership AS mem INNER JOIN cwd_group AS grp ON  mem.parent_id = grp.id INNER JOIN cwd_user as usr ON mem.child_id = usr.ID 
      WHERE 
      mem.membership_type = 'GROUP_USER'  AND mem.directory_id = 32770
      
      [SELECT - 0 row(s), 0.000 secs]  [Error Code: 933, SQL State: 42000]  ORA-00933: SQL-command not properly ended
      

              Assignee:
              joe
              Reporter:
              Renan Battaglin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 7m
                  7m