How to Work Around "ORA-12899: value too large for column" when Polling a Database where the Primary Key Exceeds 100 Bytes (Doc ID 1454595.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

The following error occurs when polling a database where the primary key exceeds 100 bytes:



According to <note 1113215.1>, the solution is:

 

  1. Delete the database adapter and recreate it selecting fewer columns when presented with the Attribute Filtering, or
  2. Manually edit or-mappings.xml and remove from the the elements corresponding to columns that are not necessary to ensure uniqueness.


This note provides an alternative workaround to the above solution.

Solution

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