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 ...Fix: Asset Replenishment Notification failure in Non-ESM setups
Issue: In non-ESM setups, when Graph is configured in the Outgoing settings, Asset Replenishment Notifications aren't sent. It failed with the below trace. ...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", ...