on 06-26-2009 3:55 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What kind of error do you get - is it something about "wrong system"...?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.