Risks showing as inactive after upload

[jayant]

Hi,

I am trying to upload a SOD ruleset in EIC. There are some 'Active' risks and some 'Inactive' risks in the ruleset.

After uploading the ruleset, all the risks appears as 'Inactive'. Has anyone faced this before?

Version: 24.3

[rushikeshvartak]

Each risk show mandatory to have 2 functions , attached files having missing function mapping 

[jayant]

Hi,

We have added the functions in the risks but still we are facing same issue. There are 2 functions for 'SOD' Risk Type and 1 function for 'Critical Access' Risk Type. Logs are showing same error as before.

[rushikeshvartak]

Create new ruleset with 1 risk 2 function and validate

[jayant]

Hi,

I tried this today but still the risk is showing as 'Inactive' after the ruleset is uploaded.

[rushikeshvartak]

Share logs

[jayant]

Attached the logs and ruleset.

[rushikeshvartak]

"2024-09-05T14:39:09.044+00:00","ecm-worker","services.ImportDataRulesetService","quartzScheduler_Worker-13-rqc47","DEBUG","Exit rulesetUploadThroughJob: Ruleset - BW_Ruleset_Test1 already exists.There are errors while uploading Ruleset. Please check excel file for errors."

Create new ruleset fully

[jayant]

Hi,

I have already tried that. Created new ruleset and then uploaded but still facing same issue.

[rushikeshvartak]

Raise support ticket

[JohnLawson]

Create an enhanced query job with the below query (replace rulesetkey with the correct key):

select 0 as RISKS__STATUS, riskid as RISKS__PRIMARYKEY from risks where rulesetkey = 17 and status =1

[rushikeshvartak]

Its not long term solution why its making inactive root cause should found

[Raghu]

@jayant  instead of Active / inactive try to replace '1' and '0' check it

[jayant · Accepted solution]

Hi,

We were able to fix this issue.

Changes made -

'Risks' sheet was named as 'Risk' earlier. Updated entitlements in the 'Objects' sheet. Added the 'Mitigation controls' sheet which was missing earlier.

Thank you for supporting with this.