Symptom
Afaria Administrator UI crashes with below stack trace when attempting to delete an iOS device.
Devices.DeleteDevice(0x01719140): The DELETE statement conflicted with the REFERENC constraint "FK_A_IPHONE_DEVICE_VPP_HASH_LIST_A_IPHONE_DEVICE". The conflict occurred in database "Afaria_Production", table "dbo.A_IPHONE_DEVICE_VPP_HASH_LIST", column 'ClientUID'.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ServiceModel.FaultException`1 [[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]: Devices.DeleteDevice(0x01719140): The DELETE statement conflicted with the REFERENCE constraint "FK_A_IPHONE_DEVICE_VPP_HASH_LIST_A_IPHONE_DEVICE". The conflict occurred in database "Afaria_Production", table "dbo.A_IPHONE_DEVICE_VPP_HASH_LIST", column 'ClientUID'.
The statement has been terminated.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [FaultException`1: Devices.DeleteDevice(0x01719140): The DELETE statement conflicted with the REFERENCE constraint "FK_A_IPHONE_DEVICE_VPP_HASH_LIST_A_IPHONE_DEVICE". The conflict occurred in database "Afaria_Production", table "dbo.A_IPHONE_DEVICE_VPP_HASH_LIST", column 'ClientUID'.
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage (IMessage reqMsg, IMessage retMsg) +14799942
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +622
AfariaServiceRef.Devices.IDevicesService.DeleteDevice(DeleteOptions deleteOptions, String[] ids) +0
Afaria.Admin.UserControls.Device.DeviceGrid.DeleteDevices(Stringargs) +1216
Afaria.Admin.UserControls.Device.DeviceGrid.ajaxMgr_DeviceGridAjaxRequest (Object sender, AjaxRequestEventArgs e) +1128
Telerik.Web.UI.AjaxRequestDelegate.Invoke(Object sender,
AjaxRequestEventArgs e) +0
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804
Read more...
Environment
SAP Afaria 7 Service Pack 5
Product
Keywords
SP5 Sp 5 admin ui crash vpp Service Pack FK_A_IPHONE_DEVICE_VPP_HASH_LIST_A_IPHONE_DEVICE A_IPHONE_DEVICE_VPP_HASH_LIST , KBA , MOB-AFA , Afaria , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.