> Source: [sk167892](https://support.checkpoint.com/results/sk/sk167892)

# sk167892 - "Query failed" when statistical report includes "Total Bytes" from accounting log

| Property | Value |
|----------|-------|
| Solution ID | sk167892 |
| Date Created | 2020-07-09 |
| Last Modified | 2020-07-12 |
| Technical Level | General |
| OS | Gaia |

## Symptoms

- "`Query failed`" when statistical report includes "Total Bytes" from accounting log.

![](https://sc1.checkpoint.com/sc//SolutionsStatics/sk167892/Untitled1202007121417591.png)

![](https://sc1.checkpoint.com/sc//SolutionsStatics/sk167892/Untitled2202007121418192.png)

## Cause

Statistical reports do not index the "Total Bytes" field.

<br />

## Solution

Statistical reports use "Traffic Total Bytes," not "Total Bytes." To see "Total Bytes" from accounting logs in statistical reports, make sure rules are configured as per [sk150452](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk150452&partition=Advanced&product=SmartEvent "sk150452").   

To avoid this issue in the future, [Contact Check Point Support](https://www.checkpoint.com/support-services/contact-support/) to get a Hotfix for this issue. The Hotfix removes the field from the list of options in the report's "Table Settings." A Support Engineer will make sure the Hotfix is compatible with your environment before providing the Hotfix.   
For faster resolution and verification please collect [CPinfo](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk92739) files from the Security Management and Security Gateways involved in the case.

<br />

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content