Email Notification Issue - If CC/TO Or BCC has more than 2000 Characters

(Doc ID 2324279.1)

Last updated on NOVEMBER 03, 2017

Applies to:

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

Symptoms

When there is more than 2000 characters in To/CC/BCC fields we are seeing the below error message.
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}.
exception.fix: Check Application server data source properties for
BPEL-Workflow connections. Check schema and verify database connections.
..
..
..
Caused By: java.sql.SQLException: ORA-01460: unimplemented or unreasonable
conversion requested

Cause

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