wi_fault Table Does Not Exist (Doc ID 1310582.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.3.3.1 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms

This error message is being observed:

ORABPEL-04144

Cannot update work item fault.
The process domain was unable to update the fault entry for the activity "33560013-BpInv10-BpSeq11.5-2" from the datastore. The exception reported is: ORA-00942: table or view does not exist

Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid.
sql statement: SELECT COUNT(*) FROM wi_fault WHERE cikey = ? AND node_id = ? AND scope_id = ? AND count_id = ?

at com.collaxa.cube.engine.adaptors.common.BaseWorkItemFaultPersistenceAdaptor.storeFault(BaseWorkItemFaultPersistenceAdaptor.java:172)
at com.collaxa.cube.engine.data.WorkItemFaultMgr.storeFault(WorkItemFaultMgr.java:33)
at com.collaxa.cube.engine.ext.wmp.faultpolicy.RecoveryActionHuman.execute(RecoveryActionHuman.java:43)
at com.collaxa.cube.engine.ext.wmp.faultpolicy.RecoverFault.recoverAndChain(RecoverFault.java:198)
at com.collaxa.cube.engine.ext.wmp.faultpolicy.RecoverFault.resolveAndRecover(RecoverFault.java:354)
at com.collaxa.cube.engine.ext.wmp.BPELInvokeWMP.__handleException(BPELInvokeWMP.java:542)



Changes

The problem occurs after BPEL upgrade from SOA10.1.3.1.0 to SOA 10.1.3.3.0 

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