Database Grooming is not available when GPG is installed on SQL 2005. (NETIQKB70673)

  • 7770673
  • 24-Sep-2007
  • 15-Mar-2013

Environment

GPG 2.0

GPG 2.0 SP1

GPG 2.0 SP2


Situation

Database Grooming is not available when GPG is installed on SQL 2005.
Unable to retrieve the grooming job information.
Unable to get the grooming job info. Ensure that the GPG Grooming Job does indeed have a schedule for it.
Grooming Configuration page displays unrealistic settings and cannot be changed.
When the GPG 2.0 database is installed on SQL 2005, two of the stored procedures are not installed on the FA_GP_AUDITING database:
fa_aud_get_rule_hierarchy_for_collector
fa_aud_getGroomingJobInfo.

Resolution

Hotfix 70673 addresses the following issues that occur when you install Group Policy Guardian (GPG) version 2.0.2 with Microsoft SQL Server 2005.

  • The Control Service fails to distribute new configuration settings to GPG Collectors. GPG displays error ID 8889 with the description 'DB Error while building Configuration Data Changed Notification to GPG Collector' in the GPG event log.
  • When you attempt to configure the grooming settings in the Grooming Configuration window, GPG displays the error messages 'Unable to get the grooming job info.' and 'Unable to retrieve the grooming job information'.

The above issues occur because two stored procedures are not copied to the FA_GP_AUDITING database during installation.

Hotfix 70673 corrects these issues and ensures:

  • All required stored procedures of GPG are available in Microsoft SQL Server 2005. GPG does not display the error message 'DB Error while building Configuration Data Changed Notification to GPG Collector' in the GPG event log.
  • You can configure the grooming settings in the Grooming Configuration window.

To install this hotfix, perform the following steps:

  1. Close all GPG user interfaces.
  2. Run the GPG20002_Hotfix70673.exe file on each computer where you installed the GPG database.

This hotfix creates the following stored procedures:

  • fa_aud_get_rule_hierarchy_for_collector
  • fa_aud_getGroomingJobInfo

After installing this hotfix, if you have a distributed GPG installation, you may encounter the error 'The partner transaction manager has disabled its support for remote/network transactions.' from the GPG reporting computer. This error is due to a communications error between Internet Explorer and Microsoft SQL Server 2005.

To resolve this issue, see Microsoft Knowledge Base article, available at http://support.microsoft.com/kb/899191, 'New functionality in the Distributed Transaction Coordinator service in Windows Server 2003 Service Pack 1 and in Windows XP Service Pack 2.'

Cause

When the GPG 2.0 database is installed on SQL 2005, two of the stored procedures are not installed on the FA_GP_AUDITING database:
fa_aud_get_rule_hierarchy_for_collector
fa_aud_getGroomingJobInfo.

The reason is that the syntaxes and system table names used in these stored procedures are not compatible with SQL 2005.

Additional Information

Formerly known as NETIQKB70673

Some customers have reported problems installing this hotfix where SQL 2005 is not recognized as being installed.  To resolve this issue:

  1. Create the following registry key:  HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{EB76B218-8FC5-41DF-9F1F-7FF3E0448383}?
  2. At this same location create a new String Value of "DisplayName"
  3. Reboot the machine.
  4. Apply the Hotfix.