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 this_.id as id5_0_, this_.version as version5_0_, this_.uri as uri5_0_, this_.hidden as hidden5_0_, this_.name 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?
What do you mean Jaspersoft Database? Do you mean the DWH Database or really mean the Jaspersoft Database?
You should never refresh the Jaspersoft database like that as the keystore probably is not matching and the organization name. the best need to be done is to migrate the content and not database.
Thanks for your response.
In your response are you referring repository content? So, if we have to replicate the production environment in lower environment. We have to either use existing installation of Jaspersoft or install a new instance and
1. export the repository content in production at top level.
2. Import the repository content in Test.
Is this correct? Please advise.
Jaspersoft is a multitenant system so if you want to use 1 jaspersoft for multiple instance you need to segregate using organization which I called as Tenants, you can either use the migrate command shared in our documentation or if you are in Jaspersoft 6.2.1 you can export individual folders also.
Also the approach you said is correct.