Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-712

Error while searching roles by parent

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.5
    • Fix Version/s: 1.2.6
    • Component/s: core
    • Labels:
      None

      Description

      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/:?]

        Attachments

          Activity

            People

            • Assignee:
              mdisabatino Marco Di Sabatino Di Diodoro
              Reporter:
              mdisabatino Marco Di Sabatino Di Diodoro
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: