2 Replies Latest reply on Dec 7, 2016 2:27 PM by Ramesh Reddy

    Internal Materialization : Dependent materialized views are not getting updated consistently

    Raghu Kasukurthi Newbie

      Hi Guys,

       

      I have a view(ex: VIEW_TOPLEVEL) in which Internal Materialization is enabled with TTL as 5 Minutes, this view is referring 3 other views (ex: CHILD_VIEW1,CHILD_VIEW2,CHILD_VIEW3) in which Internal Materialization is enabled with TTL as 5 Minutes.

       

      When run VIEW_TOPLEVEL view for the first time it is automatically triggering caching job for CHILD_VIEW1,CHILD_VIEW2. But it is not triggering caching job for CHILD_VIEW3.  But after 5 minutes(after expiry of initially loaded view data ) when we re-run VIEW_TOPLEVEL view , this time it is triggering caching job for CHILD_VIEW3 .

       

      I am not able to understand why did job for CHILD_VIEW3 didn't start very first time . why did it start next time .

       

      Any thoughts on this?

       

      Regards

      Raghu