Oracle Communities

Oracle Analytics and AI

Child Item

How to Schedule an OAC workbook as an Email Output (PDF or PNG)

Dear Experts,

Please let me know a solution on how to schedule an OAC Workbook to be sent as an email (PDF or image) periodically (Daily , Weekly, Monthly). Since we have enabled the Preview Workbook Email Scheduler but still we are not getting email and also scheduled job running morethan 25 minutes and showing below error message, Please review below screenshot and provide your inputs.

Find more posts tagged with

FDI

OAC

Accepted answers

All comments

Federico Venturin - Oracle

Hi @User_57K2N ,

Did you restart your OAC instance after enabling the Preview Workbook Email Scheduler?

Did you setup an email server to deliver workbooks?

Does you workbook work as expected when you open it?

User_57K2N

Hi @Federico Venturin ,

Thanks for your response.

Please find my response below ,

Did you restart your OAC instance after enabling the Preview Workbook Email Scheduler? —> It is Enabled

Did you setup an email server to deliver workbooks? —> Can you please guide to check this setup

Does you workbook work as expected when you open it? —> it opens with a minute

Federico Venturin - Oracle

Hi @User_57K2N ,

Please refer to the following documentation for setting up an email server: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-email-server-deliver-reports.html

[Deleted User]

Hello @User_57K2N

Welcomed to the community, please update your profile, so we know with whom we are communicating with.

Thank you!

User_57K2N

Hi @Federico Venturin

Thanks for your quick response. Getting below error while opening Mail Setting under console. I have the service administrator group

There was a problem attempting to retrieve the mail settings. { type : detailError , errorType : DETAIL_ERROR , errorMessage : HTTP 401 Unauthorized }

Please guide me to ratify this issue.

Gianni Ceresa

@User_57K2N ,

Look at the linked discussion. Is your OAC a FDI/NSAW integrated OAC instance? Then this discussion tells you about the HTTP 401 when looking at the mail settings.

https://community.oracle.com/products/oracleanalytics/discussion/22231/oac-error-retriveving-mail-setting

KhaderBelgoud-Oracle

@User_57K2N , It looks like this error is from an FDI/NSAW integrated OAC instance.

If you can open the mail setting page, please verify the port and connection security specified

Common SMTP ports include:

25 (Connection Security = None)
465 (Connection Security = SSL/TLS)
587 (Connection Security = STARTTLS)

Mostafa Morsy-Oracle

@User_57K2N

looks like the Server is stuck with one job and give time-out after 24 Minutes for any scheduled woorkbooks

please file SR this need to be handled by DevOps Team