What do the NH_CONVERT_STATE column values mean

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

QUESTION:

What are the various states which the eHealth Oracle database can be in and what do the state values of the NH_CONVERT_STATE table represent?

 

ANSWER:

DuConvertInitialized = 0                   After a successful convert, the state should be this
DuOnlinePreConvertStarted, =1
DuOnlinePreConvertFinished, = 2
DuSavePriorVersionStarted = 3         Backing up the existing database configuration tables
DuSavePriorVersionFinished = 4
DuOfflineConvertStarted = 5             When a doConvert operation fails, it typically leaves the database in this state
DuOfflineConvertFinished = 6
DuSwitchBackStarted = 7                
DuSwitchBackFinished = 8                After successfully running undoConvert, the state will be this
DuCleanUpStarted = 9


ADDITIONAL INFORMATION:

The NH_CONVERT_STATE table is used during upgrade operations.