Unable to delete or Edit elements from OneClick

Article Id: 4006

Status: Published

Updated On: 14-02-2018 08:08

Legacy Id: TEC542039

Products:

EHEALTH - MISC , CA eHealth Performance Management - Data Polling , CA eHealth Performance Management - Usage and Administration , DEVELOPER PROG , REMOTE POLLER

Issue/Introduction:

Trying to Delete element or Edit Element you can see this errors:

Errors occurred for DCI delete on (). Some changes may not have completed

Errors Occurred.Some changes may not have completed

Environment:

eHealth 6.2.2

Resolution:

Try deleting elements from the command prompt and motif

    Delete using command line > nhDeleteElements
    Delete using motif

* If both fail, there could be 'orphaned' associations in these elements

There is a known workaround, see below. Please contact CA Technologies Support for further assistance if required.

Run the following query to check for orphaned associations
select * from nh_elem_assoc where element_id not in (select element_id from nh_element);

If the query returned anything, then there could be a corrupt database situation, so do the following

Stop the servers.
Then log into an sql prompt.
> delete from nh_elem_assoc where element_id not in (select element_id from nh_element);
> delete from nh_elem_assoc where parent_id not in (select element_id from nh_element);
> commit;
Then restart the servers and try deleting elements from the OneClick GUI again

* If both works, then:

Set the debug for the OneClick client:
For the cgi debug:
On the eH server, run these 2 commands:
cd $NH_HOME/web/cmi/bin
klog -clear -on
In OCE, reproduce the problem with the deletion and discover
On the eH server, run (do not use -clear!)
klog -off
Then collected the dekaf.log in the / or main partition for example: C:\dekaf.log

Check if all eHealth Services uses: %NH_USER%

If you say this messages in the dekaf.log:

05-25 11:01:42 | [1]Query:

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 | select E.name

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   from NH_ELEMENT E

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |      , NHGT_ELEMENT_UID T

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 | where T.element_id = E.element_id

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |    and T.machine_id = E.machine_id

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 | X:cmiDeleteElementsDci()

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - running: ksh -c '(E:\eHealth/bin/nhConfig.sh -logName -dciIn "C:/WINDOWS//cmi31223.dci"; echo DONE:$?) > C:/WINDOWS//cmi29829.out 2>&1 &'

| WAR | CMI   | 03100 | 2017-05-25 11:01:42 | SYS CMD FAILED:

| WAR | CMI   | 03100 | 2017-05-25 11:01:42 |   ksh -c '(E:\eHealth/bin/nhConfig.sh -logName -dciIn "C:/WINDOWS//cmi31223.dci"; echo DONE:$?) > C:/WINDOWS//cmi29829.out 2>&1 &'

| WAR | CMI   | 03100 | 2017-05-25 11:01:42 |   system() response: 1

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - determining CfgServer log file...

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - got: E:eHealth/bin/nhConfig.sh: not found

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - ignored.

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - got: DONE:127

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - spotted done.

| DBG | CMI   | 03100 | 2017-05-25 11:01:42 |   - no logName from CfgServer

From the Environment Variables the correct need to be:

NH_HOME=E:/eHealth

Fix the slash.

Shoud be /

Restart tomcat/apache.

Recomended to reboot the Server