Hibernate WARN messages flooding logs in RSA Identity Governance & Lifecycle
Originally Published: 2020-09-16
Article Number
Applies To
RSA Version/Condition: 7.1.1, 7.2.0
Issue
08/18/2020 16:57:07.230 WARN (Worker_actionq#Normal#jdbc/avdb_258) [org.hibernate.hql.internal.ast.HqlSqlWalker] [DEPRECATION] Encountered positional parameter near line 1, column 343
in HQL: [select count(cri.id) from com.aveksa.server.core.cr.ChangeRequestItem cri, com.aveksa.server.core.Application app where ((cri.operandAppId=app.id and cri.operandTypeStr not in ('US')) or cri.valueAppId=app.id) and (app.name = 'UID' OR app.name = 'Office 365 MFA program' OR app.name = 'MYAPP' OR app.name = 'MYAPP-ITG') and (cri.itemID IN (?,?))].
Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.
08/18/2020 16:57:09.551 WARN (Worker_jobq#Normal#jdbc/avdb_24) [org.hibernate.hql.internal.ast.HqlSqlWalker] [DEPRECATION] Encountered positional parameter near line 1, column 250
in HQL: [select count(cri.id) from com.aveksa.server.core.cr.ChangeRequestItem cri, com.aveksa.server.core.Application app where ((cri.operandAppId=app.id and cri.operandTypeStr not in ('US')) or cri.valueAppId=app.id) and (app.cai1 = 1) and (cri.itemID IN (?,?))].
Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.Cause
Resolution
This is resolved in the following versions where these WARN level messages are suppressed.
- RSA Identity Governance & Lifecycle 7.1.1 P08
- RSA Identity Governance & Lifecycle 7.2.0 P02
- RSA Identity Governance & Lifecycle 7.2.1
Workaround
Related Articles
Cloud Administration Anomalous Users API 18Number of Views RSA Identity Governance and Lifecycle SQL SELECT or SQL EXECUTE nodes with syntax errors 452Number of Views Accounts created from an RSA Via Lifecycle and Governance account template are not removed from UI when request item is re… 242Number of Views Immediate Next Token Code (NTC) error received for some user logins in RSA Authentication Manager 8.x 530Number of Views
Don't see what you're looking for?