You might need to use wmi to remove that collection http://msdn.microsoft.com/en-us/library/cc143328.aspx
From: [email protected] [mailto:[email protected]] On Behalf Of Eswar Koneti Sent: Tuesday, December 30, 2014 22:07 To: [email protected] Subject: RE: [mssms] SCCM Console getteing Creashed while deleting the SCCM 2007 R3 collections deleting collection from DB is not supported way .is this happening all the time while deleting other collections or just to one ? Regards Eswar Koneti www.eskonr.com<http://www.eskonr.com> ________________________________ From: [email protected]<mailto:[email protected]> Date: Tue, 30 Dec 2014 11:32:04 +0100 Subject: Re: [mssms] SCCM Console getteing Creashed while deleting the SCCM 2007 R3 collections To: [email protected]<mailto:[email protected]> Hi Eswar, Collection query (WQL) is the correct query.. I given a try with multiple collection sytax with WQL query, some are empty collections... not working... If i want to delete im deleting from the database On Mon, Dec 29, 2014 at 3:26 PM, Eswar Koneti <[email protected]<mailto:[email protected]>> wrote: Why does your wql(collection query) has count? It willl not give you the count of pcs in collection instead reports. Correct the collection with right syntax? Did you verify the collection syntax? Regards, Eswar Koneti www.eskonr.com<http://www.eskonr.com> Sent from Mobile Device, excuse any typo's as a result. --- Original Message --- From: "Ranvir singh" <[email protected]<mailto:[email protected]>> Sent: December 29, 2014 10:19 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] SCCM Console getteing Creashed while deleting the SCCM 2007 R3 collections Hi Team, Im getting the below error while deleting the collection from SCCM 2007 R3 An error occured in ConfigMgr. The ConfigMgr console will continue to function, however you should save your work and restart the console. After restarting the console, verify that your last configurations have been applied. System.ArgumentException: An error message must be supplied. Parameter name: message at Microsoft.ConfigurationManagement.AdminConsole.SmsErrorDialog..ctor(String details, String message, String caption, Icon icon) at Microsoft.ConfigurationManagement.AdminConsole.SmsErrorDialog..ctor(Exception ex, String message, String caption) at Microsoft.ConfigurationManagement.AdminConsole.DeleteCollectionWizard.DeleteCollectionWizardForm.PostApply(BackgroundWorker worker, DoWorkEventArgs e) at Microsoft.ConfigurationManagement.AdminConsole.SmsWizardForm.OnFinish() at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Admin UI .log [3][12/29/2014 2:00:45 PM] :Help topic not found in 'HelpTopicLinks.xml' for topic ID: '7e96e251-ed74-4905-87c0-77d082a5fa4d' [3][12/29/2014 2:01:00 PM] :Help topic not found in 'HelpTopicLinks.xml' for topic ID: '7e96e251-ed74-4905-87c0-77d082a5fa4d' [17][12/29/2014 2:36:45 PM] :System.Management.ManagementException\r\nGeneric failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()\r\nManagementException details: instance of __ExtendedStatus { Description = "[42000][156][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AS'."; Operation = "ExecQuery"; ParameterInfo = "SELECT COUNT(*) FROM SMS_CM_RES_COLL_XXXcollID"; ProviderName = "WinMgmt"; StatusCode = 2147749889; }; \r\n Any idea please!!!!
