Removing corrupted data and compacting the Report Builder database

Edit online

As an administrator, you can use the rs_compact command to remove corrupted data and to compact the Report Builder database.

About this task

Run this command from the from Jazz_Install_Dir/server directory.
rs_compact command parameters:
  • -ApplicationContextRoot <value>, where <value> is the current Jazz Reporting Service (JRS) root, for example /rs.
  • -dblocatiob <value>, where <value> is the full path to the Jazz Reporting Service database file. By default, it is Jazz_Install_Dir/server/conf/rs/db.

Procedure

  1. Shut down the server.
  2. Open the command prompt, and go to the Jazz_Install_Dir/server directory.
  3. Type one the following commands, and press Enter:
    • If you are using the default JRS context root and database location:
      • Windows upgrade\rs\rs_compact.bat
      • Linux upgrade/rs/rs_compact.sh
    • If your JRS context root is /rb:
      • Windows upgrade\rb\rs_compact.bat
      • Linux upgrade/rb/rs_compact.sh
    • If you are not using the default database location:
      • Windows upgrade\rs\rs_compact.bat -dblocation \Jazz_Install_Dir\Report_Builder_DB
      • Linux upgrade/rs/rs_compact.sh -dblocation /Jazz_Install_Dir/Report_Builder_DB
    • If you are not using the default JRS context root and database location:
      • Windows upgrade\rb\rs_compact.bat -ApplicationContextRoot rb -dblocation :\Jazz_Install_Dir\server\Report_Builder_DB
      • Linux upgrade/rb/rs_compact.sh -ApplicationContextRoot rb -dblocation :/Jazz_Install_Dir/server/Report_Builder_DB