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

Last updated on MARCH 27, 2020

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 "<SCHEMA>_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/",
subscriber "bpel://localhost/default/GetAccountServiceDetailBPEL~" in the data store.
The exception reported is: ORA-12899: value too large for column "<SCHEMA>_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 "<SCHEMA>_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",
subscriber "bpel://localhost/default/GetAccountServiceDetailBPEL"
in the data store.
The exception reported is: ORA-12899: value too large for column "<SCHEMA>_BPEL"."DLV_SUBSCRIPTION"."PROPERTIES"
(actual: 3788, maximum: 2000)

Changes

Cause

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