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:
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
