"Installstatus" table entries deleted after purge revision

Product: Multi-Domain Security Management, Security Management
Version: R80.30 (EOS), R80.40 (EOS), R81 (EOS), R81.10 (EOS), R81.20
Last Modified: 2024-07-01

Symptoms

• After purge revision we see in SmartConsole, when clicking Install Policy and selecting a policy, this message shows: " Changes data is not available".

• When opening an SSH connection to the Security Management Server and running these 2 commands, an empty table is shown:

  ...[Expert@hostname:0]# psql_client cpm postgres

  cpm=# select * from installstatus where target='(object id of failing GW)' order by installdate desc;

Solution

This problem was fixed. The fix is included in:

• Jumbo Hotfix Accumulator for R81.20 starting from Take 70
• Jumbo Hotfix Accumulator for R81.10 starting from Take 152
• Jumbo Hotfix Accumulator for R81 starting from Take 99

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.