How to Force Recompilation of a Selected Subset of Control Plans (Doc ID 1401536.1)

Last updated on JUNE 09, 2023

Applies to:

Oracle Communications Network Charging and Control - Version 2.2.0 and later
Information in this document applies to any platform.

Goal

During installation of a given Oracle Communications Network Charging and Control (NCC) patch, upgrade or interim patch, one could want to recompile all Control Plans matching a certain criteria (containing a given feature node is the most commonly encountered scenario, and will be the example used through this document).

This document describes how this can be achieved with a SQL command instead of manually recompiling all Control Plans through the Service Management Screens (SMS Screens).

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

1. Determine which criteria you will be using to select the appropriate control plan(s) to recompile

2. Find out the fast_key corresponding to the Feature Node

3. Edit the following SQL command to match the fast_key

4. [Optional] Find out which Control Plans contain this Feature Node

5. Execute the query after modification on the Service Management System (SMS)

Expected sample output :

Commit your changes :

Expected output :

6. [OPTIONAL] Monitor the number of control plan pending compilation :

Monitoring that the control plans are picked up correctly by the acsCompilerDaemon can be done using the following query:

This should return a decreasing number of rows - Example output :

Note that the acsCompilerDaemon's log file on the Service Management System (SMS) can also be monitored to verify that the control plan compilations are processed correctly.

7. [OPTIONAL] Check if a Control Plan has been recompiled and updated

To check if a given control plan has been recompiled correctly, it is possible to check in the Service Management System (SMS) database the version, build status, and change_date of a Control Plan using the fields "version", "build" and "change_date".

Replace CONTROL_PLAN_NAME with the name of a control plan that has been recompiled in the query above.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.