Sunday, November 17, 2013

Large Event Payload Causes: ORA-19011: Character string buffer too small ORA-06512: at "SYS.XMLTYPE"

I am using oracle EDN in SOA 11.1.1.6, while testing the process i am getting the large event payload error:

faultName: {{http://schemas.oracle.com/bpel/extension}runtimeFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ summary=<summary>Error enqueing event:  ORA-06512: at "SYS.XMLTYPE", line 169 ORA-06512: at "DEV_SOAINFRA.EDN_ENQUEUE_
BUSINESS_EVENT", line 13 ORA-06512: at "DEV_SOAINFRA.EDN_INTERNAL_PUBLISH_EVENT", line 4 </summary> ,detail=<detail>oracle.fabric.common.FabricException: Error enqueing event: ORA-19011: Character string buffer too small ORA-06512: at "SYS.XMLTYPE", line 169 ORA-06512: at "DEV_SOAINFRA.EDN_ENQUEUE_BUSINESS_EVENT", line 13 ORA-06512: at "DEV_SOAINFRA.EDN_INTERNAL_PUBLISH_EVENT",
Well according to the oracle support when you publish an event to EDN with a large payload in a BPEL process, this error occurs and  it is reported as a unpublished bug 13801175.
To resolve this issue you need to install the patch 13801175 (you can get it from metalink).
Note: This issue has been fixed in SOA 11.1.1.7.0.
 

No comments:

Post a Comment