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

  • 7752609
  • 02-Feb-2007
  • 18-Sep-2007

Resolution

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:

  4. 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)

  5. Start the Module Importer.

  6. Select the module you want to import.

  7. Click Install.



Additional Information

Formerly known as NETIQKB52609

Feedback service temporarily unavailable. For content questions or problems, please contact Support.