Agent Reports not upadating after a certain date

Question

Hi all,

I am using BI EE and we have various agents that run daily and weekly reports. They have stopped updating past the 3rd January for some reason, so the daily reports are only showing data for the 3rd of Jan everyday. I can't figure out why, new data is going into the database and because I can get updated information from other sources. I've tried restarting the Oracle services on the server with no effect.

Any ideas why this might be happening?

Oracle Business Intelligence 11.1.1.7.140715

Gianni Ceresa · Answer

A report is just a query, first LSQL and then a physical query is generated.

Did you look at the logs for the report? Did you see the physical query? Does it contain a filter, condition, join explaining that data isn't updated?

If yes => you know what to look for (it can be in many places in your system, so not going to make a random list.

If no => you know what to look for (again), your source system isn't updated ...

Phil Griffiths · Answer

Thanks for that, sorry I was using confusing terms. I am focusing on the reports. It's quite odd, I cannot find any reason why this is happening. I've checked the filters, reports, cleared the cache. Just can't seem to find a solution to reports not updating.

Any other suggestions, it seems like me of an overall system/database issue than a report issue.

Gianni Ceresa · Answer

Well ... an agent is just an automated execution of a report, so it's not the agent not updating but normal users will also have the same issue running the same query.

The easiest thing is to look at what the report sent by the agent does: how does it select the period? is it based on a variable? is the variable up to date? what happen in your ran the same query as the report/variable? did you enabled cache without a proper strategy to refresh it? somebody changed something when things stopped working?

Phil Griffiths wrote:...new data is going into the database ...

Doesn't mean your new data is going in the right place, maybe you just continue to load a bunch of table but something is blocking the tables used by your agents to be updated, so data is only "partially" going into the database ...

Start analyzing the report of the agent, forgetting about the agent itself.