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

# sk161232 - SmartConsole freezes when accessing MTA settings in Security gateway properties

| Property | Value |
|----------|-------|
| Solution ID | sk161232 |
| Date Created | 2019-09-09 |
| Last Modified | 2021-05-12 |
| Technical Level | General |

## Symptoms

- When user clicks on Mail Transfer Agent (MTA) options in the Security gateway settings or on 'Next hop' column inside MTA settings, SmartConsole shows "Not Responding" and freezes.

## Cause

There is a query inside MTA, responsible for retrieving all of the relevant MTA objects. A large amount of relevant objects on the server might cause this query to take a long time and freeze SmartConsole.

## Solution

This problem was fixed. The fix is included in:

* [Jumbo Hotfix Accumulator for R80.40](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk165456) starting from Take 91
* [R80.40 SmartConsole](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk165473) starting from Build 415  

* [Jumbo Hotfix Accumulator for R80.30](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk153152) starting from Take 76
* [R80.30 SmartConsole](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk153153) starting from Build 20

**Code was changed:** A new paged query was added to overcome the problem of retrieving too many objects at a single retrieval.

To enable the fix and turn on the modified query, an environment variable '**setMTAPagedQuery**' should be configured on the Management machine. Setting this environment variable to any value, will cause the new query to take effect.  

**To set an environment variable:**   

1. In Windows Explorer, go to the **Control Panel** \> **System and Security** \> **System** \> **Advanced system settings** \> **Environment Variables** .   

2. Here you can see the existing environment variables.  

3. Go to **System variables** and cilck **New** .  

4. In the **Variable name** field, enter *setMTAPagedQuery* and in the **Variable value** enter any value.  

You can also check if an environment variable is set by opening the command line and typing "`echo %setMTAPagedQuery%`". if it exists, it will return the value that was set for that variable.

<br />

If you choose not to upgrade, 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 files](http://supportcontent.checkpoint.com/solutions?id=sk92739) from the Security Management Server and Security Gateways involved in the case.

**Hotfix installation instructions:**   
Refer to [sk168597 - How to install a Hotfix](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk168597).

<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