Resolution
Security Manager 5.5
symptom
Error when importing a Processing Rule Group (PRG): Error information has 2 rows and 6 columns.
symptom
A module import error occurs during an upgrade or a new installation.
cause
Some processing rules lost their relationship with the processing rule group to which they belonged. These rules are now 'orphaned.'
fix
To solve the problem, remove the orphaned rules and reimport the module.
To remove the orphaned rules and reimport the module:
Log on to the OnePoint database server as a member of the Administrators group on the SQL Server.
Start SQL Query Analyzer.
Run the following script:
Start the Module Importer.
Select the module you want to import.
Click Install.
Use OnePoint
delete from processrulecomment
where idprocessrule in (
select idprocessrule from processrule where isrulegroup=0 and
not exists
(select * from processrulemembership
where processrule.idprocessrule=processrulemembership.idprocessrulemember))
delete from processruletonotifygroup
where idprocessrule in (
select idprocessrule from processrule where isrulegroup=0 and
not exists
(select * from processrulemembership
where processrule.idprocessrule=processrulemembership.idprocessrulemember))
delete from processruletoscript
where idprocessrule in (
select idprocessrule from processrule where isrulegroup=0 and
not exists
(select * from processrulemembership
where processrule.idprocessrule=processrulemembership.idprocessrulemember))
delete from processrule where isrulegroup=0 and
not exists
(select * from processrulemembership
where processrule.idprocessrule=processrulemembership.idprocessrulemember)