Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Oracle Analytics Cloud Self Service Analytics - Stale Data

Received Response
21
Views
1
Comments
User_6TYAN
User_6TYAN Rank 1 - Community Starter
in Oracle Analytics Forum

Our database, VM DB System Standard2.1, experienced a significant change on its records and it isn't being reflected upon our OAC workbooks. It has been attempted to refresh the datasets, change them from caching to live, closing cursors from query cache and turning caching off in the system settings all with similar results.

Is there any other options or what can be done?

Answers

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    Assuming you are using a dataset, to trouble shoot, I would create a new dataset from the tables and see if that has the old information. If it does, then it is likely something in the DB. IF that does work -- it is not clear when Live would not get the latest information. Be sure all tables in the dataset are set to live.