Getting Error " ORA-12899: value too large for column "BCPBD_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES" (Doc ID 726725.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.3.3
Information in this document applies to any platform.
***Checked for relevance on 12-Feb-2010***

Symptoms

The column 'properties' of the table dlv_subscription of the bpel dehydration
store schema is too small when BPEL uses OSR as the UDDI provider. At
run time the following error is raised when a process is invoked which looks
up another service via an UDDI repository (OSR).

 <ERROR>  <BaseDeliveryPersistenceAdaptor::subscribe>
java.sql.SQLException: ORA-12899: value too large for column "BCPBD_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES" (actual: 3788, maximum: 2000) 


Error while invoking bean "cube engine":
[com.collaxa.cube.engine.data.DataSourceException: Cannot insert delivery subscription.
The process domain was unable to insert the delivery data for conversation
"bpel://localhost/default/GetAccountServiceDetailBPEL~20.0/961814-BpInv0-BpSeq3.3-3",
subscriber "bpel://localhost/default/GetAccountServiceDetailBPEL~20.0/961814-BpRcv1-BpSeq3.3-4" in the data store.
The exception reported is: ORA-12899: value too large for column "BCPBD_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES"
(actual: 3788, maximum: 2000)

Please check that the machine hosting the data source is physically connected to the network.
Otherwise, check that the data source connection parameters (user/password) is currently valid.
sql statement: INSERT INTO dlv_subscription ( conv_id, conv_type, cikey, domain_ref, process_id, revision_tag, process_guid, operation_name, subscriber_id, service_name, subscription_date, properties ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
] -> [java.sql.SQLException: ORA-12899: value too large for column "BCPBD_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES" (actual: 3788, maximum: 2000)
]
ORABPEL-04048

Cannot insert delivery subscription.
The process domain was unable to insert the delivery data for conversation
"bpel://localhost/default/GetAccountServiceDetailBPEL~20.0/961814-BpInv0-BpSeq3.3-3",
subscriber "bpel://localhost/default/GetAccountServiceDetailBPEL~20.0/961814-BpRcv1-BpSeq3.3-4"
in the data store.
The exception reported is: ORA-12899: value too large for column "BCPBD_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES"
(actual: 3788, maximum: 2000)

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