Cliff Hobbs is a UK-based systems management consultant who specialises in the various systems management tools covered by his website FAQShop.com such as Microsoft System Center Configuration Manager (ConfigMgr) and Systems Management Server (SMS).Having worked with SMS since 1998 Cliff has gained extensive experience of designing, deploying, and supporting large enterprise-wide systems management solutions on behalf of companies such as EDS, 1E and Getronics.In recognition of his contribution to the Systems Management community Microsoft awarded Cliff the Most Valuable Professional (MVP) award for SMS in January 2004 which has been re-awarded in all subsequent years.Having grown up with the PC from the days of the IBM AT and PC-DOS 3.3, he has an extensive knowledge of several operating systems and applications gained through his present and past employment with companies such as EDS, Du Pont, Abbey National and Getronics, amongst others.The prime goal of FAQShop.com is to help people use Systems Management technology to make their lives easier - not for technology to control their lives which is reflected in this site's mission statement:
'Ensuring you get the best of IT'.
Issue 1You try to create many groups in a single management pack or to import a...
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
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