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

# sk112138 - Report generation in SmartEvent stuck in "query execution in progress" status 

| Property | Value |
|----------|-------|
| Solution ID | sk112138 |
| Date Created | 2016-06-27 |
| Last Modified | 2020-10-13 |
| Technical Level | Advanced |
| Products | Security Management Server |
| Versions | R82.10, R82, R81.20, R82.20 |
| OS | Gaia |

## Symptoms

- When creating a custom report in SmartEvent NGSE, generating stuck in "query execution in progress" for several days.

## Cause

Tried to generate report for more than 250 logs. This caused high CPU consumption and caused the report to fail.

The custom report includes a "Statistical Table" (that can contain a maximum of only 250 logs).

In order to be able to generate the desired report, "Statistical Table" should be changed to "Log Table".

## Solution

This solution requires authentication. Please log in to view the full solution.

---

# 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