Reading the statistics report to troubleshoot queries

Reading the statistics report to troubleshoot queries

Summary This article describes how to read the askiavista statistics report.
Applies to askiavista
Written for Data processor
Keywords statistics; report; vista; askiavista


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


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


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 4th 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.

Have more questions? Submit a request