Compliance reports show a null value. (NETIQKB38442)

  • 7738442
  • 02-Feb-2007
  • 14-Nov-2011

Environment

VigilEnt Policy Center 5.x

Situation

Compliance reports show a null value.

Resolution

Warning:  Before performing any work on your VigilEnt Policy Center database, please ensure you have made a complete backup.

To address this issue:

  1. Launch Program Files | Microsoft SQL Server | Query Analyzer.
  2. Copy the script below and paste it into the Query Analyzer window:

    delete from vpc_user.PrivilegeEntryPermission
    where PrivilegeEntryID in (select PrivilegeEntryId from vpc_user.PrivilegeEntry where ConsumerId is null)

  3. Select from the drop-down box the VPC database (Default database name is PentasafeVPC).
  4. Execute the query be selecting green arrow button.
  5. Repeat Step 2 and Step 4 for the following SQL queries (one at a time):

    delete from vpc_user.AccessControlList
    where PrivilegeID in (select PrivilegeId from vpc_user.PrivilegeEntry where ConsumerId is null)

    delete from vpc_user.PrivilegeEntry where ConsumerId is null



Additional Information

Formerly known as NETIQKB38442

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