SAP Knowledge Base Article - Preview

2179579 - Unable to delete an iOS device from the Afaria Administrator Console

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

SAP Afaria 7.0

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.