Unification failing with ORA-00904: "B"."AVAILABILITY_STATUS": invalid identifier in RSA Identity Governance & Lifecycle

[#1]

Article Number

000036677

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
 

Issue

Unification starts to fail with an Invalid Identifier error:

Image description

Image description

The following error is seen in aveksaServer.log:
 

ERROR (Exec Task Consumer#8) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-00904: "B"."AVAILABILITY_STATUS": invalid identifier
ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 47
ORA-06512: at line 1

06/28/2018 12:03:53.413 INFO  (Exec Task Consumer#8) [com.aveksa.server.xfw.UnificationExecutor] Failed method=Process subTask=CompleteMergeTasks Default User Population, 22109
com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00904: "B"."AVAILABILITY_STATUS": invalid identifier
ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 47
ORA-06512: at line 1

        at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1534)
        at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1469)
        at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:269)
        at com.aveksa.server.xfw.UnificationExecutor.executeTask(UnificationExecutor.java:122)
        at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
        at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "B"."AVAILABILITY_STATUS": invalid identifier
ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 47
ORA-06512: at line 1

Cause

AVAILABILITY_STATUS is an internal attribute.  Unification fails on a statement that is dynamic and built on a collector configuration. The column might be in a configuration for some collector where we weren't expecting it.

Resolution

Check all the collectors (IDC/ADC/MAADC/EDC/MAEDC/RDC) and see if this attribute is used in any of its resolution rules and remove the mapping to this attribute to fix the issue.