ProTrace Trace Function Does Not Work When an XDR Storage Is in MAINTENANCE Mode "ORA-00942: table or view does not exist"

Asset ID:	1-71-2090023.1
Update Date:	2015-12-18
Keywords:

Solution Type Technical Instruction Sure

Solution 2090023.1 : ProTrace Trace Function Does Not Work When an XDR Storage Is in MAINTENANCE Mode "ORA-00942: table or view does not exist"

Applies to:

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

Goal

The trace function (not query) in ProTrace will generate an exception "ORA-00942: table or view does not exist" if the Session View containing XDR sessions are stored on a Pool where one of the XDR Storage is in MAINTENANCE mode and not reachable.

What needs to be done to make the trace work again until the XDR Storage in MAINTENANCE is fixed ?

Solution

To avoid the oracle error the XDR Storage in maintenance must be removed from the IXP DWS POOL.

To do so:

Connect to the NSP GUI as Admin user and enter Centralized Configuration application.
Navigate to Equipment Registry and open the tree to display the XDR storages present in the IXP pool Sites/IXPxxxx/DWH/IXPxxxx_Pool.
Select the XDR Storage that has been set in MAINTENANCE mode and hit the "delete" button
Navigate to Mediation and apply changes on the concerned IXP subsystem.
The trace will now work without error. Once the XDR storage is fixed it can be added back in the Pool.

Attachments

This solution has no attachment