Error deleting devices using deviceex_de

Customer getting an error message when trying to remove some decommissioned devices.

Step-by-step guide

The reason behind this is the stored procedure needs to be to be updated, if you have access to the stored procedure which is located

From the iQData > Programmability > Stored Procedures > dbo.DeviceEx_de

Right click and modify.

Add the following:

UPDATE [FoundApplication] SET [FoundOnDeviceID] = NULL WHERE [FoundOnDeviceID] = @DeviceID;

Like below and click f5 to save.

This will update stored procedure permanently and this will resolve the issue

If you don’t have access to modify you can run the SQL

but you will have to change the deviceID for each of Device and then run the stored procedure.