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. |
- Navigate to the js.jdbc.properties properties file. The default location is:<%JASPER_HOME%>\buildomatic\build_conf\default directory
- Copy the file.
- 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
- Retrieve the Jasper repository backup:
- 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. - Copy the .jrsksp file.
- On the RiskVision Tomcat host, paste the .jrsksp file into the desired backup folder.
- Go to %Agiliance_Home%\buildomatic Edit js-export.bat.
- Append the command -Duser.home=<Location of the .jrsksp file>
- Go to the %Jasper_Home%\config_ks directory on the JasperReports Server host.
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\
- On the JasperReports Server host, go to %Jasper_Home%\config_ks.
- Copy the .jrsks file
- 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.
- 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\
- Update the ks and ksp path as below:
ks=C\:\\ReportServer\\ReportServer\\config_ks
ksp=C\:\\Server
- 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
- Restart RiskVision and Jasper Services.
- Access RiskVision and run the Daily Server Backup and Database Hot Backup jobs.