Process Datamart does not execute after AssertionError (Doc ID 1388664.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version: 10.3.1 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms

In Process Datamart, following error is seen in dwupdater.log and it stops producing any process measurement data.


[<D>] filling processes
[<D>] Executing statement [
SELECT DISTINCT INST.PROCESSID AS PROCESSIN, INST.INSTID AS INSTANCEIN, INST.THREADID AS THREADIN, INST.RECEIVETIME AS ENDTIME, INST.CREATIONTIME AS BEGINTIME FROM PPROCINSTANCE INST WHERE INST.THREADID = 0 AND INST.RECEIVETIME > ? AND INST.RECEIVETIME <= ? AND INST.STATE IN (32,64,1056,1088,2080,2112)
]
[<S>] Process performance routine could not be finished. Transaction rolled back.
[<S>] java.lang.AssertionError
java.lang.AssertionError
at fuego.analyzer.ProcessPerformanceLoader.load(ProcessPerformanceLoader.java:61)
at fuego.analyzer.Updater.fillProcesses(Updater.java:890)
at fuego.analyzer.Updater.fillWarehouse(Updater.java:983)
at fuego.analyzer.Updater.update(Updater.java:352)
at fuego.analyzer.UpdaterRunner.runUpdaterForEngines(UpdaterRunner.java:551)
at fuego.analyzer.UpdaterRunner.run(UpdaterRunner.java:394)
at fuego.analyzer.UpdaterRunner.runUpdater(UpdaterRunner.java:253)
at fuego.analyzer.service.UpdaterRunnerService.run(UpdaterRunnerService.java:143)
at fuego.analyzer.service.WarehouseService$WarehouseServiceThread.runItem(WarehouseService.java:460)
at fuego.analyzer.service.WarehouseService$WarehouseServiceThread.run(WarehouseService.java:393)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms