OBIEE 12.2.1.3 reports in a dashboard show old data

Question

Hi Gurus,

We used to have one user who created lot of reports and put them in a dashboard.

All the reports/dashboard he created used to run fine and results were up to date. Once he left organization and his account got deactivated. And now users complain that those reports not showing latest data.

Is this because the ownership for those objects are still in the name of user who left company ?

Please share how to make these reports show latest data..

Thanks in advance.

[Deleted User] · Answer

https://community.oracle.com/tech/apps-infra/discussion/comment/16855759#Comment_16855759

"As its production env, logging disabled."

For what conceivable reason would logging be turned off in Production?

That's the same as saying "As I'm driving 300km/h, air bags, breaks, and power steering are disabled."

Gianni Ceresa · Answer

As its production env, logging disabled.

Sorry but what is this supposed to mean? What’s the theory of disabling logging in prod? Please don’t tell me it’s because you believe the myth that disabling logging improve performance.

Exactly because it’s a prod environment you need logging, because guess what? How are you supposed to fix prod issues if you don’t know what’s going on?

Of course you can guess, but while that isn’t too harmful in dev, I wouldn’t really bet everything on guessing on prod.

It’s just so wrong that I don’t even want to try to guess what could be happening if everything has been done along that line…

Enable logging, look at what is happening, fix exactly the issue without guessing what it could be.

Joe_obieeoas · Answer

Thanks Gianni.

These are analysis.   As its production env,  logging disabled.

Possible option(s):

Set CACHE Enable to NO in NQSConfig file (right now its YES)

Please throw in some suggestions might help in getting latest data.

Regards.