[MS KBs] A hotfix is available that fixes two issues with management packs in System Center Operations Manager 2007

SYMPTOMS

Issue 1You try to create many groups in a single management pack or to import a...

Issue 1
You try to create many groups in a single management pack or to import a management pack that contains many groups. However, the operation fails and the following event is logged in the Operations Manager log:

Source: OpsMgr SDK Service
Event ID: 26319
Description:
An exception was thrown while processing UpdateManagementPack for session id uuid:[UUID];id=<number>.
Exception Message: The creator of this fault did not specify a Reason.
Full Exception:
System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.ManagementPackException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to : Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Incorrect syntax near 'MTV_AllDatabasesGroup_:'.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.
).

For example, this problem may occur when you use the OpsMgr SDK Service to create more than 397 groups in a single management pack. This example includes when you import a management pack and when you use the OpsMgr SDK Service to create the groups programmatically.

Back to the top

Issue 2
When you import a management pack or create a management pack from a management pack template, the following exception may be generated in the Operations Manager Operations Console:

Date: Date_and_Time
Application: System Center Operations Manager 2007
Application Version: 6.0.6278.0
Severity: Error
Message:
: Processing the template failed. See inner exception for details.
Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Too many table names in the query. The maximum allowable is 256.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = n, current count = n.
: Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Too many table names in the query. The maximum allowable is 256.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = n, current count = n

Additionally, the following events are logged in the Operations Manager log that is located on the Root Management Server.
Event ID 33333

Source: DataAccessLayer
Event ID: 33333
Description:
Data Access Layer rejected retry on SqlError:
Request: MPInfra_p_ManagementPackInstall -- (ManagementPackXML=<ManagementPack xmlns:xsd="URL" xmlns:xsl="URL" ContentReadable="t...), (ManagementPackXMLUpdateFragment=<ManagementPack xmlns:xsd="URL" xmlns:xsl="URL" ContentReadable="t...), (RunTimeXML=<ManagementPack xmlns:xsd="URL" xmlns:xsl="URL" ContentReadable="t...), (MPKeyToken=), (RETURN_VALUE=0)
Class: n
Number: n
Message: Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.

Event ID 26319

Source: OpsMgr SDK Service
Event ID: 26319
Description:
An exception was thrown while processing UpdateManagementPack for session id uuid<guid>;id=n.
Exception Message: The creator of this fault did not specify a Reason.
Full Exception: System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.ManagementPackException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to : Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Database error. [MPInfra_p_ManagementPackInstall] failed with exception:
Too many table names in the query. The maximum allowable is 256.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = n, current count = n.).

http://support.microsoft.com/default.aspx?scid=kb;en-us;974254

Read the complete post at http://wmug.co.uk/blogs/cliffs_blog/archive/2009/12/03/ms-kbs-a-hotfix-is-available-that-fixes-two-issues-with-management-packs-in-system-center-operations-manager-2007.aspx

Published Thursday, December 03, 2009 1:52 PM by Cliff Hobbs - FAQShop.com and Microsoft MVP ConfigMgr/ SMS
Filed under: , ,