cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

829
Views
0
Helpful
1
Replies
Highlighted
Beginner

Missing service names in Reporter

Hi

  recently in reporter appears some weird table at the end of the "Multi Package Bandwidth per Service" report  (RPT_PUR).

   The symptom is, that some of the services are named correctly, some of them are denoted with numbers, like this:

Report_with_numbers.jpg

Names are OK, numbers are NOT OK.

Investigating the issue I found the following:

Named services are found in CM MySql/apricot/INI_VALUES  table with matching name and "VALUE" with VALUE_TYPE="1". This VALUE is found, and matching the name in PQB/classification on services (or within unzipped xml)

+---------------------+-----------+------------+-------------------+-------+

| TIME_STAMP          | SE_IP     | VALUE_TYPE | VALUE_KEY         | VALUE |

+---------------------+-----------+------------+-------------------+-------+

| 2013-10-16 12:30:07 | 172.x.y.z |          1 | WEB               |   400 |

| 2013-10-16 12:30:07 | 172.x.y.z |          1 | STREAMING         |   250 |

| 2013-10-16 12:30:07 | 172.x.y.z |          1 | INSTANT MESSENGER |   150 |

| 2013-10-16 12:30:07 | 172.x.y.z |          1 | GAMES             |   100 |

| 2013-10-16 12:30:07 | 172.x.y.z |          1 | FILE-TRANSFERING  |    50 |

+---------------------+-----------+------------+-------------------+-------+

in PQB:

<service name="WEB" index="400"/>

<service name="STREAMING" index="250"/>

<service name="INSTANT MESSENGER" index="150"/>

<service name="GAMES" index="100"/>

<service name="FILE-TRANSFERING" index="50"/>

Services only with numbers in the report: those numbers, treating them as "VALUE" field of the INI_VALUES table, does not hold any row with VALUE_TYPE="1", neither can be found such service number in PQB classification (or unzipped xml).

I.e. number "64"

mysql> select * from INI_VALUES where SE_IP like "172.x.y.z" AND VALUE like "64";

+---------------------+-----------+------------+------------+-------+

| TIME_STAMP          | SE_IP     | VALUE_TYPE | VALUE_KEY  | VALUE |

+---------------------+-----------+------------+------------+-------+

| 2013-10-16 12:30:07 | 172.x.y.z |         15 | 64 (covia) |    64 |

| 2013-10-16 12:30:07 | 172.x.y.z |         11 | LinkedIN   |    64 |

| 2013-10-16 12:30:07 | 172.x.y.z |          6 | SAT-EXPAK  |    64 |

| 2013-10-16 12:30:07 | 172.x.y.z |          3 | 64 (covia) |    64 |

+---------------------+-----------+------------+------------+-------+

How to determine what services SCE are trying to report on those numbers?

In other words, how to configure SCE to report only such services which are classified and named in PQB/Reporter/INI_VALUES?

I tried to upgrade latest PP36, reapply PQB (yes it successfully updates CM as well).

SCE8000 3.7.2

CM  3.7.5

this combination is compatible !!? (RPT_PUR, INI_TABLES does not changes betveen 3.7.2 -> 3.7.5 by this Changes in Scripts, Tables, and RDRs
)

thanks for your help.

Regards:

gyula

1 REPLY 1
Beginner

Missing service names in Reporter

Hi

  finally emptying the INI_VALUES table (not dropping!), and reapplying pqb rewrote the INI_VALUES, and now it's perfect.

jonagy

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here