Duplicate and Missing Entries in the SMF_STATISTICS Table (Doc ID 1272973.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Communications Network Charging and Control - Version: 3.1.0 and later   [Release: 3.1.0 and later ]
Information in this document applies to any platform.

Symptoms

In versions of the NCC Service Management System (SMS) software, older then SMS v3.1.2.26, some statistics entries can, at times, be either; missing or duplicated.

The SMF.SMF_STATISTICS table on the SMS server stores the statistics entries.

An example is provided below of what a duplicate SMF_STATISTICS entry might look like:

SQL> SELECT *
FROM smf_statistics
WHERE id IN (335245441,335246585,335246558,335245389)
ORDER BY application_id, statistic_id;

        ID APPLICATION_ID       STATISTIC_ID                   NODE_NAME  DETAIL TIMESTAMP           VALUE      PERIOD
---------- -------------------- ------------------------------ ---------- ------ ------------------- ---------- ----------
 335246558 MOC_Postpaid         NUM_CALL_TRIGGERED             SLC01             10/11/2010 13:30:00         55        300
 335245389 MOC_Postpaid         NUM_CALL_TRIGGERED             SLC01             10/11/2010 13:30:00         55        300

 335246585 MOC_Prepaid          NUM_CALL_TRIGGERED             SLC01             10/11/2010 13:30:00         25        300
 335245441 MOC_Prepaid          NUM_CALL_TRIGGERED             SLC01             10/11/2010 13:30:00         25        300

A missing statistic entry would have a TIMESTAMP greater than a PERIOD (seconds) skipped 1 or more times, for grouped APPLICATION_ID, STATISTIC_ID, and NODE_NAME entries.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms