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

JIRA importer Queries are broken when importing from Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 2.2.7
    • 2.2.2
    • Import & Export
    • None
    • Oracle 11g

    Description

      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
      

      Attachments

        Issue Links

          Activity

            People

              jwalton joe
              rbattaglin Renan Battaglin
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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