Getting Error " ORA-12899: value too large for column "BCPBD_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES"

Last updated on JUNE 18, 2018

Applies to:

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