DAC Email Notification Not Working (Doc ID 1527685.1)

Last updated on NOVEMBER 30, 2015

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.5 and later
Information in this document applies to any platform.

Symptoms

DAC version 10.1.3.4.1

All users Notification level is 10

Email notification TEST is working. But do get any Email notification when the ETL started/finished.


Error from log file when DAC is starting.

INFO: Server Pools created.
70  INFO  Wed Feb 06 10:18:57 EST 2013  Returning an instance of EmailManager...

Feb 6, 2013 10:18:57 AM global
INFO: Returning an instance of EmailManager...
71  FINE  Wed Feb 06 10:18:57 EST 2013  At the start of EmailManager.dispatch

72  INFO  Wed Feb 06 10:18:57 EST 2013  EmailManager.dispatch : Created a message...

Feb 6, 2013 10:18:57 AM global
INFO: EmailManager.dispatch : Created a message...
73  FINE  Wed Feb 06 10:18:57 EST 2013  Starting Inside EmailManager.wrapMessage()

74  FINE  Wed Feb 06 10:18:57 EST 2013  Inside EmailManager.wrapMessage(): template read and closed

javax.mail.MessagingException: Exception reading response;
nested exception is:
      java.net.SocketException: Connection reset
      at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
      at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
      at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
      at javax.mail.Service.connect(Service.java:275)
      at javax.mail.Service.connect(Service.java:156)
      at javax.mail.Service.connect(Service.java:105)
      at javax.mail.Transport.send0(Transport.java:168)
      at javax.mail.Transport.send(Transport.java:98)
      at com.siebel.etl.email.EmailManager.dispatchJMail(EmailManager.java:531)
      at com.siebel.etl.email.EmailManager.dispatch(EmailManager.java:394)
      at com.siebel.etl.email.EmailManager.safeDispatch(EmailManager.java:353)
      at com.siebel.etl.engine.core.ETL.sendEmail(ETL.java:866)
      at com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:303)
      at com.siebel.etl.engine.core.ETL.run(ETL.java:659)
      at com.siebel.etl.engine.core.ETL.execute(ETL.java:911)
      at com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
      at com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:165)
      at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.SocketException: Connection reset
      at java.net.SocketInputStream.read(SocketInputStream.java:168)
      at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
      at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
      at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
      at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
      at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)
      ... 17 more
75  INFO  Wed Feb 06 10:18:58 EST 2013  Getting actual start timestamp for this ETL

Feb 6, 2013 10:18:58 AM global
INFO: Getting actual start timestamp for this ETL
76  INFO  Wed Feb 06 10:18:58 EST 2013  The actual timestamp is 2013-02-06 10:18:49.759

Feb 6, 2013 10:18:58 AM global
INFO: The actual timestamp is 2013-02-06 10:18:49.759
77  INFO  Wed Feb 06 10:18:58 EST 2013  Initializing ETL parameters.
Feb 6, 2013 10:18:58 AM global
INFO: Initializing ETL parameters.

 

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