Problem in RAR 5.3 SP08 with the ruleset

[Former Member]

Hello Gurus,

We have two GRC Servers , one PROD and one Testing.

We just upgraded the test system with SP08 and i cant delete the ruleset anymore , like i could.

Before SP08 i could upload one empty ruleset (test system) and my result was the deletion of the ruleset. After that step i uploaded the actual active ruleset from the PROD so that the two systems have the same ruleset.

Now that i cant perform this , i cant test the Test system efficiently and compare the results with the PROD.

Is there another way to delete the ruleset and upload the one from the PROD ?

best regards,

david

[sam_szafranski3 · Accepted solution]

I don't see why your upload file contains CDPOS entries.

this should be ok for wipe out

IDS

M VIRSA_CC_BUSPRC BZPRCID

M VIRSA_CC_BUSPRCT BZPRCID LANG DESCN

M VIRSA_CC_FUNC FUNCTID SCOPE

M VIRSA_CC_FUNCT FUNCTID LANG DESCN

M VIRSA_CC_FUNCBP FUNCTID BZPRCID

M VIRSA_CC_FUNCACT FUNCTID ACTIONS VSYSKEY STATUS

M VIRSA_CC_FUNCPRM FUNCTID ACTIONS VSYSKEY AUTHTREE FROMVAL TOVAL SEARCHTYPE STATUS

M VIRSA_CC_RISK RISKID RISKLEVEL STATUS BZPRCID UPDDATE UPDTIME UPDUSER ACTGEN PRMGEN RISKTYPE

M VIRSA_CC_RISKT RISKID LANG DESCN

M VIRSA_CC_RISKOWN RISKID OWNUSER

M VIRSA_CC_DETDESC OBJECT_TYPE OBJECT_ID LANG DETAIL_DESCN

M VIRSA_CC_RISKFUNC RISKID FUNCTID

M VIRSA_CC_RISKOWN RISKID OWNUSER

M VIRSA_CC_ACTRULE ACTRISK ACTIONS VSYSKEY FUNCTID RISKID STATUS

M VIRSA_CC_AUTHMAP AUTHKEY SEQUENC VSYSKEY AUTHTREE

M VIRSA_CC_RTMAP ROOTELEM AUTHKEY

M VIRSA_CC_GSEQ SEQTYPE SEQVALUE

M VIRSA_CC_ORGRULE ORGRULEID PRMRISK ORGLEVEL FROMVAL TOVAL SEARCHTYPE STATUS

M VIRSA_CC_ORGRULET ORGRULEID LANG DESCN

M VIRSA_CC_CRROLE VSYSKEY ROLES RULESETID RISKLEVEL STATUS

M VIRSA_CC_CRROLET VSYSKEY ROLES RULESETID LANG DESCN

M VIRSA_CC_CRPROF VSYSKEY PROFILE RULESETID RISKLEVEL STATUS

M VIRSA_CC_CRPROFT VSYSKEY PROFILE RULESETID LANG DESCN

M VIRSA_CC_CRACT VSYSKEY TCODE RISKID RISKLEVEL STATUS

M VIRSA_CC_CRACTT VSYSKEY TCODE RISKID LANG DESCN

M VIRSA_CC_RULESET RULESETID

M VIRSA_CC_RULESETT RULESETID LANG DESCN

M VIRSA_CC_RISKRS RISKID RULESETID

M VIRSA_CC_CRPRM VSYSKEY TCODE RISKID AUTHKEY AUTHSEQ FROMVAL TOVAL SEARCHTYPE STATUS

[koehntopp]

What kind of error do you get - is it something about "wrong system"...?

[Former Member]

Hi,

You can not delete ruleset if it is assigned to risk.

It will give you error message like Rule set cannot be deleted because it is assigned to a Risk

So, you have to unassign the ruleset from risk then try to delete.

regards,

Sudip.

[Former Member]

Hello Frank ,

the error i get is this :

Error in table dataVIRSA_CC_CDPOS

SQL:=>Insert into VIRSA_CC_CDPOS(OBJECTCLASS,OBJECTID,CHANGENO,TABNAME,TABKEY,FNAME,IND,OLDVALUE,NEWVALUE) Values(?,?,?,?,?,?,?,?,?)

Record::Line Number :232099 : D VIRSA_CC_CDPOS FUNC MM10 534 VIRSA_CC_FUNCACT MM10MSC2NSCH STATUS U 0

But i realized the ruleset can be deleted and new uploaded allthough there are some error messages.

I am still analyzing the issue .

Regards,

david

[Former Member]

If you open up a note with SAP requesting the script to delete the ruleset that should fix the issue.

[Former Member]

David,

SAP does not provide the SQL script to delete any of the data. They will provide you with information about all the tables and you can create a deletion script and run it against the database.

Regards,

Alpesh

[Former Member]

SAP will provide a deletion script to remove connectors, rulesets and mitigating controls. Hope this helps...

[Former Member]

Daniel,

SAP used to provide. They do not provide anymore. I have already asked for it and we were told that SAP has changed it's policy.

--Alpesh