Unification is failing at step 8 on "AVUSER.ROLE_MANAGEMENT_PKG", line 2469 in RSA Governance & Lifecycle

[#1]

Article Number

000068114

Applies To

RSA Product Set: RSA Governance & Lifecycle
RSA Version/Condition: 

• RSA Governance & Lifecycle 7.5.x

Issue

Unification is failing at step 8, post-processing: populate role metrics

Image description
Image description
With the following error shown in the DB summary log

"ORA-06512: at ""AVUSER.ROLE_MANAGEMENT_PKG"", line 2469
ORA-06512: at ""AVUSER.ROLE_MANAGEMENT_PKG"", line 2469
ORA-06512: at ""AVUSER.ROLE_MANAGEMENT_PKG"", line 9593
ORA-06512: at ""AVUSER.UNFC_PROCESSOR"", line 260
ORA-06512: at ""AVUSER.UNFC_PROCESSOR"", line 41"

And the following error is shown in AveksaServer.log

02/13/2023 18:13:17.511 ERROR (Exec Task Consumer#0 - Sequence) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=750216 RunID=345561 Source=521 Type=EntitlementExplosionProcessing Status=InProgress] 
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
ORA-06512: at "AVUSER.ROLE_MANAGEMENT_PKG", line 2469
ORA-06512: at "AVUSER.ROLE_MANAGEMENT_PKG", line 2469
ORA-06512: at "AVUSER.ROLE_MANAGEMENT_PKG", line 3833
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 181
ORA-06512: at line 1

 

Cause

This issue occurs if a Role Membership Rule is not configured correctly or has an invalid filter.

Resolution

Contact RSA Customer Support for information on how to remediate this issue.