Email Notification Task Issue If CC/TO Or BCC Is More Then 2000 Characters. (Doc ID 2303656.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Business Process Management Suite - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Goal

 In a Email Notification task (in a BPM Composite) if there is more than 2000 characters in CC/BCC fields we are seeing the below error message.

 

Aug 15, 2017, 4:52:27,7 PM BST> <Error> <oracle.soa.services.notification>
<BEA-000000> <<.> exception.code:31004
exception.type: ERROR
exception.severity: 2
exception.name: Error while querying notification from repository for ID {0}.
exception.description: Error while querying notification from repository for
ID {0}.
exception.fix: Check Application server data source properties for
BPEL-Workflow connections. Check schema and verify database connections.

ORABPEL-31004

exception.code:31004
exception.type: ERROR
exception.severity: 2
exception.name: Error while querying notification from repository for ID {0}.
exception.description: Error while querying notification from repository for
ID {0}.

 

Caused By: java.sql.SQLException: ORA-01460: unimplemented or unreasonable
conversion requested

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