syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marco Di Sabatino Di Diodoro (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SYNCOPE-712) Error while searching roles by parent
Date Mon, 19 Oct 2015 07:44:05 GMT
Marco Di Sabatino Di Diodoro created SYNCOPE-712:
----------------------------------------------------

             Summary: Error while searching roles by parent
                 Key: SYNCOPE-712
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-712
             Project: Syncope
          Issue Type: Bug
          Components: core
    Affects Versions: 1.2.5
            Reporter: Marco Di Sabatino Di Diodoro
            Assignee: Marco Di Sabatino Di Diodoro
             Fix For: 1.2.6, 2.0.0


Search roles by parent return an openjpa exception.

org.apache.openjpa.persistence.PersistenceException: Column "PARENT_ID_NAME" not found; SQL
statement:
CREATE FORCE VIEW PUBLIC._152 AS
SELECT DISTINCT
    SUBJECT_ID
FROM PUBLIC.ROLE_SEARCH
WHERE PARENT_ID_NAME = ?1 [42122-190] {SELECT u.subject_id FROM (SELECT DISTINCT subject_id
FROM role_search WHERE parent_id_name=?) u WHERE u.subject_id NOT IN (SELECT id AS subject_id
FROM SyncopeRole WHERE id <>1 AND id <>2 AND id <>3 AND id <>4 AND
id <>5 AND id <>6 AND id <>7 AND id <>8 AND id <>9 AND id <>10
AND id <>11 AND id <>12 AND id <>13 AND id <>14 AND id <>100
AND id <>101 AND id <>102 AND id <>104 AND id <>106 AND id <>108
AND id <>109 AND id <>110 AND id <>111 AND id <>112 AND id <>113
AND id <>114 AND id <>115 AND id <>116 AND id <>117 AND id <>118
AND id <>119 AND id <>122 AND id <>123 AND id <>124 AND id <>126)}
[code=42122, state=42S22]

        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291) ~[openjpa-persistence-2.3.0.jar:2.3.0]
        at org.apache.syncope.core.persistence.dao.impl.SubjectSearchDAOImpl.doSearch(SubjectSearchDAOImpl.java:364)
~[classes/:?]
        at org.apache.syncope.core.persistence.dao.impl.SubjectSearchDAOImpl.search(SubjectSearchDAOImpl.java:155)
~[classes/:?]
        at org.apache.syncope.core.rest.controller.RoleController.search(RoleController.java:216)
~[classes/:?]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message