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

Unable to search for a Principal by email address.

XMLWordPrintable

      The following error is thrown when trying to execute this sql:

      select distinct p."DIRECTORYID" as DIRECTOR1_17_0_, p."NAME" as NAME2_17_0_, p."ACTIVE" as ACTIVE3_17_0_, p."CONCEPTION" as CONCEPTION4_17_0_, p."LASTMODIFIED" as LASTMODI5_17_0_ from "REMOTEPRINCIPAL" p ,"ATTRIBUTES" pa, "ATTRIBUTES" a, "ATTRIBUTEVALUES" av where p."DIRECTORYID" = ? and p.`DIRECTORYID` = pa.`REMOTEPRINCIPALDIRECTORYID`and p.`name` = pa.`REMOTEPRINCIPALNAME` and pa.`ID` = av.`ATTRIBUTEVALUEID` and pa.`ATTRIBUTE` = 'mail' and av.`VALUE` like ? order by p."NAME" asc, p."ACTIVE" asc

      could not execute query

            [CWD-71] Unable to search for a Principal by email address.

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 1509597 ] New: JAC Bug Workflow v3 [ 3364653 ]
            Owen made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1391733 ] New: Simplified Crowd Development Workflow v2 - restricted [ 1509597 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 272197 ] New: Simplified Crowd Development Workflow v2 [ 1391733 ]
            jawong.adm made changes -
            Workflow Original: JIRA Bug Workflow v2 [ 173480 ] New: Crowd Development Workflow v2 [ 272197 ]
            Justin Koke made changes -
            Workflow Original: jira [ 64614 ] New: JIRA Bug Workflow v2 [ 173480 ]
            Justen Stepka [Atlassian] made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]

            Justen Stepka [Atlassian] added a comment -

            Fixed by updating the hibernate mappings file and principal DAO.

            To fix the local envrionment:

            • Upgrade to the latest source (version 0.4).
            • Rename the ATTRIBUTEVALUES table column attributevalueid to ATTRIBUTEVALUEID

            This affects Postgres only

            Justen Stepka [Atlassian] added a comment - Fixed by updating the hibernate mappings file and principal DAO. To fix the local envrionment: Upgrade to the latest source (version 0.4). Rename the ATTRIBUTEVALUES table column attributevalueid to ATTRIBUTEVALUEID This affects Postgres only
            Justen Stepka [Atlassian] made changes -
            Environment New: Postgres only,
            Justen Stepka [Atlassian] made changes -
            Status Original: Open [ 1 ] New: In Progress [ 3 ]
            Justin Koke made changes -
            Priority Original: Major [ 3 ] New: Critical [ 2 ]

              justen.stepka@atlassian.com Justen Stepka [Atlassian]
              justin@atlassian.com Justin Koke
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: