OBIEE Scheduling through SMTP Server

Question

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

Gianni Ceresa · Answer

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.

asim cholas · Answer

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)?

961614 · Answer

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.