Unable To Add IXP Servers In A Subsystem From CCM GUI

Asset ID:	1-72-1963534.1
Update Date:	2015-02-01
Keywords:

Solution Type Problem Resolution Sure

Solution 1963534.1 : Unable To Add IXP Servers In A Subsystem From CCM GUI

Related Items


Oracle Communications Performance Intelligence Center (PIC) Software

Related Categories


PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC

The system prevents to add a server in a subsystem, in case the server was already by the past in this subsystem and has been removed from it previously. This is due to remaining elements in Oracle DB tables related to this server.

In this Document

Symptoms

Cause

Solution

Oracle Confidential PARTNER - Available to partners (SUN).
Reason: This is a sensitive action on the system that require a root password agreement and good knowledge on the system and strong knowledge in system architecture
Created from <SR 3-10133437571>

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 6.6.4 and later
Information in this document applies to any platform.

Symptoms

The system prevents to add a server in a subsystem via the GUI (CCM) even if this server exist and runs.

Cause

The server was already in the subsystem by the past and has been removed. Oracle DB tables on NSP side still contains several entries related to this object after the IXP server was removed from the configuration (CCM).

This is an issue in DB tables management on old systems. In some situation when removing servers from a subsystem and trying to add them again, it is not possible because of duplicated entries. This causes an inconsistency and the system prevents to add the objects.

Solution

First of all, check the situation on the subsystem by verifying tables content.

If the situation is confirmed, the solution is to remove manually entries in tables, directly with SQLPLUS commands to clean up tables. All elements related to the server must be removed.
After this action, servers can be added with GUI and the configuration can be finalized.

Connect on NSP Oracle box and launch the SQLPLUS command to connect on Oracle DB of NSP instance.

By convention, the server we want to add is <server_name>

SQLPLUS commands:

select object_id, name from cor_object where name like '%<server_name>%';
select mo_id, name from cor_managed_object where name like '%<server_name>%';

According to results (here, multiple results for the same server), entries will have to be removed from above tables (COR_OBJECT and COR_MANAGED_OBJECT).
Before that, related entries must be deleted from other tables, based on MO_ID get from first command result set.
Impacted tables, that must be checked are:

CFG_MO_MAPPING
COR_OBJECT_ROLE_PRIVILEGE
ALR_DISPLAY_MO
ALR_MO_AGGREGATE
COR_ALARM
COR_MO_ATTRIBUTES
COR_MO_REP

For each table, display its structure by using desc command (desc <table_name> and launch queries by using the MO_ID found by the 2 "select" commands given above.

It is sensitive to delete elements from Oracle DB tables. MO_ID must be checked carefully before do it.

Attachments

This solution has no attachment