nhConvertDb fails when altering materialized view

Document ID : KB000049258
Last Modified Date : 14/02/2018
Show Technical Document Details

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

  1. $NH_HOME/bin/sys/nhiSql "drop MATERIALIZED VIEW NH_GROUP_CONTENT_TYPES"

  2. nhConvertDb -undoConvert

  3. Run nhConvertDb from command line, or rerun the eHealth patching or device patching if the convertDb failed from either of these tasks