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.

            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.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: