Continuation - "Unable Read Dictionary From Oracle" During Session Upgrade

Asset ID:	1-72-2398655.1
Update Date:	2018-05-15
Keywords:

Solution Type Problem Resolution Sure

Solution 2398655.1 : Continuation - "Unable Read Dictionary From Oracle" During Session Upgrade

Applies to:

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

Symptoms

Customer getting an error "Unable to read dictionary" when trying to modify an existing query for a particular session.

Cause

Cause of the issue is non update of status of upgrade in database.

Solution

Need to update the state of upgrade in DB. Change the value of status from "Q" to "N". Where "Q" indicates upgrade is successful but not yet normalized and "N" is normalized.

Check if the current state of problematic query is "Q" in NSP database:

SELECT STATE FROM CFG_DICTIONARY WHERE NAME=<PROBLEMATIC DICTIONARY NAME>;

If the output from above query is Q then run the following queries in NSP database to get rid of situation:

UPDATE CFG_DICTIONARY SET STATE='N' WHERE NAME =<PROBLEMATIC DICTIONARY NAME>;

COMMIT;

Attachments

This solution has no attachment