Materialized View Not Running After Being Disabled Then Re-enabled
(Doc ID 2266176.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 18.104.22.168.2 to 22.214.171.124.2 [Release 2.6 to 2.7]
Information in this document applies to any platform.
OUA 2.6.0 and 2.7.0
Materialized view not running after being disabled then re-enabled
If the Materialized view ends up in error and does not get completed even after retry for the day.
This entity is disable for the day and enabled after2 days. The entity does not appear in the ready view.
Steps to Reproduce
Follow the steps below to reproduce the issue:
1. Enable the load for the MV.
2. The MV load ends in error even after maximum retry per day is reached.
3. Disable the MV load.
4. After 2 days enable the MV load , this MV does not appear in the ready view.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document