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.
| Info |
|---|
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|