Unable to delete or Edit elements from OneClick

Products

• CA eHealth

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