My Oracle Support Banner

E-CRM: Unable to send notifications from Case Component if the Note has Multiple Attachments and Total Length of the File Names Exceeding 254 characters, error message 'SQL.Fetch: object isn't open on a select. (2,288) RBC_PROCESS.Email.OnExecute' (Doc ID 3045849.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When trying to send outbound notification from Case, end-user gets error:

SQL.Fetch: object isn't open on a select. (2,288) RBC_PROCESS.Email.OnExecute
Name:ProcessCMWithTemplates PCPC:2851 Statement:53
Called from:ERMS.OutboundNotification.NotificationToolbar.OnExecute Name

If they remove the attachment, they can send the notification

The issue can be reproduced at will with the following step:

  1. Navigate to Help Desk > Search Cases
  2. Open an existing Case, click Notification
  3. Send a notification with multiple attachments

 

Changes

 

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
Changes
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.