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

# sk166059 - Logging into SmartConsole fails and administrators are disconnected

| Property | Value |
|----------|-------|
| Solution ID | sk166059 |
| Date Created | 2020-03-30 |
| Last Modified | 2022-08-26 |
| Technical Level | General |
| Products | Multi-Domain Security Management Server |
| Versions | R82.10, R81.20, R82, R82.20 |

## Symptoms

- * Logging into SmartConsole fails.
* Administrators currently logged in are disconnected.
* High CPU of CPM_SOLR process.
* Debug from [sk160272](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk160272) shows the query with the longest duration is GetSessionAggregatorsInternal or GATEWAY_AGGREGATOR_NO_HOSTS.

## Solution

This problem was fixed. The fix is included in:

* [**Check Point R80.40**](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk160736)

Check Point recommends to always upgrade to the most recent version.  

For **other [supported](http://www.checkpoint.com/support-services/support-life-cycle-policy/index.html) versions,** Check Point can supply a **Hotfix** . [Contact Check Point Support](https://www.checkpoint.com/support-services/contact-support/) to get a Hotfix for this issue.  
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 file](http://supportcontent.checkpoint.com/solutions?id=sk92739) from the Security Management Server and the build number of the SmartConsole involved in the case.  

The GetSessionAggregators and GATEWAY_AGGREGATOR_NO_HOSTS queries were improved.  

The following workaround is available to enable the query liveness optimizer. PMTR-35381 adds this optimizer flag and is available since:  
R80.10 Jumbo Take 245  
R80.20 Jumbo Take 103  
R80.30 Jumbo Take 50  

* On-the-fly:  
  *\[Expert@HostName\]# $MDS_FWDIR/scripts/reload_env_vars.sh -e "NGM_QUERY_LIVENESS_OPTIMIZER=1"*   

* Permanently:  
  *\[Expert@HostName\]# $MDS_FWDIR/scripts/override_server_setting.sh -e NGM_QUERY_LIVENESS_OPTIMIZER 1*

<br />

To disable the query liveness optimizer:  

* On-the-fly:  
  *\[Expert@HostName\]# $MDS_FWDIR/scripts/reload_env_vars.sh -u "NGM_QUERY_LIVENESS_OPTIMIZER"*   

* Permanently:
  * Back up the current file $MDS_FWDIR/conf/cpmEnvVars.conf:  

    *\[Expert@HostName\]# cp -v $MDS_FWDIR/conf/cpmEnvVars.conf{,_BKP}*   

  * Edit the current file $MDS_FWDIR/conf/cpmEnvVars.conf:  

    *\[Expert@HostName\]# vi $MDS_FWDIR/conf/cpmEnvVars.conf*   

  * Remove this line:  

    *NGM_QUERY_LIVENESS_OPTIMIZER=1;export NGM_QUERY_LIVENESS_OPTIMIZER*   

  * Save the changes in the file and exit Vi editor.

---

# 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