search cancel

Recreate Jaspersoft organization

book

Article ID: 229310

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

How to delete and recreate the Jaspersoft organization in Advanced Reporting with the OOTB Content in order to reset the content? 

Environment

Release : Any supported release

Resolution

Disclaimer: This will remove/drop all custom content such as custom reports, domains etc., also report schedules and report exports in PDF/XLS etc. Some data may be lost. Ensure you backup and export to a zip file all the content that you need. Must be tried on a lower environment first

  1. Connect to Jaspersoft console with superuser 
  2. Go to Organizations - select and delete the organization
  3. If you have an issue use the solution below: Cannot delete organization from Jaspersoft 7.8
  4. Run the command on your Clarity database, this will remove the line that Jaspersoft content is installed:
    delete from cmn_install_history where install_id='contentPack::csk::jaspersoft'
    and base_release = '16.0.0' -----ensure you add the base release for your current Jaspersoft version, i.e. 15.9.3, 16.0.1
    commit;
  5. Now connect to the Clarity server in a command prompt and run the query:
    admin content-jaspersoft csk -userName superuser -password <password>
    This will install the default OOTB content from jaspersoft_csk.zip on the server
  6. Once done, restart Jaspersoft
  7. Run the jobs
    • Load Data Warehouse - Full
    • Load Data Warehouse - Access rights
    • Create and Update JS Users rights
    • Jaspersoft Role Synchronization(if in use)