Assume the IPTCM database has two entries of Communication Manager systems with rtsappids 50 and 100. Use this procedure to remove the Communication Manager system with the rtsappid 100 and reinstate the entry of the legitimate Communication Manager with rtsappid 50.
Procedure
To set the rtsappid to null and the name to any arbitrary value for Communication Manager having rtsappid 100, run the following query:
update ipt_cm set cmname='ABC',rtsappid= null where id = 100;
To modify the IP addresses in the ipt_cm_conn table, run the following query:
update ipt_cm_conn set ipaddress1='1.1.1.1' , ipaddress2='1.1.1.1' where id = 100;
To run the maintenance job for Communication Manager on the System Manager web console, click Services > Scheduler > Pending Jobs.
The system removes the entry cm_id=100 from the tables ipt_cm and ipt_cm_conn.
To add the entry of the Communication Manager system again, from Runtime Topology System (RTS), provide the IP address and the name of the legitimate Communication Manager system.
Note:
If the details you enter do not match with the legitimate Communication Manager, the system adds a new entry for the Communication Manager in the ipt_cm table.
To retrieve the Communication Manager ID you entered in step 4, from the rts_applicationsystem table, run the following query:
select id,name from rts_applicationsystem;
The Communication Manager ID is the rtsappid for the ipt_cm table.
To update the rtsappid in the ipt_cm table with the ID you retrieved from the previous step, run the following query:
update ipt_cm set rtsappid=? where id = 50;
Verify if the synchronization is working for Communication Manager.
The system modifies the rtsappid for Communication Manager.
