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:
Oracle(R) BPEL Process Manager 10g - Version 10.1.3.3 and laterInformation 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 "<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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |