Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE Scheduling through SMTP Server

Received Response
11
Views
6
Comments
961614
961614 Rank 4 - Community Specialist
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Dear All,

I have configured SMTP server in production and configured  agent successfully. User are getting mails daily  at 10:00 AM.

But from last 7 days on wards users are getting mails at 10:00 PM instead of 10:00 AM. I have started investigation about this issue and understood one thong, If the file size having below 400 kb it is triggering at 10:00 AM. In case file size having more than 400 kb it is triggering at 10:00 PM.

I have scheduled this report in XLSX 2007 format. Kindly help me how to fix this issue.

Thanks,

Ramesh

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    There is no reason i could find for this .. did you increase the number of records in agent in enterprise manager. Can you please increase it to the maximum report can have and try.? by default agent will send 75 records.

  • 961614
    961614 Rank 4 - Community Specialist

    Dear Asim,

    it is already increased.

    Thanks,

    Ramesh

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    The emails being sent at 10AM or 10PM is one thing, but at what time does the OBIEE agent run?

    Because exactly 10h00 or 22h00 sounds too "precise" ...

    Look at the logs on the OBIEE side and check when things are executed and what happen at that point, maybe the issue is somewhere else (also outside OBIEE).

  • 961614
    961614 Rank 4 - Community Specialist

    Hi Gianni,

    Schedule time is 10:00 AM only but if the file size having more than 400 KB , that mail I am receiving at 10:00 PM.

    I didn't find any logs because agent trigger successful.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    what is the begin time and end time shown in job manager (job instance view)?

    What is the last run time and next run time shown in (Job view)?

  • Gianni Ceresa
    Gianni Ceresa Mod 
    961614 wrote:Schedule time is 10:00 AM only but if the file size having more than 400 KB , that mail I am receiving at 10:00 PM.I didn't find any logs because agent trigger successful.

    There are always logs, for every single agent executed there is a log. Agents also execute analysis which also generate logs.

    Scheduled time isn't important, what you have to look for is the real execution time and logs.

    Why? Because how can you prove it isn't your mail server keeping emails in queue till the night based on a size rule? Or anything else around your network?

    Agents have 2-3 database tables where there are logs for every single occurrence, so look at everything you have.