[
https://issues.apache.org/jira/browse/SYNCOPE-712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marco Di Sabatino Di Diodoro updated SYNCOPE-712:
-------------------------------------------------
Fix Version/s: (was: 2.0.0)
> 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
>
>
> 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)
