Maximo Open Forum

I would query to make sure the data is there. A where clause something like

(siteid = 'BEDFORD') and assetnum in (select assetnum from pluscassetstatus)

That should get you assets that have status history, and then you can try the action, which should work on those assets. 

(upper(status) = 'OPERATING' and siteid = 'BEDFORD') and assetnum in (select assetnum from pluscassetstatus) 
and (exists (select 1 from maximo.classancestor where ((ancestor = '1014')) and (classstructureid=asset.classstructureid)))

Thank you.  I tried the above where clause with our site id and it returned results.  I then tried the button on one of the results and it did not work. 

I will keep investigating.  Thank you again.

I had the same issue and followed the instructions on this link, https://www.ibm.com/support/pages/how-view-asset-status-history-assets-application. 

@Adam Ames  Thank you sir.  I did see that it wasn't enabled as an option in the security group so I added that.  For the first part of adding the code to the exported Asset.xml, could you please tell me where to look for that?  That is something new for me.  Thank you.

No problem. You can export the application xml files by going to Application Designer. Search for the Asset application and then once you are in the asset application design, you can click on the Export Application Definition button on the toolbar. Make sure to do this in a non-prod environment first and also make a backup of the asset.xml file after you download. Make the suggested changes to the xml file and then go back to Application Designer and the asset application design page. Next to the Export Application Definition button on the toolbar is an Import Application Definition button. Use the import to upload your modified asset.xml file.

@Adam Ames  Thank you so much!  You've opened up a whole new world for me. :)   

I was able to export but when importing I get different errors.  One is = designer/missingid

Can you import your backup without any errors? I have had issues depending on the text editor. The only one I have not had issues with is notepad++.