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
C_SetCertBER returns error E_UNKNOWN_CRITICAL_EXTENSION 14Number of Views Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle 185Number of Views 'Critical Error' with software Token for Windows 19Number of Views What is the difference between a critical and non-critical extension? 10Number of Views 1 Virtual Disk(s) Degraded error or 1 Virtual Disk(s) is in Critical State error displays when RSA SecurID A250 Hardware A… 37Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?