Advanced Reporting: Filtering on Favorites error

Products

• Clarity PPM On Premise

Issue/Introduction

A specific user is getting an error on the Advanced Reporting - Search Repository menu when filtering on her favorites
"There was an error on the server. Try again or contact site administrators"

In the jasperserver.log file we get the following error:

2025-01-20T12:25:37,096 ERROR SecureExceptionHandlerImpl,http-nio-8088-exec-10:125 [] - There was an error on the server. Try again or contact site administrators.
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource#40698]

Environment

Any Clarity release

Cause

There is an orphan favorite reference of the resource that does not exist

Resolution

Run the following queries in the Jaspersoft schema

• select * from jiresource where id = 40698 <This is the ID retrieved form the jasperserver.log file>
• select * from jifavoriteresource j where resource_id = 40698 <This is the ID retrieved form the jasperserver.log file>
• If the first query does not return any row and the second one does, just delete it