handle SQL exceptions and redo the rp materialized view build and its indexes