Reading the statistics report to troubleshoot AskiaVista queries
Summary | This article describes how to read the AskiaVista statistics report |
Applies to | AskiaVista |
Written for | Data processor |
Keywords | statistics; report; vista; askiavista |
Introduction
Every time a calculation is run the results of the AVS server is stored in the Log files in your AskiaVista folder. In most cases, you should be able to view Statistics report from inside of AskiaVista under the Administration View. In certain configurations this might not be possible (if clustered or dedicated calculation engine servers) and you'll need to read the statistics file directly. Reading the statistics report can be useful in diagnosing queries that take excessively long amounts of time or tracking down why certain surveys fail and the error code that results.
Getting the files
First, download the statistics files from the AskiaVista folder. In most cases this will be . . .
C:\inetpub\wwwroot\AskiaVista\Logs
The files are kept in the StatsYYYYMMDD.txt format. A new one is created daily so you'll only want the ones starting from when the errors occurred.
If the server doesn't have the AskiaVista web application installed the files will be kept in the folder . . .
C:\Askia\AskiaCtrl\Logs
Reading the report
Open the Statistics file in a text editor and you should see the results in a tabulated format.
What you can learn from the report
- If you are getting an return code other than 0 (success), check the associated documentation to find out what is happening with this query.
For example, getting -102 means that AVS is taking too long to calculate results. - The fourth column displays the amount of time it takes to return results. If it is over 15000ms then you'll need to increase the Calculations response timeout in the Servers Management panel.