Hi There
my emails are stuck in the queue. I have a system that send mails (from plsql). It has been working for 1 year or so until yesterday
environment: Oracle cloud ATP (always free)
SMTP_Credentials: created
APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', '<smtp>');
APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_USERNAME', <'user'>);
APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_PASSWORD', <'passwd'>);
Done.
Approved Sender: created
SELECT * from APEX_MAIL_queue ORDER BY 1 desc
MAIL_SEND_ERROR is NULL and MAIL_SEND_COUNT = 0 for all the messages in the queue
SELECT * from APEX_MAIL_log ORDER BY 1 desc
shows all the sent messages as usual (i.e. list of all the emails sent as when it was working)
also, executed several times apex_mail.push_queue with no result.
If look the Mail Queue Report in the apex admin page, it shows same stuff the above queries.
Force Send All Mails or Send All Mails makes no difference (nothing happens)
select * from ALL_SCHEDULER_JOB_RUN_DETAILS where job_name = 'ORACLE_APEX_MAIL_QUEUE' order by log_date desc;
returns status= SUCCEED but:
# APEX|WRN|Exception in "":
# APEX| |Error Stack: ORA-29279: SMTP permanent error: 535 Authentication credentials invalid
# APEX| |ORA-06512: at "APEX_200200.WWV_FLOW_MAIL", line 1083
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 57
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 164
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 487
# APEX| |ORA-06512: at "APEX_200200.WWV_FLOW_MAIL", line 1067
last not least
I don't know if this is related or not but: yesterday , I ran a buggie process that trigered a lot of emails (more than 200). I got an ORA error related to exceed the daily limit (not sure the exact number / text of the message)
any clue?
thanks!
sac