IDIH Major Alarm 213 ImpStore - Unable To Store To Oracle DB

Asset ID:	1-71-2308977.1
Update Date:	2017-09-20
Keywords:

Solution Type Technical Instruction Sure

Solution 2308977.1 : IDIH Major Alarm 213 ImpStore - Unable To Store To Oracle DB

Applies to:

Oracle Communications Diameter Signaling Router (DSR) - Version DSR 7.1.2 and later
Tekelec

Goal

New traces cannot be analyzed with IDIH, No TDR(s) found message is displayed instead of a TDR list.

Also following alarm is displayed in the system Alarms list:

Major Alarm 213 ImpStore - Unable to store to Oracle DB

Solution

Customer ran alter_tablespace to increase tablespace on some tables but did not do a sync between iDIH and DSR after that. This resulted in iDIH entries becoming inconsistent.

Following actions should be taken to resolve the issue:
1. Perform resync between iDIH and DSR OAM

Login to iDIH app server as “admusr” user
Run following command:

cd /usr/TKLC/xIH/apps/trace-refdata-adapter
Run this command

ant clean.data
Run this command

ant app enable
(Sync MOs from SOAM)

2. Set up system to run IXP_NIGHTLY_JOB

The steps to enable IXP_NIGHTLY_JOB have been set internal here as it includes copying and running a script on system

Copy the below script to Mediation Server in /tmp directory and name the file as EnableJob.sql

SPOOL ../trc/EnableJob.trc
WHENEVER SQLERROR EXIT SQL.SQLCODE

SET VERIFY OFF

DEFINE JOB_NAME="&1"

BEGIN
DBMS_SCHEDULER.ENABLE ('&JOB_NAME');
END;
/

SPOOL OFF

EXIT
Login to mediation server as “tekelec” user
Run this command to connect to oracle db:
sqlplus /@IXP
After sql connect run this command from sql prompt:
@/tmp/EnableJob.sql
Pass first argument:
IXP_NIGHTLY_JOB
Run below mentioned sql command to re-verify the Enable flag.
SELECT JOB_NAME,FAILURE_COUNT,EN ABLED,NEXT_RUN_DATE,MAX_RUN_DURATION from USER_SCHEDULER_JOBS;
The output of command should show IXP NIGHTLY JOB as TRUE:

IXP_NIGHTLY_JOB 0 TRUE
Remove the EnableJob.sql file from /tmp

Attachments

This solution has no attachment