Opening Favorite Reports in VMware vRealize Business Advanced or Enterprise fails with the error: An unexpected error occurred

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• In VMware vRealize Business Advanced or Enterprise, when you click on REPORTS > Favorite Reports you see the error:
  
  An unexpected error occurred. Please contact support and attach the VMware IT Business Management Suite system log file (sf.log). If you do not have access to the IT system log file, contact your System Administrator for assistance. (code:1001)
  
  
• In the sf.log file, you see entries similar to:
  
  
  ERROR 2015-09-10 17:51:31.999 (ingBeanActionHandler.handleException: 108) Error while calling method WebFavoritesFacadeImpl.getLevels().
  Finder "from FavoritePTreeNodeImpl n where n.efavoritesNodeType=2 and n.efavoritesReportType=1" with args=NULL failed.
  Nested exception is: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.digifuel.serviceflow.infra.frontoffice.reports.core.favorites.orm.FavoritePTreeNodeImpl#63750]

Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.

Cause

This issue occurs when the folder used for the report does not exist anymore. The report is still linked to the folder.

Resolution

To resolve this issue, place the report in an existing folder:

In the sf.log file, the FavoritePTreeNodeImpl#63750 entry contains the number 63750 which is the ID for the folder that does not exist in this example.

1. Log in to the database with a user account that has write permissions.
2. Determine the PTREE_BASE_ID and SPECIFIC_REPORT_ID of the report by running this SQL statements:
   
   select PTREE_BASE_ID, NAME, SPECIFIC_REPORT_ID, DESCRIPTION, PARENT_ID from RPS_FAVORITE_ENTRY where PARENT_ID = 63750;
   
   
3. Run these statements to display a list of folders and their respective IDs to determine the ID of a folder to which you want to move the report:
   
   select PTREE_BASE_ID, NAME, DESCRIPTION from RPS_FAVORITE_ENTRY where SPECIFIC_REPORT_ID is NULL;
   
   Note the PTREE_BASE_ID of the folder to which you want to move the report.
   
   
4. Move the report to the selected folder by running this SQL statement:
   
   Note: Before running the commit command, ensure that only one row is being updated. If you are updating more than one row, issue a rollback command and fix the first command.
   
   update RPS_FAVORITE_ENTRY set PARENT_ID = <PTREE_BASE_ID of the folder where to put the report> where PTREE_BASE_ID = <PTREE_BASE_ID in step 'a' above> and SPECIFIC_REPORT_ID = <SPECIFIC_REPORT_ID value in step 'a'.>;
   commit;
   
   
5. Log in to vRealize Business Designer and click TOOLS > Refresh Cache.
6. Go to vRealize Business ITFM.
7. Click REPORTS > Favorite Reports and verify that the error does not appear anymore.