AnsweredAssumed Answered

Jaspersoft Tomact Errors

Question asked by Lalitharjun on Mar 13, 2017
Latest reply on Mar 14, 2017 by Suman Pramanik


We were trying to refresh the Jaspersoft database on test environmnet with the hot backup of production copy. Post database refresh, jasperosft stopped working and giving Http 404 error.

tomcat logs below entry 


Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select as id5_0_, this_.version as version5_0_, this_.uri as uri5_0_, this_.hidden as hidden5_0_, as name5_0_, this_.label as label5_0_, this_.description as descript7_5_0_, this_.parent_folder as parent8_5_0_, this_.creation_date as creation9_5_0_, this_.update_date as update10_5_0_ from JIResourceFolder this_ where (this_.uri=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Has anyone seen this error?

Thank you.