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

"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
Jumbo Hotfix Accumulator for R81.20 starting from Take 26
Jumbo Hotfix Accumulator for R81.10 starting from Take 106

If you choose not to upgrade, Check Point can supply a Hotfix. Contact Check Point 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 from the Security Management Server and Security Gateways involved in the case.

Hotfix installation instructions:

Refer to sk168597 - How to install a Hotfix.

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