View Only
  • 1.  Jaspersoft Tomact Errors

    Posted Mar 13, 2017 03:28 PM


    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.

  • 2.  Re: Jaspersoft Tomact Errors

    Posted Mar 14, 2017 02:36 AM



    What do you mean Jaspersoft Database? Do you mean the DWH Database or really mean the Jaspersoft Database?

  • 3.  Re: Jaspersoft Tomact Errors

    Broadcom Employee
    Posted Mar 14, 2017 02:46 AM

    Hi Lalitharjun,


    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.



    Suman Pramanik 

  • 4.  Re: Jaspersoft Tomact Errors

    Posted Mar 14, 2017 08:15 AM

    Hi Suman,

    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.




  • 5.  Re: Jaspersoft Tomact Errors

    Broadcom Employee
    Posted Mar 14, 2017 08:21 AM

    Hi Lalitharjun,


    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. 



    Suman Pramanik