Enable JasperReports Server Repository Backups

To enable scheduled backups of Jasper Repository and the PostgreSQL database:

From RiskVision 9.4 and up, replace the buildomatic folder of the reportserver in the server folder and let be the js-export.cmd of the server folder to take back up of Jasper Repository and the PostgreSQL database using Daily Server Backup and Database Hot Backup job.
  1. Navigate to the js.jdbc.properties properties file.  The default location is:<%JASPER_HOME%>\buildomatic\build_conf\default directory
  2. Copy the file. 
  3. Replace the  js.jdbc.properties file with the copied file on the <%AGILIANCE_HOME%>\buildomatic\build_conf\default directory where the Application Server is installed.

        If you have a multi-tier setup, add your Jasper Server name to this line:

        metadata.jdbc.url= jdbc:postgresql://<Jasper Server name>:5432/jasperserver

  1. Retrieve the Jasper repository backup:
    1. Go to the %Jasper_Home%\config_ks directory on the JasperReports Server host. 
      If you are using a version of Jasper before 7.9, you will need to navigate to %Jasper_Home%\config.
    2. Copy the .jrsksp file.
    3. On the RiskVision Tomcat host, paste the .jrsksp file into the desired backup folder. 
    4. Go to %Agiliance_Home%\buildomatic Edit js-export.bat.
    5. Append the command -Duser.home=<Location of the .jrsksp file>

For example: 

If the file was placed on C:\Server\: 

set JAVA_OPTS=%JAVA_OPTS% -Xms1024m -Xmx2048m -XX:PermSize=64m

Would become: 

set JAVA_OPTS=%JAVA_OPTS% -Xms1024m -Xmx2048m -XX:PermSize=64m -Duser.home=C:\Server\

  1. On the JasperReports Server host, go to %Jasper_Home%\config_ks. 
  2. Copy the .jrsks file
  3. In the RiskVision Tomcat host, create the same Jasper_Home path as above and paste the copied config_ks directory into the path.

For example: 

If the .jrsks file is located at C:\ReportServer\ReportServer\config_ks, create the same directory in the RiskVision Application Server. Paste the .jrsks file into the directory.

  1. Open the keystore.init.properties file in the following folders:
    • <%AGILIANCE_HOME%>\buildomatic\build_conf\default\webapp\WEB-INF\classes\
    • <%AGILIANCE_HOME%>\buildomatic\build_conf\default\ 
    • <%AGILIANCE_HOME%>\buildomatic\ 
  2. Update the ks and ksp path as below:
     
    • ks=C\:\\ReportServer\\ReportServer\\config_ks
       ksp=C\:\\Server
  3. Navigate to the <%JASPER_HOME%>\postgresql\data\ folder on the report server side and add the following entry to the pg_hba.conf file underneath Allow replication connections:
    • host all postgres %RVIPADDRESS%/32 md5
  4. Restart RiskVision and Jasper Services. 
  5. Access RiskVision and run the Daily Server Backup and Database Hot Backup jobs.