Hidden Client cannot be deleted using Utilities

Document ID : KB000087631
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U4006519 An object named '' already exists.

Trying to create a new client object, the following message appears:
0EMb0000001QVv4.png
 
Checking for this client in the Client Copy Utility, the client cannot be found.
0EMb0000001QVvJ.png
 
When creating a user for this client, it is possible to log in. But in <No Folder> there is no client object.
0EMb0000001QVvT.png
 
When a new client object is created, it checks to see if there is already a client with the same name and if there are objects under that client. In the above example, there must be a client that meets the above criteria and exists but it cannot be deleted by the Automic utilities because it can't be found there.

SOLUTION
 
This situation can only be resolved using SQL statements.
 
First, execute the following two SQL statements:
 

SQL> select oh_client, oh.oh_otype, oh_idnr, oh.oh_deleteflag, oh_name from oh where oh_otype = 'CLNT';

oh_client oh_otype oh_idnr     oh_deleteflag oh_name
--------- -------- ----------- ------------- -------
0         CLNT     79          0             0000
666       CLNT     1061161     0             0666
1234      CLNT     1070132     0             1234
0         CLNT     787         0             CLNT

4 rows selected.

SQL> select * from MAND;

MAND_OH_Idnr MAND_MibMonitor MAND_MibInfo
------------ --------------- ------------
79           0
787          0
1061161      0
1070132      0

4 rows selected.

 
There is no Client 9999 in the OH-table and no corresponding entry (with the same OH_Idnr) in the table MAND. On the other hand, there are objects related to this client:
 

SQL> select oh_client, oh.oh_otype, oh_idnr, oh.oh_deleteflag, oh_name from oh where oh_client = 9999;

oh_client oh_otype oh_idnr     oh_deleteflag oh_name
--------- -------- ----------- ------------- ----------------------------
9999      QUEUE    1347101     0             CLIENT_QUEUE
9999      USER     1347102     0             999/999
9999      VARA     1330023     0             UC_USER_HOST
9999      VARA     1330024     0             UC_USER_LANGUAGE

6 rows selected.

 
When a new client object is created, it checks to see if there is already a client with the same name and if there are objects under that client. In this case, the latter is fulfilled and so the client cannot be created. Execute the following commands. As oh_client in the last command use a client number that does not exist yet - this is very important.
 

update oh set oh_deleteflag = 1 where oh_client = 9999;
update oh set oh_name=(OH_Name + '_' + (SUBSTRING('0000000000',1,(10-len(OH_Idnr))))+convert(varchar(10),OH_IDNR)) where oh_client = 9999;
update oh set oh_client = 333 where oh_client = 9999;

 
The objects are set to deleted and are renamed, and then moved to a non existent client.
 
The client object with the name 9999 can now be created in the GUI without any errors. After the creation of the client object, please do not use this client in any way (no log in, no user creation, etc.).  Instead, move the objects back to client 9999 as follows:

 
update oh set oh_client = 9999 where oh_client = 333;

 
The client can now be deleted by the Client Copy Utility.

 
Cause:
Cause type:
Other
Root Cause: User accidentally deleted an entry.
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: No Fix

Additional Information:
Workaround :
N/A