000037306 - Unable to modify statistics reports that include a multi level values list in RSA Archer

Document created by RSA Customer Support Employee on Apr 23, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037306
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.4.1, 6.5
 
IssueWhen modifying a statics report with a multi-level values Archer just spins. If you try to create a new report in statistics mode and you try to add the values list you will see that there is no way to select the level.

In the screenshot below you can see what it should look like but when you are experiencing the issue you don't have the Depth Group By options.

User-added image
CauseThe issue is caused by the generation column in the tblIVSelectValue table not getting set correctly by the installer and is only present on some upgrade paths.
ResolutionThe issue can be corrected by the following steps:
  1. Take a database backup.
  2. Run the following script on the Archer Instance database:


BEGIN TRANSACTION;
;WITH SelectValueCTE (select_value_id, parent_select_value_id, generation)
AS (SELECT select_value_id,
           parent_select_value_id,
           0 AS generation
    FROM dbo.tblIVSelectValue
    WHERE parent_select_value_id IS NULL
    UNION ALL
    SELECT sv.select_value_id,
           sv.parent_select_value_id,
           cte.generation + 1
    FROM dbo.tblIVSelectValue sv
        INNER JOIN SelectValueCTE cte
            ON sv.parent_select_value_id = cte.select_value_id
    WHERE cte.generation < 100)
UPDATE sv
SET sv.generation = cte.generation
FROM dbo.tblIVSelectValue sv
    INNER JOIN SelectValueCTE cte
        ON sv.select_value_id = cte.select_value_id;

IF @@ERROR <> 0
    ROLLBACK TRANSACTION;
ELSE
    COMMIT TRANSACTION;

Attachments

    Outcomes