Rule groups are removed if installer checks fail and generate Rule Group Sanity Check errors

Technical Articles ID: KB90596
Last Modified: 2022-12-15 11:17:14 Etc/GMT

Environment

Application and Change Control (ACC) 8.x

Problem

Rule groups are removed when SHA-1 is missing from checksum rules. When SHA-1 is missing from the checksum rules, the Rule Group Sanity Check generates errors.

Cause

The issue is with Solidcore Rules, Installers. When a new installer is added, you can define both SHA-1 and SHA-256, only SHA-1, or only SHA-256. Currently, SHA-1 is always required because it has a unique constraint on SQL.

The procedure that inserts a value into the database checks if SHA-1 exists. If it exists, the other values are updated using the same SHA-1, because it's unique. If SHA-1 does not exist, all values are inserted. So, if a new installer is created without SHA-1, it's inserted with an empty value under SHA-1 the first time. The second time, it's not inserted. Instead, the previous value with no SHA-1 is updated, the task fails, and all rule groups are deleted.

NOTE: Run Rule Group Sanity Check only if all installers have SHA-1. This task doesn't have to be run after every upgrade; it's optional to fix the inconsistencies in the rule group.

Solution

The ACC 8.2.1.121 Hotfix 1 Extension corrects this issue. Technical Support recommends that you upgrade the extension to this version. See the Release Notes for more information.

For product documents, go to the Product Documentation portal.

Workaround

Run the following query against the database and determine whether any lines are returned:

SELECT * FROM SCOR_APPLICATIONS
WHERE CHECKSUM IS NULL OR CHECKSUM LIKE ''

When the query has been run against the database and returns no lines, remove and reinstall the Solidcore extension or upgrade it. If you can't upgrade or reinstall the extension, contact Technical Support.

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

Rule groups are removed if installer checks fail and generate Rule Group Sanity Check errors

Environment

Problem

Cause

Solution

Workaround

Affected Products

Languages:

Title

Title

Knowledge Center

Rule groups are removed if installer checks fail and generate Rule Group Sanity Check errors

Environment

Problem

Cause

Solution

Workaround

Affected Products

Languages:

Choose your region

Title

Title