Agent works but doesn't send mail (OBIEE 11g) — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Agent works but doesn't send mail (OBIEE 11g)

Received Response
141
Views
7
Comments
Flavia
Flavia Rank 2 - Community Beginner

Hi!

For some reason the agents that I run from the BI console (obiee 11g)  can't send mails. The report works but doesn't send mail.

It was running until 11/1/2016 and stopped working the next day.

I have already reviewed the following settings and files:

- Scheduler logs (Agent.log):  I didn't find any errors in these logs. No errors in other logs.

- Mail configuration: Logging into EM (Fusion Middleware Control) > coreapplication> Deployment> Mail> SMTP server - Port - email address of sender (it's ok)

- Server configuration: checked /etc/postfix/main.cf (it's ok). The mailing service works (mails were received from the server without problems).

- SMTP server: this was checked and mail sending is enabled.

- Destination (recipient) mail configuration: Logging into BI Console configuration> Signed In As "My User"> My Account> 1) Delivery Options> Edit Device> Address / Number (it's ok)

- Report size: Reports weigh less than 200 kb (I discard this is a size problem).

- Modify instanceconfig.xml: SMTP_Port, SMTP_Server and Sender parameters are fine

Any suggestions?

On where could i look for some relevant logs?

Thanks !!!

Answers

  • Gbenga Ajakaye
    Gbenga Ajakaye Rank 5 - Community Champion

    Have you try just stopping your agent and listener? Then restart them and try to see if you'll get email after?

  • Flavia
    Flavia Rank 2 - Community Beginner

    Hi!

    yes but still doesn't work :<

    regards,

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    2789268 wrote:Hi!For some reason the agents that I run from the BI console (obiee 11g) can't send mails. The report works but doesn't send mail.It was running until 11/1/2016 and stopped working the next day.

    ^---- So the 1m$ question is: What has been changed?!

  • Flavia
    Flavia Rank 2 - Community Beginner

    Hi Christian!

    Before 11/1/2016:

    10/27/2016  upgrade RPD

    Requested restart of OPMN OracleBIPresentationServicesComponent (reason: installation in RPD).

    What did they install? I still can't confirm it.

    After 11/1/2016:

    11/3/2016: StuckThreadMaxTime parameter modification (from 600 to 1500). Restart managed weblogic bi_server1 (reason: "Warning" ThreadPool has stuck threads).

    there wasn't changes

    regards,

  • P G
    P G Rank 3 - Community Apprentice

    Hi,

    Agents can execute based on a specified schedule.Can you Define starting date and time for the agent?

  • Flavia
    Flavia Rank 2 - Community Beginner

    Hi PG!

    yes i can. Actually the "frecuency" is "daily".

    Regards

    schedule.jpg

  • Flavia
    Flavia Rank 2 - Community Beginner

    Hi again.

    I received an empty email modifying the "Delivery Content" (Format: Plain Text - Deliver results directly). In others "Formats" i didn´t receive emails.

    Delivery_Content.jpg

    Delivery_Content_Plain_text.jpg

    .....missing graphics

    mail.jpg

    Regards,