Jaspersoft database server migration

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Jasper 6.1

SOI 4.0 SP2

Moving existing Jasper DB to a new SQL Sever and need to setup existing Jasper to use the new SQL server.

Our DBA team is migrating all MS SQL 2008 R2 servers to 2012. Can you please provide me procedures or documentations on how to point Jaspersoft to a new database server?

Environment

Jasper 6.1SOI 4.0 SP2

Resolution

1) Stop CA_JasperReports_Server(tomcat)

2) You need to edit \CA\SOI\Reports\jr\apache-tomcat-7.0.68\webapps\jasperserver-pro\META-INF\context.xml
In this file, you will see the url where the SQL server hostname located.

3) If the password had changes, you will need to use \CA\SOI\Reports\jr\ca_install\encryption_utility\encrypt.bat utility to encrypt a new password.

4) Start Stop CA_JasperReports_Server(tomcat)