Publisher report is not sent due to timeout even though it took 6 minutes 1 month ago

Question

Hello Team,

I created a publisher report that took 6 minutes to send a month ago, but now it times out after 1800 seconds. I tried step-by-step to figure out which dataset is the bottleneck, but even with just a few datasets, the report struggles to send after several minutes. I checked the underlying tables in the database, but they haven't significantly increased data. What could be the cause?

Regards

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/76635#Comment_76635

Please confirm if there were some performance intensive programs were running during the last execution. Monitor for few days, if you encounter an issue again, it would be better towards working on the perf enhancement or make sure that no resource intensive program is running in parallel.

Thanks.

_vero_ · Answer

hello,

After several launch attempts, it returned to a 6-minute duration. I'm concerned that it will have to be a monthly schedule, and the data changes every month, considering that it retrieves data from the previous month. Perhaps after several timed-out attempts, it retrieved what it could from the cache and returned to an acceptable time?

This difference in performance is worrying

Regards

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28685/publisher-report-is-not-sent-due-to-timeout-even-though-it-took-6-minutes-1-month-ago

Hi,

Can you schedule the report and check approx how much time it is taking to run?

The error while editing, can you try it in incognito mode? I have seen this happening where there was a lot of code in one of MY BIP reports.

Thanks.