You are currently reviewing an older revision of this page.
In Process Monitor form error to be shown next to TMA Works Phase Master refresh proccess:
error in materialized view refresh path
Run this query as a highways owner:
select * from all_objects where status <> 'VALID';
Take a look which materialized views has invalid status. (In our case, see below)
We found few invalid materialized views that could cause this error. To fix this issue, we suggest to do it manually. For example, in SQL developer:
1. Connect to your database;2. Expand Materialized Views branch;3. See failed materialized views in your case (information taken from sql queries you've provided) :MV_TMA_Permits, MV_TMA_Works_Phase_Master, MV_TMA_NOTICE_DATES, MV_TMA_NOTICES, MV_TMA_WPSS, MV_TMA7500_Permit_status;4. Highlight one of them5. Open it's SQL query and copy it somewhere else6. Right click on the highlighted materialized view and press Drop7. Copy the SQL query and run it (this should take a long time to run)8. Repeat steps for all invalid materialized views.