• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Bi Publisher email failure

jimmymac

Reputable Poster
We are on E1 and using the embedded BI publisher.

We are trying for the first time to set up the embedded JDE BI/XML publisher to email. What we are working toward is bursting then emailing ACH remittances. To test things out and to see how it works, I am trying to do a simple testing in DEV.

I have added in the BIP Burst/Deliver options on P95620 with a specific email address to use, mine. When we run the ACH remittance, it shows Communication Failure in the Output delivery details. Our jde.ini is set up with the correct outgoing email server and we are receiving emails like job completion emails from both production and development.

In the log on the enterprise server there are the following messages.

Fail to fetch Error Text 951S from Data Dictionary (951S does in fact exist though).
Unable to get email subject.
JDB_Fetch F95624 failed with rcode=0
Send email failed with return code 6.

Oracle has of yet to be of much help, so any thoughts would be appreciated.
 

jimmymac

Reputable Poster
Thanks, reviewing the document, and putting in a from email address as it suggested got rid of the first three messages, but it still fails.

Now the only error is..
Send email failed with return code 6
 

jimmymac

Reputable Poster
Email problem solved. The issue turned out to be missing Text in the data dictionary items 951S and 951T. These are error DD items for email subject and text. Once we populated the Text for these two items, emailing works.
 
Top