Oracle Communications Performance Intelligence Center (PIC) Software
 

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

In this Document

Symptoms

Changes

Cause

Solution

References

Created from <SR 3-12743988661>

Applies to:

Symptoms

The excluded applications selected in each profiles are lost during the upgrade of NSP to PIC 10.2. This issue is providing access to some NSP applications the users should not have.

Changes

NSP has been upgraded to PIC 10.2.

Cause

This is issue is bug: during the upgrade the excluded applications linked to the user profiles are lost: bug 23535365 has been created to address the issue.

After verification of the NSP backup prior and after upgrade we found that the oracle table called COR_USER_PROFILE_ENTRIES and containing the excluded application is empty. 

Solution

To fix the issue the list off excluded application for each profile must be documented prior to the upgrade.

If the excluded application list has not been documented then we must extract it from a backup prior to the upgrade. To do that the following sql query can be performed in the NSP Oracle Database where the backup prior to upgrade has been imported:

1. Log as oracle user on the NSP server
2. Connect with sqlplus:
   sqlplus nsp/<passord>
3. Verification:
   select A.PROFILE_ID,A.ENTRY_ID,B.NAME from COR_USER_PROFILE_ENTRIES A, POR_PORTAL_ENTRY B where A.ENTRY_ID=B.ENTRY_ID;

From that list the excluded applications can be reconfigured in the NSP Security application for each profile listed in the query result.

References

This solution has no attachment