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: com.microsoft.sqlserver.jdbc.SQLServerException: 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.
New to ADSelfService Plus?
Related Articles
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]: ...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 ...Asset auto assign fails
When trying to auto assign Owner for assets if it shows failed for all assets with screen shot like shown below, As you can see from the above screen shot that the Suggested Owner field is Empty for all assets. In such cases, you can observe the ...Query to show all asset details ( MSSQL )
Tested in build MSSQL (14306) SELECT MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("resource"."ASSETTAG") AS "Asset Tag",MAX(resource.SERIALNO) AS "Org Serial Number", MAX("product"."COMPONENTNAME") AS "Product", ...Remote Asset explorer license Explained
With the behavior change in the ServiceDeskPlus-MSP as mentioned in this post. Hope, you are aware that the Remote Asset explorer needs to be installed in each site, from where the assets will be pushed to ServiceDeskPlus-MSP. Considering the above, ...