Logs for Workbook Jobs

Question

Scheduling/Running Workbooks fail to deliver emails. The job creates the workbook output, but cannot seem to email it out. We looked in the OCI OAC logs but not about email is there. We are using the email settings in the Console. Do anyone know were to find the details behind this general "An error occurred…" message?

SRG2024 · Answer

Hi All

we have also encountered similar issue , all of sudden our jobs to email Workbook output are now erroring out. We have enable OCI logging , but we don't see any thing related to OAC errors in OCI logs. Any idea how we can track OAC errors in OCI logs.

Carter Beaton · Answer

Thank you Sandeep for your reply. I am looking for the logs so we can see the details around the errors eventually set up Notifications if we get an error. We don't see the an email error in the OCI logs. So I am looking for information on were that error would could be found in the OCI logs.

Sandeep S. Chauhan-Oracle · Answer

Hi Carter, Have you checked whether SMTP configuration is correct & working. You can verify by native export/email option- https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/email-file-visualization-canvas-or-dashboard.html

FYI, you need to configure the email as per OCI documentation , you need to have approved sender email ids , that approved email id need to used as delivery from email in Email setting in the OAC.

https://docs.oracle.com/en-us/iaas/Content/Email/Tasks/managingapprovedsenders.htm

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/use-smtp-mail-server-oracle-cloud-infrastructure-email-delivery.html

https://docs.oracle.com/en-us/iaas/Content/Email/Reference/managingapprovedsenders_topic-create_an_approved_sender.htm