If you are an existing On Premise Clarity PPM customer and run the Japsersoft audit reports they fail in Jaspersoft Server with Microsoft SQL Server.
Steps to reproduce:
On Premise Clarity PPM JasperReports Server with Microsoft SQL Server database
The Audit reports are failing because Jaspersoft Server expects the user is granted db_owner. Unfortunately, by explicating granting the db_owner to the existing installation will not work. Hence you need to install Jaspersoft again and you need to ensure when you create the user grant the db_owner. Look into more under installation document. <Please see attached file for image>
<Please see attached file for image>