Unable to add web user in One Click for eHealth

Products

• CA eHealth

Issue/Introduction

The following error appears, when attempting to add a web user in One Click for eHealth

Database Error: 
ORA-25207:enqueue failed, queue USERCHANGE is disabled from enqueueing [KSQL:ParseSQL:OCIStm 
insert into NHV_USER 

 

Environment

eHealth, all versions, all operating systems

Cause

The USERCHANGE queue is disabled, and therefore, unable to create or change users

 

Resolution

1. Check to see if the queue is present and valid

Run $NH_HOME/bin/sys/nhisql "select * from dba_objects where object_name='USERCHANGE'"

You will get output, similar to the following; notice the namespace includes "EHEALTH" (the instance name)

 

EHEALTH                  USERCHANGE

   719646                QUEUE

02-22-2016-07:08:28 02-22-2016-07:08:28 2016-02-22:07:08:28 VALID   N N N         10

 

If the queue is there and is valid, continue to step 2

 

2. login to sqlplus and run the following (sqlplus ehealth/ehealth) for example

exec dbms_aqadm.start_queue (queue_name => 'EHEALTH.USERCHANGE');

(you should see the following response, if successful)

PL/SQL procedure successfully completed

 

It is likely that you will need to do the same thing for the "USERPASSWDCHANGE" queue, also

 

3. run the following, to start the USERPASSWDCHANGE queue

exec dbms_aqadm.start_queue (queue_name => 'EHEALTH.USERPASSWDCHANGE');

(Again, you should see the following response, if successful)

PL/SQL procedure successfully completed

 

4. Exit sqplus and create a web user in One Click for eHealth