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)
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";