Integration

Hello,

I was getting the following annoying error trying to send an email from a BPEL Process:

====================================================

<Sep 29, 2011 6:49:09 AM BRT> <Error> <oracle.soa.bpel.engine> <BEA-000000> <This exception occurred because the fault thrown in the BPEL flow was not handled by any fault handlers and reached the top-level scope. Root cause :
com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault}
messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}
parts: {{
summary=<summary>oracle.fabric.common.FabricException: Cannot get Object part 'Responses'. No parts are set on the message</summary>
,detail=<detail>Cannot get Object part 'Responses'. No parts are set on the message</detail>}

<Sep 29, 2011 6:49:09 AM BRT> <Error> <oracle.soa.services.notification> <BEA-000000> <<.> Error while querying notification from repository for ID {0}.
Error while querying notification from repository for ID {0}.
Check Application server data source properties for BPEL-Workflow connections. Check schema and verify database connections.

ORABPEL-31004

Error while querying notification from repository for ID {0}.
Error while querying notification from repository for ID {0}.
Check Application server data source properties for BPEL-Workflow connections. Check schema and verify database connections.

<Sep 29, 2011 6:49:09 AM BRT> <Error> <oracle.soa.services.notification> <BEA-000000> <<.> Error while publishing message to notification queue.
Error while publishing message to notification queue.
Check Application server data source properties for BPEL-Workflow connections. Check schema and verify database connections.

ORABPEL-31002

Error while publishing message to notification queue.
Error while publishing message to notification queue.


Check Application server data source properties for BPEL-Workflow connections. Check schema and verify database connections.

Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

<Sep 29, 2011 6:49:09 AM BRT> <Error> <oracle.soa.services.notification> <BEA-000000> <<.> Error while sending notification.
Error while sending notification to email.
Check the underlying exception and fix it.

ORABPEL-31015

Error while sending notification.
Error while sending notification to email.
Check the underlying exception and fix it.

====================================================

We´ve figured out there were 2 missing tables on our SOA RCU Metadata repository:

BPELNOTIFICATION_FILTERMSGS
BPELNOTIFICATION_INVALADDRS

After creating those tables from the WFSchema_oracle.sql script, the error was resolved.

Best rgds,
Luiz Malere.