OSB 11g - How To Trim the Fault Message to Avoid ORA-12899 Exception When Using Report Action

(Doc ID 1391573.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.4.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 05-November-2013***

Goal

If we are using a Report action and the language environment of OSB is not English, we may get an exception " ORA-12899: value too large" when the fault message is too long. For example:

Solution

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