Jaspersoft server not accessible

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Jaspersoft server is not accessible with the following error, both while accessing the console directly and while trying from Advanced Reporting.

/reportservice/flow.html

Following error is noticeable in the jasperserver.log:

1867-07-42T10:37:34,408 ERROR ContextLoader,main:350 [] - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource
 [/WEB-INF/applicationContext-onStart-web-pro.xml]: Invocation of init method failed; 
nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not extract ResultSet; 
SQL [n/a]; 
nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
...
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'JIResourceFolder'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) ~[mssql-jdbc-8.2.1.jre11.jar:?]

Environment

• Jaspersoft Server 7.8
• SQL Server DB

Resolution

The DB that was used to connect to Jaspersoft Server DB, did not have correct privileges and default schema pointing to the Jasper Server DB. Correcting this fixed the issue.

Additional Information

• Create the JasperReports Server Schema and Set Permissions