Unable to add user to eHealth OneClick

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

Problem: 

When trying to add a user in eHealth I get this error:

ORA-24010: QUEUE SVCEHEALTH.USERCHANGE does not exist.

 

Environment:  

eHealth 6.3.x

 

Cause: 

This could be caused by a database conversion failure during either an nhLoadDb or an upgrade.

First let's check the database conversion state:

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

This should return 0.

Next let’s check if this table is indeed missing:

$NH_HOME/bin/sys/nhisql "select * from dba_objects where

object_name='USERCHANGE'"

 

If the convert state is anything other than 0, and/or the table is missing, see resolution below.

 

Resolution:

nhServer stop

nhConvertDb -undoConvert

nhConvertDb

 

Now verify that the convert state is correct:

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

This should return 0.

And verify that the table now exists:

$NH_HOME/bin/sys/nhisql "select * from dba_objects where

object_name='USERCHANGE'"

 

Additional Information:

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1878245.aspx

 

 

See the eHealth command reference guide.