smsprov.log might contain additional information.Torsten Meringer | http://www.mssccmfaq.de

Hello Torsten Just found this : c:\qfe\nts_sms_fre\sms\siteserver\sdk_provider\smsprov\sspresource.cpp(388) : Error deleting discovery data in SQL * * [2DF4][Tue 08/21/2012 10:15:40]: * * Error deleting discovery data in SQL * * [2DF4][Tue 08/21/2012 10:15:40]:Failed to DeleteDiscoveryItem err code = 3 and this in adminUI.log : [3][21/08/2012 10:01:04] :Microsoft.ConfigurationManagement.ManagementProvider.SmsConnectionException\r\nSpecified cast is not valid.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryPropertySingleItem.get_BooleanValue() at Microsoft.ConfigurationManagement.AdminConsole.CollectionMenuActions.LaunchUtilities.IsApproveMemberActionEnabled(Object sender, ScopeNode scopeNode, ActionDescription action, ResultObjectBase selectedResultObject)\r\nSpecified cast is not valid. \r\nSystem.InvalidCastException\r\nSpecified cast is not valid.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryPropertySingleItem.get_BooleanValue()\r\n [3][21/08/2012 10:15:40] :System.Management.ManagementException\r\nGeneric failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObject.Delete(DeleteOptions options) at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Delete(ReportProgress progressReport)\r\nManagementException details: instance of SMS_ExtendedStatus { CauseInfo = "3"; Description = "Error deleting discovery data in SQL"; ErrorCode = 2168655109; File = "c:\\qfe\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspresource.cpp"; Line = 388; Operation = "DeleteInstance"; ParameterInfo = "SMS_R_System.ResourceId=146388"; ProviderName = "WinMgmt"; StatusCode = 2147749889; }; \r\n [3][21/08/2012 10:15:40] :Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nFailure deleting management object\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Delete(ReportProgress progressReport) at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Delete() at Microsoft.ConfigurationManagement.AdminConsole.DeleteCollectionWizard.MenuUtilityClass.DeleteMenuAction(Object sender, ScopeNode scopeNode, ActionDescription action, IResultObject selectedObjects, PropertyDataUpdated dataUpdatedDelegate, Status status)\r\nConfigMgr Error Object: instance of SMS_ExtendedStatus { CauseInfo = "3"; Description = "Error deleting discovery data in SQL"; ErrorCode = 2168655109; File = "c:\\qfe\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspresource.cpp"; Line = 388; Operation = "DeleteInstance"; ParameterInfo = "SMS_R_System.ResourceId=146388"; ProviderName = "WinMgmt"; StatusCode = 2147749889; }; \r\nSystem.Management.ManagementException\r\nGeneric failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObject.Delete(DeleteOptions options) at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Delete(ReportProgress progressReport)\r\nManagementException details: instance of SMS_ExtendedStatus { CauseInfo = "3"; Description = "Error deleting discovery data in SQL"; ErrorCode = 2168655109; File = "c:\\qfe\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspresource.cpp"; Line = 388; Operation = "DeleteInstance"; ParameterInfo = "SMS_R_System.ResourceId=146388"; ProviderName = "WinMgmt"; StatusCode = 2147749889; }; \r\n Can this be related to SQL Time-out ?

Hi, This usually a SQL related error. Check the error message in the AdminUI.log first. In AdminUI.log, it may show more information about this error, because it maybe timeout or sql syntax related. Which version of SQL server did you used? Have you updated SQL server to latest path? Here are some references for you: http://social.technet.microsoft.com/Forums/en/configmgradminconsole/thread/d60fd6dc-7f1e-41f7-b317-2837eee5cb98 Hope this will help. Thanks

Hi, I did post the adminui.log here above. I did not found additional information in that file. Our SQL SQL server is Microsoft SQL Server Enterprise Edition (64-bit) 10.0.2757.0 I'm nearly sure that this error is related to time-out because retrying to delete the ressource that raised an error works fine. Sincerely, Michel

Hello, I got this error message when tring to delete a couple of ressources from SCCM: ConfigMgr Error Object: instance of SMS_ExtendedStatus { CauseInfo = "3"; Description = "Error deleting discovery data in SQL"; ErrorCode = 2168655109; File = "c:\\qfe\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\ \sspresource.cpp"; Line = 388; Operation = "DeleteInstance"; ParameterInfo = "SMS_R_System.ResourceId=124024"; ProviderName = "WinMgmt"; StatusCode = 2147749889; }; Can someone explain what is going on ? Regards, Michel