Emailing Multiple Attachment Issue

[Ramprakash]

Hi List,

EnterpriseOne: 9.1
Tools: 9.1.0.3
Server: Windows 2003
Database: Oracle 10g

We have done a custom business function to send e-mail of file media attachments of specific work order to the user. It works fine in local. However report using the bsfn is ended up in error and we are getting following error in server.

JDE.log:

3036/3168 WRK:Starting jdeCallObject Wed Jun 18 10:09:26.357001 GetHost.c491
gethostbyname failed in jdeGetHostByName_r

3036/3168 WRK:Starting jdeCallObject Wed Jun 18 10:09:26.357003 jdesmtp.c1638
connectToSMTPserver : gethostbyname failed,
hostname = <mail>
Operating system error : <No such file or directory>

3036/3168 WRK:Starting jdeCallObject Wed Jun 18 10:09:26.357006 jdesmtp.c1516
Leaving sendMimeMsgOnSMTPImpl with an error return code : <21>

JDEDebug.log:

Jun 18 10:09:23.751001 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)Entering sendMimeMsgOnSMTPImpl
myEmailAddress: <[email protected]>
emailSubject: <WorkOrder>
contentType: <text/plain>
numAttachments: 11
recipients: <>
cc: <>
bcc: <(null)>
toHeader: <[email protected]>
ccHeader: <>
Jun 18 10:09:23.751002 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)addSentDateHeader : Date : <Wed Jun 18 14:09:23 2014
>
Jun 18 10:09:23.751003 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)addSentDateHeader : Formatted Date : <Wed, 18 Jun 2014 14:09:23 +0000>
Jun 18 10:09:23.751004 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 1 of 11.
Jun 18 10:09:23.752000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 2 of 11.
Jun 18 10:09:23.755000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 3 of 11.
Jun 18 10:09:23.774000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 4 of 11.
Jun 18 10:09:23.775000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 5 of 11.
Jun 18 10:09:23.777000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 6 of 11.
Jun 18 10:09:23.778000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 7 of 11.
Jun 18 10:09:23.779000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 8 of 11.
Jun 18 10:09:23.794000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 9 of 11.
Jun 18 10:09:23.794001 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 10 of 11.
Jun 18 10:09:23.795000 - 3036/3168 WRK:Starting jdeCallObject (GENTEXT)generateMIMEAttachments : processing regular attachement 11 of 11.
Jun 18 10:09:26.357000 - 3036/3168 WRK:Starting jdeCallObject gethostbyname failed in jdeGetHostByName_r

In order to check, whether we had problem in jde.ini settings. we have created another UBE with EmailMergeLetter BSFN [B0500725] and deployed in server. It is working fine in both local and server.

For your reference, we have attached the BSFN code and log files from server.

Kindly check and help us to resolve this issue.

Thanks in advance.

 

[craig_welton]

The enterprise server INI has a setting for the SMTP server. Set that to the same value you have on your client workstation.

[JDEMAIL]
90|OPT|MAILSERVER=yourservergoeshere

 

[Ramprakash]

Hi Craig,

Thanks for your reply. Both (local and server) ini settings are same.

Regards,
Ramp

 

[craig_welton]

Ramp,

Sorry, I misread your post. I only see the jde.log attached to the post. Can you attach the code to the custom BSFN?

Craig

 

[Ramprakash]

Hi Craig,

We got the issue. Its because of JdeChDir API. When we checked in Oracle site, they are suggesting not to use it since its givng weird results. Hence we removed the API from BSFN. Oracle has put a new article on My Oracle Support for it - 1321239.1. Kindly check.

Thanks a lot for your help.

Regards,
Ramp