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

# sk182715 - SmartConsole Administrators page shows "Error retrieving results" when login with local admin

| Property | Value |
|----------|-------|
| Solution ID | sk182715 |
| Date Created | 2024-10-03 |
| Last Modified | 2024-10-07 |
| Technical Level | General |
| Products | Security Management Server |
| Versions | R81.20, R81.10 (EOS) |
| OS | Gaia |

## Symptoms

- * When you attempt to log into the SmartConsole with a local administrator account, you get this error message, "Error retrieving results."
* To locate similar log entries, review the `cpm.elg` file by executing the following command:

  `$MDS_FWDIR/scripts/cpm_debug.sh -c OverviewSearchProvider -s DEBUG`
  > `
  > DEBUG FtsQueryTools.providers.OverviewSearchProvider [qtp314214632-566298]: query after removing varfields: 
  > 'SELECT tsfacet FROM dleobjectderef_alt WHERE ( ) AND ( OR ) AND featuresPreset IN (''6f93fcbe-ab84-35b4-8504-267d4ed6e094'') AND 
  > ((tsdata is not null and tsdata <> '''') OR varfields is not null OR (tsfacet is not null and tsfacet <> '''') ) 
  > AND featuresPreset is not null AND ( domainId=''a0bbbc99-adef-4ef8-bb6d-defdefdefdef'' OR domainId=''a0eebc99-afed-4ef8-bb6d-fedfedfedfed'') '
  > `  
  > `
  > DEBUG FtsQueryTools.providers.OverviewSearchProvider [qtp314214632-566298]: query after removing parentheses with 'OR'/'AND' only: 
  > 'SELECT tsfacet FROM dleobjectderef_alt WHERE ( ) AND AND featuresPreset IN (''6f93fcbe-ab84-35b4-8504-267d4ed6e094'') AND 
  > ((tsdata is not null and tsdata <> '''') OR varfields is not null OR (tsfacet is not null and tsfacet <> '''') ) 
  > AND featuresPreset is not null AND ( domainId=''a0bbbc99-adef-4ef8-bb6d-defdefdefdef'' OR domainId=''a0eebc99-afed-4ef8-bb6d-fedfedfedfed'') '
  > `
* The current user list does not match [sk133956](https://support.checkpoint.com/results/sk/sk133956), as there are no names beginning with "CN."

## Solution

This problem was fixed. The fix is included starting from:  

[Jumbo Hotfix Accumulator for R81.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.10/Default.htm) starting from Take 156  
[Jumbo Hotfix Accumulator for R81.20](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.20/Default.htm) starting from Take 84  

If you choose not to upgrade, [contact Check Point Support](https://www.checkpoint.com/support-services/.contact-support/) to get a Hotfix for your version.  

A Support Engineer will make sure the Hotfix is compatible with your environment before providing it.  
For faster resolution and verification, collect these files:  

[CPinfo](https://support.checkpoint.com/results/sk/sk92739) file from the Management Server involved in the case.  

Hotfix installation instructions:  
Refer to [sk168597 - How to install a Hotfix.](https://support.checkpoint.com/results/sk/sk168597)

---

# 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