Issue | Unification starts to fail with an Invalid Identifier error:


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
|