Unable to add new policy: null (when you try to save a new or cloned IPS policy in the Trellix IPS Manager)

Technical Articles ID: KB89795
Last Modified: 2023-04-25 05:54:13 Etc/GMT

Environment

Trellix Intrusion Prevention System (Trellix IPS)

IMPORTANT: Trellix IPS Manager has transitioned from MySQL to MariaDB.

The Database used in Manager 9.1 changes to MariaDB with release 9.1.7.77.
This article features different steps if using Manager 9.1.7.77 and later.

Problem

When you try to save a new or cloned IPS policy, you see the following error:

Unable to add new policy: null.

You can confirm this issue by viewing the ems.log file in the Manager installation directory and locating the following error; this error is logged at the time you try to save the IPS policy:

Missing or invalid sequence table iv_filter_id_sequence

Solution

IMPORTANT:
Before you make changes to the database, ensure that you have taken an all table backup. For guidance on the backup, see the "Using the database admin tool" section of the NSP Manager Administration Guide for your release. When you have completed the backup, then perform the following solution.

Connect to the Manager using either local access (keyboard and mouse) or by a remote desktop session.
Open a command-line session.
Change the directory to the <database>\bin directory:
- For Manager 9.1.7.75 and earlier:
  Type cd <Manager Installation Directory>\MySQL\bin\ and press Enter.
- For Manager 9.1.7.77 and later, including 10.x and 11.x:
  Type cd <Manager Installation Directory>\MariaDB\bin and press Enter.
Log on to the MySQL database server on the Manager:
Type mysql.exe -uroot –p and press Enter.
Enter your password.
Type use lf and press Enter.
You see the reply :Database changed.
Type select * from iv_filter_id_sequence; and press Enter.
The output should be empty. If not, contact Technical Support and don't continue to the next step.
Type INSERT INTO iv_filter_id_sequence(val) VALUES (300); and press Enter.
Type select * from iv_filter_id_sequence; and press Enter to confirm that the value is now present.
Save the new or updated policy.

Related Information

To contact Technical Support, go to the Create a Service Request page and log on to the ServicePortal.

If you are a registered user, type your User ID and Password, and then click Log In.
If you are not a registered user, click Register and complete the fields to have your password and instructions emailed to you.

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

Unable to add new policy: null (when you try to save a new or cloned IPS policy in the Trellix IPS Manager)

Environment

Problem

Solution

Related Information

Affected Products

Languages:

Title

Title

Knowledge Center

Unable to add new policy: null (when you try to save a new or cloned IPS policy in the Trellix IPS Manager)

Environment

Problem

Solution

Related Information

Affected Products

Languages:

Choose your region

Title

Title