Resolving Oracle BPEL error “javax.servlet.ServletException: Cannot find work items”
Here is the error message:
Getting Console Activity Tab Throws javax.servlet.ServletException: Cannot find work items.
Exception Message:
[javax.servlet.ServletException]
Cannot find work items.
An attempt to fetch the work items using the where condition "" from the datastore has failed.
The exception reported is: Invalid column name
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 * FROM admin_list_wi WHERE ci_domain_ref = 0 ORDER BY wi_modify_date desc

smallwei 9:56 pm on December 15, 2009
This issue is caused by not upgrading the orabpel schema when upgrading the runtime server to version 10.1.3.3.
Run
$ORACLE_HOME/bpel/system/database/scripts/upgrade_10131_10133_oracle.sqlto upgrade the schema