ECRM 8.9 Email No Sent and JavaMail Error in Application Server Log File - Object Isn't Open On A Select - Java Exception - java.lang.NoSuchMethodError (Doc ID 647662.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 8.9 to 8.9 [Release 8.9]
PeopleSoft Enterprise CRM Order Capture - Version 8.9 to 8.9 [Release 8.9]
PeopleSoft Enterprise CRM Telemarketing - Version 8.9 to 8.9 [Release 8.9]
PeopleSoft Enterprise CRM Support - Version 8.9 to 8.9 [Release 8.9]
PeopleSoft Enterprise CRM Marketing - Version 8.9 to 8.9 [Release 8.9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201011375
***Checked for relevance on 01-Sep-2014***

Symptoms

After CRM 8.9 Bundle #14 or CRM 8.9 Bundle 14a/14b/14c is applied when Submitting an email correspondence request getting the error below:

SQL.Fetch: object isn't open on a select. (2,288) RBC_PROCESS.Email.OnExecute Name:ProcessCMWithNoTemplates PCPC:21195 Statement:323

Called from:RBC_PROCESS.Delivery.OnExecute Name:ProcessEmail Statement:228
Called from:RBC_PROCESS.Delivery.OnExecute Name:Main Statement:29
Called from:RBC_PROCESS.CMController.OnExecute Name:DoDeliver Statement:93
Called from:RBC_PROCESS.CMController.OnExecute Name:MergeAndDeliver Statement:108
Called from:RBC_PROCESS.CMController.OnExecute Name:ExtractAndMe
A fetch can only be done on an SQL object that is open on a select. Either the object is closed, or the statement is not a select.

Corresponding error in the AppServer Log file:

PSAPPSRV.2568 (218) [03/11/06 14:09:11 VP1@karanbir.oracle.com (IE 6.0; WINXP) ICPanel](0) (MCFSendMail): Creating SendMailException
PSAPPSRV.2568 (218) [03/11/06 14:09:11 VP1@karanbir.oracle.com (IE 6.0; WINXP) ICPanel](0) (MCFSendMail): SendMailException
PSAPPSRV.2568 (218) [03/11/06 14:09:11 VP1@karanbir.oracle.com (IE 6.0; WINXP) ICPanel](0) (MCFSendMail): SendMailException: Context: SetStringProp
PSAPPSRV.2568 (218) [03/11/06 14:09:11 VP1@karanbir.oracle.com (IE 6.0; WINXP) ICPanel](0) (MCFSendMail): SendMailException: Java Exception: java.lang.NoSuchMethodError
PSAPPSRV.2568 (218) [03/11/06 14:09:11 VP1@karanbir.oracle.com (IE 6.0; WINXP) ICPanel](0) (MCFSendMail): SendMailException: Detail Message:JavaMail Error: java.lang.NoSuchMethodError: com.sun.mail.smtp.SMTPMessage.setSender(Ljavax/mail/Address;)V.\nStack Trace:\njava.lang.NoSuchMethodError: com.sun.mail.smtp.SMTPMessage.setSender(Ljavax/mail/Address;)V
at com.peoplesoft.pt.mcf.mail.MCFOutboundEmail.setSender(MCFOutboundEmail.java:577)

Also, no error is presented however the email is not sent. The same is applicable when sending notification emails.

Another situation when sending the notification emails, they are not going to the users and the email goes in Undelivered Email and the error is "The Sender field is invalid".

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