Unable to modify asset state or unable to edit assets

Unable to modify asset state or unable to edit assets


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]: Exception while trying to retrieve data for Asset : 744955| 
at com.adventnet.servicedesk.utils.Select2Util.constructJSONData(Select2Util.java:78)
at com.adventnet.servicedesk.asset.action.MSPAssetDefAction.fillDetails(MSPAssetDefAction.java:75)
at com.adventnet.servicedesk.asset.action.AssetDefAction.execute(AssetDefAction.java:796)
at com.adventnet.servicedesk.asset.action.MSPAssetDefAction.execute(MSPAssetDefAction.java:39)


Issue is because those assets which has this issue does not have department assigned to it properly. 


Navigate to Assets list view->Select all the assets that has this issue->Actions-> Modify State->Assign to Department->Select the Account and Department and save.

If there are more number of assets in trouble, you can use this below query to find out the same,

select r.resourcename,r.ciid,ro.deptid,dd.deptname,dd.siteid from resources r inner join resourceowner ro on r.resourceid=ro.resourceid inner join departmentdefinition dd on ro.deptid=dd.deptid where dd.siteid is null

      • Related Articles

      • How to modify text in self service portal home page

        Use case In requester home page, we have a default template with buttons such as "Create an issue", "Request a service", "View All Solutions". We can modify the text to our own words Solution 1. Login as Admin, go to the Home Page, click on Edit ...
      • Script for Mandating Asset field in Request Creation/Edit page

        Please Use the below script in FAFR to mandate Asset field in the Request Creation/Edit page if(jQuery("#selectedCIs").val() == ""){ alert("Asset(s) field cannot be empty."); $CS.stopFormSubmission(); }
      • Blank screen while opening timesheet

        Issue :  While opening a timesheet, the page appears blank like the below screenshot  Cause : The issue occurs if the date format is set to dd.mm.yyyy Solution :  Please login as the user, click on the user badge on the top right corner, click ...
      • Error when generating reports in Linux installation

        Error: Sorry an error has occurred. It appears to be an issue related to the fonts. JDK recommends installing the font on the Linux machine. In general, OpenJDK installation packages do not include any font files by default. But automatically use ...
      • Query to show Asset state history

        MSSQL: SELECT res.resourcename 'Asset Name', res.assettag 'Asset Tag',res.serialno 'Asset Serial No.', rs2.statedesc 'Previous State',rs1.statedesc 'Current State',DATEADD(s,DATEDIFF(s,GETUTCDATE() ,getdate()) + (rsh.STARTTIME/1000),'1970-01-01 ...