Database Adapter with Distributed Polling Does Not Work (Doc ID 1334167.1)

Last updated on JULY 11, 2017

Applies to:

Oracle(R) BPEL Process Manager - Version 10.1.3.4 to 10.1.3.5.0
Information in this document applies to any platform.
***Checked for relevance on 10-Apr-2013***

Symptoms

You are using a Database Adapter with Delete strategy and Distributed Polling, and you've set the property MaxTransactionSize. The adapter throws the following error.

<2011-05-12 17:12:47,255> <WARN> <domain.collaxa.cube.activation>[JCA-work-instance:Database Adapter-1] <Database Adapter::Inbound>ORABPEL-11624DBActivationSpec Polling Exception.Query name: [DBDeleteRead], Descriptor name: [DBDeleteRead.TempMessage]. Polling the database for events failed on this iteration.
If the cause is something like a database being down successful polling will resume once conditions change. Caused by java.sql.SQLException: Missing IN or OUT parameter at index:: 1.

 


JCA-11624
DBActivationSpec Polling Exception.
Query name: [DBDeleteRead], Descriptor name:
[DBDeleteRead.TempMessage]. Polling the database for events failed on this iteration.
If the cause is something like a database being down successful polling will
resume once conditions change. Caused by java.sql.SQLException: Missing IN or OUT parameter at index:: 1.

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