My Oracle Support Banner

Email Notification Issue when TO, CC, or BCC are more than 2000 characters long combined (Doc ID 2324279.1)

Last updated on OCTOBER 13, 2018

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 the following error message will the printed in logs:

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.

at oracle.bpel.services.notification.repos.driver.NotificationReposService.getBadAddresses(NotificationReposService.java:942)
at oracle.bpel.services.notification.NotificationUtil.isBadAddress(NotificationUtil.java:1226)
at oracle.bpel.services.notification.NotificationUtil.isBadAddress(NotificationUtil.java:1210)
at oracle.bpel.services.notification.queue.sender.Publisher.persistentSend(Publisher.java:449)
... 123 more
Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested...

  
 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.