Showing results for 
Search instead for 
Did you mean: 

Cisco Community Designated VIP Class of 2020

Cisco Employee

When you have a problem with Reports showing different time, missing offered services, links to focus, etc...

Hi all,

When you generate your report and you see that time is not correct or missing offered services or links to focus, etc... usually you should go and check:

How it works:

If you go to template folder in your SCA BB installation path:

C:\Program Files\Cisco SCA\SCA BB Console 3.7.5\plugins\\templates

and check specific report (Global Monitoring>Global BW per Service):

scroll down until you find something like




#timeresolution($p.avgdata $tz_offset) as Timeslot,

#bandwidth($p.avgdata $direction) as Bandwidth,

GLBL_USG_CNT_ID as Service






#if ("$!{}" != '')

and #linktofocus($


#if ("$!{}" != '')

and GLBL_USG_CNT_ID in #glb_counter_to_focus($



#timeresolutiontogroup($p.avgdata $tz_offset) , GLBL_USG_CNT_ID


Timeslot asc


In the line #timeresolution($p.avgdata $tz_offset) as Timeslot

you can see that from SCA BB, SQL query will add or subtract tz_offset. So it will not happen in CM when RDRs are received from SCE and inserted into the DB, but SCA BB Reporter will do it itself during the generation of report.

Now check that in CM offset is fine: home/cm/bin/ --rdr --status

we need to update SCA BB Reporter with this value.

To do this we need to go to SCA BB Windows/Preferences/Reporter/Templates and select right SCE.


Then go to Reporter and refresh it so SCA BB Reporter can get current value from CM/DB.


Now it should be fine.

Sometimes when you want to select right template above you will see that your SCE is not on the list or so.

All information about specific services, packages, etc.. are stored in the CM/DB in the table INI_VALUES.

When you apply the configuration in SCA BB you will notice at the end in console window that SCA BB is trying to update CM.

Result can be successful:


Which means that in the CM/DB we have all accurate info about our SCE and pqb we applied to it via SCA BB.

Or if we have something like this:


For some reason SCA BB couldn't update CM/DB with current configuration we applied, so we might not see our SCE in the list of templates as explained above, or if we applied before successfully config and updates CM/DB, but now it is failing with a new pqb, we might not see all the services offered when we want to generate repot, because in the CM/DB we do not have that current/new data.

Once we fix the issue with connection between SCA BB and CM, we should apply the configuration again and make sure our CM/DB is updated. Then selecting right SCE in Templates, and doing refresh as explained above should fix all missing services, time offset, link to focus etc...

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