# "No items found" or "Error retrieving results" errors when assigning policy targets in a Threat Prevention Policy, with empty "Install On" column

**Product** Multi-Domain Security Management, Security Management, SmartConsole  
**Version** R81.10 (EOS), R81.20  
**Last Modified** 2024-11-05

## Symptoms

- "No items found" or "Error retrieving results" errors when assigning policy targets in a Threat Prevention Policy, with empty "Install On" column.
- _$FWDIR/log/cpm.elg_ shows these logs:

```
[date, time] ERROR dleserver.internal.EclipseLinkExceptionHandler [qtp-884594813-2117]: Next Exception : ERROR: syntax error at end of input

[date, time] ERROR FtsQueryTools.providers.OverviewSearchProvider [qtp-884594813-2117]: Failed to getFacetForMultiSelection inside GlobalDomainAssignmentAggSearchProvider org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20140809-296a69f): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: syntax error at end of input
Error Code: 0
```

## Cause

Multi-selection of various views in SmartConsole led to a problem in the "Add targets" window query creation.

## Solution

This problem was fixed. The fix is included in:

- [Check Point Quantum R82](https://support.checkpoint.com/results/sk/sk181127)  
- [Jumbo Hotfix Accumulator for R81.20](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.20/Default.htm) starting from Take 26  
- [Jumbo Hotfix Accumulator for R81.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.10/Default.htm) starting from Take 106

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).

#### NOTE

This solution has been verified for the specific scenario, described by the combination of Product, Version and Symptoms. It may not work in other scenarios.

## Article Properties

**Access Level** General  
**Status** Approved by TAC  
**Date Created** 2023-05-10  
**Last Modified** 2024-11-05