Project

General

Profile

Actions
Copy link

Task #684

closed

Provisioning queue - sort by system entity identifier exception

Added by Jan Helbich over 7 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Radek Tomiška
Category:
Provisioning
Target version:
Diamond (7.4.0)
Start date:
08/31/2017
Due date:
% Done:

100%

Estimated time:
Owner:

Description

Click Identifier on System in the provisioning queue table raises:

Caused by: org.hibernate.QueryException: could not resolve property: systemEntityUid of: eu.bcvsolutions.idm.acc.entity.SysProvisioningOperation [select e from eu.bcvsolutions.idm.acc.entity.SysProvisioningOperation e where ( ?1 is null or e.systemEntity.system.id = ?1 ) 
 and  (?3 = 'null' or e.created >= ?4)  and  (?5 = 'null' or e.created <= ?6) and  (?7 is null or e.operationType = ?7) and  (?9 is null or e.systemEntity.entityType = ?9) and  (?11 is null or e.entityIdentifier = ?11) and  (?13 is null or e.systemEntity.uid = ?13) and  (
?15 is null or e.request.result.state = ?15) order by e.systemEntityUid asc]
        at org.hibernate.QueryException.generateQueryException(QueryException.java:137)
        at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:120)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:234)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
        at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
        at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
        at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
        at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
        at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
        at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:328)
        ... 191 common frames omitted
Caused by: org.hibernate.QueryException: could not resolve property: systemEntityUid of: eu.bcvsolutions.idm.acc.entity.SysProvisioningOperation

Versions: 7.3.x

Actions
Copy link
 #1

Updated by Jan Helbich over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by Radek Tomiška over 7 years ago

  • Assignee changed from Vít Švanda to Radek Tomiška
Actions
Copy link
 #3

Updated by Radek Tomiška over 7 years ago

  • Subject changed from Provisioning queue - sort by system identifier exception to Provisioning queue - sort by system entity identifier exception
  • Description updated (diff)
  • Status changed from New to Needs feedback
  • Assignee changed from Radek Tomiška to Jan Helbich
  • % Done changed from 0 to 90

Provisioning queue and archive entity has different structure (system entity can be deleted in archive) and the same FE component is used for both table. I added appropriate sort property name for provisioning queue.

Commit:
https://github.com/bcvsolutions/CzechIdMng/commit/25775efe2cd01b8ed3522f320612b33f1d76f0b2#diff-6ad164c5651c014037b996b144972716R215

Could you pls do a test and feedback?

Actions
Copy link
 #4

Updated by Jan Helbich over 7 years ago

  • Status changed from Needs feedback to Closed
  • Assignee changed from Jan Helbich to Radek Tomiška
  • % Done changed from 90 to 100

Works smoothly, thanks.

Actions
Copy link

Also available in: Atom PDF