Tech Tips: Drill down from CAPC to NFA causes a Time Shift in NFA View

Document created by Christopher_Walsh Employee on Jun 25, 2014Last modified by Christopher_Walsh Employee on Dec 17, 2016
Version 2Show Document
  • View in full screen mode
Details:
When in CAPC and drilling down on NFA data, a time shift may occur in the NFA view if you are not using a GMT time zone.
For example if you are looking at a view in CAPC that is for 7:30 AM EST to 8:30 AM EST, then drill down on one of the Protocols from a 'Stacked Protocol Trend' chart into NFA, the time frame shown in the NFA view would be shifted to 2:30 AM EST to 3:30 AM EST.
Solution
To work around this in CAPC releases 2.3.3 and earlier follow the steps below on the CAPC Server:

1)SSH to the CAPC server

 

2)Backup the 'netqosportal' database on CAPC with the command below

 

mysqldump netqosportal > /tmp/netqosportal.sql

 

If desired you can change the backup directory to something other than /tmp

 

3)Navigate to:

$INSTALLROOT$/PerformanceCenter/SQL/plugins

 

For example for the default directory:

cd /opt/CA/PerformanceCenter/SQL/plugins

 

4)Run the following four commands from this directory one by one:

 

cp reporter/report_models.xml reporter/report_models.orig

 

         sed -i 's/expandedUtcTimeStart/utcTimeStart:Date(yyyy-MM-dd_HHmm|utc)/g' reporter/report_models.xml

 

sed -i 's/expandedUtcTimeEnd/utcTimeEnd:Date(yyyy-MM-dd_HHmm|utc)/g' reporter/report_models.xml

 

../../Tools/bin/npcshell.sh dbmigrate -package com.ca.im.plugin.nfa -path reporter

 

 

5)When the last command completes you will get a response like the one

below:

 

INFO: ---------- Completed loading package: com.ca.im.plugin.nfa ----------

 

DbMigrate end (w/ exit status: 0)

 

 

6)If you see that it was succesful, reload you CAPC view and test the drill down to NFA again.

 

This document was generated from the following discussion: Tech Tips: Drill down from CAPC to NFA causes a Time Shift in NFA View

Attachments

    Outcomes