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

'Lower Case Output' option can cause mismatch in database with applications

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 2.3.2
    • None
    • None

      Situation

      • Crowd and an integrated application are both using a case insensitive databases
      • Data with capital letters has been added to Crowd and the application (users, groups, etc)
      • Lower Case Output is turned on
      • Changes are made to the users and groups
      • There is now inconsistent data between Crowd and the other application

      Exmaple (pictures below):

      • JIRA and Crowd integrated, screenshots show 2 users and 2 groups with upper case and lower case.
      • Turn on Lower Case Output
      • Remove the UPPERCASEGROUP
      • Sync JIRA and notice that there is no change to users/groups
      • Add UPPERCASEGROUP back
      • Sync JIRA, notice the screenshot where it now shows 1 user per group instead of 2.
        • Logs show a duplicate entry error

        1. ci db - lowercase output 1.jpg
          197 kB
          David Chan
        2. ci db - lowercase output 2.jpg
          171 kB
          David Chan
        3. ci db - lowercase output 3.jpg
          164 kB
          David Chan
        4. ci db - lowercase output 4.jpg
          166 kB
          David Chan
        5. ci db - lowercase output 5.jpg
          212 kB
          David Chan

            [CWD-2421] 'Lower Case Output' option can cause mismatch in database with applications

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 1509847 ] New: JAC Bug Workflow v3 [ 3364795 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1392304 ] New: Simplified Crowd Development Workflow v2 - restricted [ 1509847 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 289939 ] New: Simplified Crowd Development Workflow v2 [ 1392304 ]
            Paul Greig made changes -
            Remote Link Original: This issue links to "Page (Extranet)" [ 20163 ] New: This issue links to "Page (Extranet)" [ 20163 ]
            Paul Greig made changes -
            Remote Link Original: This issue links to "Wiki Page (Extranet)" [ 20163 ] New: This issue links to "Page (Extranet)" [ 20163 ]
            Renan Battaglin made changes -
            Remote Link New: This issue links to "Wiki Page (Extranet)" [ 35844 ]
            Adrian Hempel [Atlassian] made changes -
            Fix Version/s New: 2.3.2 [ 19199 ]
            Resolution New: Fixed [ 1 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]
            Adrian Hempel [Atlassian] made changes -
            Link New: This issue is incorporated by CWD-2148 [ CWD-2148 ]

            It appears that this was fixed by CWD-2148.

            Adrian Hempel [Atlassian] added a comment - It appears that this was fixed by CWD-2148 .
            Adrian Hempel [Atlassian] made changes -
            Resolution Original: Cannot Reproduce [ 5 ]
            Status Original: Resolved [ 5 ] New: Open [ 1 ]

              ahempel Adrian Hempel [Atlassian]
              dchan David Chan
              Affected customers:
              2 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: