Bulk Report Transmit Email AG Service Not Transmitting The Records (Doc ID 2568580.1)

Last updated on AUGUST 23, 2019

Applies to:

Symptoms

Bulk Report Transmit Email AG service was not transmitting records.
Every time when Bulk Report Transmit Email AG service runs, the AG logs shows corresponding STARTED but there is NO corresponding STOPPED message.

AG Logs :
====
01-Aug-2018, 00:01:37 >> XXXXXXX-General Email > "E:\Argus\Argus Safety\AGProc_General_Email.exe XXXXXXX-General Email GENERAL EMAIL" started.
01-Aug-2018, 00:01:57 >> XXXXXXXX-General Email > Enterprise DEFAULT : Could not send mail through SMTP for Email ID XXXXX. SMTP protocol error. XXX.X.X.X Invalid address.
Could not send mail through SMTP for Email ID XXXXXXX. SMTP protocol error. XXX.X.X.X Invalid address.
Could not send mail through SMTP for Email ID XXXXXXX. SMTP protocol error. XXX.X.X.X Invalid address.
Could not send mail through SMTP for Email ID XXXXXXX. SMTP protocol error. XXX.X.X.X Invalid address.
Could not send mail through SMTP for Email ID XXXXXXX. SMTP protocol error. XXX.X.X.X Invalid address

This was impacting report transmission to Agency and there were significant backlogs (~1402 records in RPT_Transmit_LOG table where transmit_status=0).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.