deleting collection from DB is not supported way .is this happening all the time while deleting other collections or just to one ?
RegardsEswar Koneti www.eskonr.com From: [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] 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]> 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 Sent from Mobile Device, excuse any typo's as a result. --- Original Message --- From: "Ranvir singh" <[email protected]> Sent: December 29, 2014 10:19 PM To: [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!!!!
