nhConvertDb failed during upgrade to 6.3.2.13.

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

 

Issue: 

During the upgrade of eHealth 6.3.x to 6.3.2.13, we got an error that the nhConvertDb failed:

..

Convert Log entry

Command /opt/ehealth/r63/bin/sys/nhiDbTasks -doConvert -userLog /opt/ehealth/r63/log/conversion.08.04.2016.09.54.31.log failed..

Thu 10:11:44 | Error : Off line convert failed in convertStandalone.

Error : Off line convert failed in convertStandalone.

Thu 10:11:44 | You must undo convert before running nhConvertDb again.

You must undo convert before running nhConvertDb again.

Thu 10:11:44 | To undo convert run nhConvertDb -undoConvert.

To undo convert run nhConvertDb -undoConvert.

Thu 10:11:44 | Error : Convert standalone failed.

Error : Convert standalone failed.

 

Environment:  

eHealth 6.3.x being updated to 6.3.2.13

Resolution:

1.    check the current nh_convert_state

$NH_HOME/sys/nhisql "select state from nh_convert_state"

2.    If it is anything other than 0 or 4, set it to 4

&NH_HOME/bin/sys/nhisql "update nh_convert_state set state=4"

3.    Re-run the upgrade.