Audience: IT Support Staff

When used: Regenerating daily stats for a previous day when reports have failed.


Stats fail for the previous day:

daily Stats fail on table httpfPageStats


CAUTION: This process must be completed AFTER BUSINESS HOURS, preferably after midnight. The process takes 4 hours minimum and creates daily rollup reporting, XML data dump, and old style daily stats.

  1. SSH to the primary server as ‘vwpoint’
  2. cd /home/vwpoint/viewPoint/bin or type 'gnwbin'
  3. CAUTION: THIS STEP should be completed AFTER MIDNIGHT At the prompt type: dailyStat.sh

  4. This process takes 4 hours minimum to complete and generates daily rollup reporting, XML data dump, and old style daily stats as well as sends them out to customers.


Status fail for more than one day:

  1. SSH to the primary server as ‘vwpoint’
  2. cd /viewPoint/bin or type 'gnwbin'
  3. Verify that stats are not available for the specific date:
    •  ${VIEWPOINT}/bin/multiStatHtml 9263 HE YYYYYYYYYYYY N  05-03-2004 05-03-2004 brian.garrison@globalnetwatch.com

    • If the script returns there are no stats for specified date complete the following steps.
  4. Run the following scripts. NOTE: This will take some time to run.

     type: dailyDnsIspStats MM-DD-YYYY  [enter]
    
     type: dailyDnsStats MM-DD-YYYY  [enter]
    
     type: dailyEmailStats MM-DD-YYYY  [enter]
    
     type: dailyFtpStats MM-DD-YYYY  [enter] 
    
     type: dailyHttpfStats MM-DD-YYYY  [enter] 
    
     type: dailyHttprStats MM-DD-YYYY  [enter]
    
     type: dailyHttpStats MM-DD-YYYY  [enter] 
    
     type: dailyHttptStats MM-DD-YYYY  [enter]
    
     type: dailyPingStats  MM-DD-YYYY  [enter] 
    
     type: bulkDailyOutage  MM-DD-YYYY  [enter]  
  5. vi previous_dailyRollup.sh and change the number of days to equal the day the reports to be created:
    • dataDate=date --date '2 days ago' +%m-%d-%Y to reflect the date of reports.

  6. type previous_dailyRollup.sh

    • This will take some time to run. Script sends reports once generated.


Re-runnung XML Reports for all Customers

Once the data is already loaded in the system and if the daily stats have failed for more than one day, then the XML files will need to be created and sent manually as well.

  1. cd /vwpoint/viewPoint/tmp
  2. vi b_dailyDataDump.sh and change the number of days to equal the day the reports to be created:
    • dataDate=`date --date '2 days ago' +%m-%d-%Y`

Generating Daily Stats (last edited 2009-10-16 17:57:12 by Eric)