Deleting a device from XenMobile console reports an error and the device is not deleted from XenMobile console.

This software application is provided to you as is with no representations, warranties or conditions of any kind. You may use and distribute it at your own risk. CITRIX DISCLAIMS ALL WARRANTIES WHATSOEVER, EXPRESS, IMPLIED, WRITTEN, ORAL OR STATUTORY, INCLUDING WITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NONINFRINGEMENT. Without limiting the generality of the foregoing, you acknowledge and agree that: (a) the software application may exhibit errors, design flaws or other problems, possibly resulting in loss of data or damage to property; (b) it may not be possible to make the software application fully functional; and (c) Citrix may, without notice or liability to you, cease to make available the current version and/or any future versions of the software application. In no event should the software application be used to support ultra-hazardous activities, including but not limited to life support or blasting activities. NEITHER CITRIX NOR ITS AFFILIATES OR AGENTS WILL BE LIABLE, UNDER BREACH OF CONTRACT OR ANY OTHER THEORY OF LIABILITY, FOR ANY DAMAGES WHATSOEVER ARISING FROM USE OF THE SOFTWARE APPLICATION, INCLUDING WITHOUT LIMITATION DIRECT, SPECIAL, INCIDENTAL, PUNITIVE, CONSEQUENTIAL OR OTHER DAMAGES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. You agree to indemnify and defend Citrix against any and all claims arising from your use, modification or distribution of the software application.

Complete the following steps to resolve this issue:

1. Selectively wipe the device that you are unable to delete from the XenMobile console.
2. Authorize the device on XenMobile console by navigating to Device > Secure > Authorize.
3. Try again to delete the device from XenMobile console.

If the steps mentioned above doesn't delete the device successfully, you can delete the device from the XenMobile database by running the following commands :

SELECT * FROM dbo.DEVICE WHERE SERIAL_NUMBER='qwerty1234';

This will show all the records in the table for this serial number. Once confirmed the correct device list you can run the following command to delete the same:

DELETE FROM dbo.DEVICE WHERE SERIAL_NUMBER='qwerty1234';

Note:

1. Ensure that you take a backup of your database before making any changes to it. 
2. This article was written for a specific scenario and can only be used as last resort.

---

Problem Cause

This issue can be caused due to database corruption or duplicate entries within the database. This can occur during XenMobile Server migration.

While deleting a device from XenMobile console, an error is reported and the device is not deleted from XenMobile console.