Description:
When the nhConvertDb command fails when altering a materialized view, the error in the convertDb log file contains the following information:
Mon 16:47:20 | nhiConvertDb: /opt/eHealth63/bin/sys/nhiConvertDb -u'caadm' -d'undoConvert' -p/opt/eHealth63/tmp - userLog /opt/eHealth63/log/conversion.10.15.2012.16.46.19.log 10/15/2012 04:47:22 PM - Conversion through latest minor revision '40' complete. Fatal database error: disableMviewRefreshClause: Failed to disable fast refresh: ALTER MATERIALIZED VIEW NH_GROUP_CONTENT_TYPES REFRESH FAST ON DEMAND 15-Oct-2012 16:47:25: database error: -23413 ORA-23413: table "CAADM"."NH_ELEMENT" does not have a materialized vie Command disableMviewRefreshClause( ) failed.. Mon 16:47:25 | Error : Off line convert failed in convertStandalone. Error : Off line convert failed in convertStandalone. Mon 16:47:25 | You must undo convert before running nhConvertDb again. You must undo convert before running nhConvertDb again. Mon 16:47:25 | To undo convert run nhConvertDb -undoConvert. To undo convert run nhConvertDb -undoConvert.
Solution:
Follow the steps below to resolve the issue. All steps below should be done as $NH_USER