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

# sk133052 - "Query failed" error or no information in SmartEvent for several timezones

| Property | Value |
|----------|-------|
| Solution ID | sk133052 |
| Date Created | 2018-07-30 |
| Last Modified | 2018-07-31 |
| Technical Level | Advanced |
| Products | Security Management Server |
| Versions | R82.10, R82, R81.20, R82.20 |
| OS | Gaia |

## Symptoms

- * Tabs on SmartEvent show error: "Query failed" or no information.

* Output of "cpstat cpsemd" shows:   

  ```
  [Expert@firewall:0]# cpstat cpsemd
  Process is alive:              1
  New events handled:            0
  Updates handled:               0
  Last processed event time:
  Current database size:         0
  Database capacity:             0
  Events in database:            0
  Available database disk space: 0
  Database is full:              0
  Total database disk space:     0
  ```

  <br />

* Unusual CPU load for processes log_indexer, java, cpsemd, cpsead.

* In R80.10, the file: $RTDIR/log/RFL.log contains the error:  

  `The datetime zone id <Timezone> is not recognised`  


  In R80.20 the file: $RTDIR/log/RFL.log contains the error:  

  `RFL configuration is not initialized yet.`

* Output of command: 'show timezone' in clish shows one of these zones:

  ```
  America / Fort_Nelson
  Asia / Barnaul
  Asia / Chita
  Asia / Srednekolymsk
  Asia / Tomsk
  Asia / Yangon
  Europe / Astrakhan
  Europe / Kirov
  Europe / Ulyanovsk
  Pacific / Bougainville
  ```

  <br />

## Cause

These zones do not exist in the database of the Security Management server.

## 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
