DAC11g Upgrade - Email Notification is not Working. "ANOMALY INFO:::" Error Sending an Email "EXCEPTION CLASS::: javax.mail.AuthenticationFailedException" (Doc ID 1969891.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

DAC11g (upgrade version) is installed on LINUX server (same as the old DAC10g version).

After configuring the Email Recipients in DAC Client, i.e. there is a valid record in the W_ETL_MAIL table owned by DAC user.

Steps followed:
1. Run the startserver.sh on the DAC_HOME to start the DAC server, and verified by DAC Server Monitor Icon on the DAC Client turning to AMBER (Idle State)
2. Run the standaloneServerSetupPrompt.sh on the DAC_HOME, choose option 3 to Enter email account information, choose option 5 to save the changes.
3. Restart the DAC Server, and run the standaloneServerSetupPrompt.sh again, and choose option 4 to Send test email.

The DAC Server fails to send the test email and return errors

SEVERE:ANOMALY INFO::: null:select * from W_ETL_EMAIL WHERE INACTIVE_FLG <> 'Y' null
EXCEPTION CLASS::: com.siebel.etl.database.DataSourceNotFoundException

..
WARNING: Warning: No receipients for email registered! Please register email recipients who will be informed about ETL progression.
Feb 10, 2015 10:09:23 AM com.siebel.etl.email.EmailManager dispatchJMail
INFO: EmailManager.dispatch : Created a message...
Feb 10, 2015 10:09:28 AM com.siebel.etl.engine.core.ETLUtils logException
SEVERE:
ANOMALY INFO::: Error sending an email
EXCEPTION CLASS::: javax.mail.AuthenticationFailedException


There were warnings/errors while sending test email.

Warning: No receipients for email registered! Please register email recipients who will be informed about ETL progression.

This email could not be completely sent! Please inspect the stack-trace below, and inform the DAC administrator
javax.mail.AuthenticationFailedException

In addition to the above, the notification email is not sent upon starting, completion or failure of an Execution Plan either.

The following error is seen in the DAC log:

 

2653  FINE  Wed Feb 11 13:16:09 GMT 2015  At the start of EmailManager.dispatch
2654  INFO  Wed Feb 11 13:16:09 GMT 2015  EmailManager.dispatch : Created a message...
2655  FINE  Wed Feb 11 13:16:09 GMT 2015  Starting Inside EmailManager.wrapMessage()
2656  FINE  Wed Feb 11 13:16:09 GMT 2015  Inside EmailManager.wrapMessage(): template read and closed
2657  SEVERE  Wed Feb 11 13:16:14 GMT 2015  
ANOMALY INFO::: Error sending an email
EXCEPTION CLASS::: javax.mail.AuthenticationFailedException

 

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