Apply Changes Failed On Subsystem IXP

Asset ID:	1-72-2256598.1
Update Date:	2017-04-24
Keywords:

Solution Type Problem Resolution Sure

Solution 2256598.1 : Apply Changes Failed On Subsystem IXP

Applies to:

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

Symptoms

The Apply Changes does not complete and displays an error message (e.g. "Applying Changes on Subsystem: ixp0001: Failed").

In parallel, the application.log file (on NSP side) shows the following error:

2017-03-27 17:25:19,259 - ERROR - NSP - Centralized Configuration - JohnSmith - BUSINESS - Failed to apply configuration to subsystem ixp0003 - com.steleus.nsp.config.system.exception.NSPCentConfException: Failed to apply changes because of the following errors :
Stream
Incorrect string value: '\xB7Build...' for column 'UserInformation' at row 1
XdrBuilder
Incorrect string value: '\xB7Build...' for column 'OutStreamName' at row 1
DECfgVwIpClassifierMapping
Can't write; duplicate key in table 'DECfgVwIpClassifierMapping'

Changes

Some elements were changed in the IXP configuration.

Cause

The error message of the application.log file indicates a "wrong" character is present in configuration files. More precisely here, it is in IDB table.

More precisely, in current example, it is in IDB tables "Stream" and "XdrBuilder".

In fact, this prevent the system to replace the content of the IDB table because of wrong character is not manageable by the system.

Solution

The goal is to remove the lines having wrong content from IDB tables:

Connect on the master server of IXP subsystem where the issue was raised.
Edit the IDB tables Stream and XdrBuilder (with ivi) and look for the entry line where there is a wrong character displayed.

In example, the line from XdrBuilder shows:

90200 VoIP SIP CDR 60 7200 YES VoIP SIP CDR reconstitution 600 0 0 NO SIP_IMS_v!▒BuildingVoSIPCDRreconstitution YES

Remove this line.
Apply the Changes.

At this point, there should be no more error in this operation.

Attachments

This solution has no attachment