Fix for Issue with deleting Assets

Fix for Issue with deleting Assets

Upon on deleting assets, if you get the below error:

Verify if you can see the below trace in logs:

[11:23:12:374]|[13-10-2021]|[com.adventnet.servicedesk.asset.util.AssetUtil]|[SEVERE]|[83]: Exception while updating Workstation with id : 7106| 
com.adventnet.persistence.DataAccessException: Exception occured while executing SQL to delete rows

Caused by: The DELETE statement conflicted with the REFERENCE constraint "CIType_5409_FK". The conflict occurred in database "servicedesk", table "dbo.CIType_5409", column 'CIID'.

If yes, follow the below mentioned:

1. Go to Reports > New Query Reports and execute the below query:
select * from citype where tablename='CIType_5409'

2. Then go to Admin > Configuration Item Types and check the details of the CI type which was displayed upon executing the above query. 

3. Now create a new CI type with the same properties like this one, that is, it should be a replica of this CI type (Only the name of the newly created CI type should be different). 

4. Now try performing the delete operation.

          • Related Articles

          • When will the Assets get duplicated ?

            Please find the possible scenarios when the machines are renamed with _old Scenario 1:    When the workstations are swapped in the network.  Consider two workstations, MACHINE-A with service tag ST-1 and MACHINE-B with ST-2. Both the workstations are ...
          • Unable to modify asset state or unable to edit assets

            Issue: While trying to change asset state from list view, we get "Sorry an error has occurred". If we try to Edit that asset, we get a blank page. Error traces from logs: |[com.adventnet.servicedesk.asset.action.AssetDefAction]|[SEVERE]|[102]: ...
          • Fix for 9416 scheduled report issue

            Issue: ( Issue id: 13086) It is applicable only for build number 9416 and 9417 Custom report (not default report) when scheduled has the attachment sent but no data in it or corrupted. Fix: The 1.fjar has been attached herewith. Please place this jar ...
          • JIRA integration - Issue Types are not loaded

            Post the JIRA is integrated with SDP MSP , the Projects data gets populated. However the other field - Issue Types will not show any values. To fix this follow the below steps The api call is used to fetch the issue types is ...
          • Fix for deleting the Dashboard

            On detailed analysis, we found this to be recreated in our end and it is assigned with an Issue ID: 15221. This has been earmarked to be fixed in one of our future hotfixes of ServiceDesk Plus MSP. Until then, kindly bear with us. Your patience is ...