Error in importing PRG: Error information has 2 rows and 6 columns. (NETIQKB52609)

fact
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:

1. Log on to the OnePoint database server as a member of the Administrators group on the SQL Server.

2. Start SQL Query Analyzer.

3. Run the following script:

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)

4. Start the Module Importer.

5. Select the module you want to import.

6. Click Install.

Formerly known as NETIQKB52609