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 What is the meaning of yellow flags in Microsoft Internet Explorer's icons for critical extensions? 10Number of Views
Trending Articles
This certificate or its signing CA is not valid error when importing a certificate chain in RSA Authentication Manager 8.x… RSA Authentication Manager Upgrade Process Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU How to create and configure certificates for HTTPS access when using intermediate CA certs in RSA Identity Governance & Li… RSA Authentication Manager Patch Updates
Don't see what you're looking for?