My Oracle Support Banner

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

Last updated on OCTOBER 30, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.