Unification is failing at step 8 on "AVUSER.ROLE_MANAGEMENT_PKG", line 2469 in RSA Governance & Lifecycle
Last Modified: 2023-10-06
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/11: Post-Processing: Populate Role Metrics"

image005.png
image007.png
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. 
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).

    Related Articles

    Trending Articles

    Don't see what you're looking for?