java.sql.BatchUpdateException (ORA-12899) Reported when DB Adapter Reads a Row from a Table it is Polling for Added Rows (Doc ID 1113215.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Oracle SOA Platform - Version 11.1.1.1.0 to 11.1.1.6.0 [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 09-Mar-2012***


Symptoms

You have developed a composite application to be run on Oracle Fusion Middleware 11g that utilizes the DBAdapter to poll a database table for the arrival of new records.

At run time an error message similar to the following is encountered when a record  is added to the database table being polled:

JCA Listener of the JCA Binding Component was unsuccessful in delivering an inbound message.
Throws Internal Exception: java.sql.BatchUpdateException: ORA-12899: value too large for column
"AS11G_SOAINFRA"."COMPOSITE_INSTANCE"."CONVERSATION_ID" (actual: 178, maximum: 100)

JCA Listener Throws Internal Exception: java.sql.BatchUpdateException: ORA-12899

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