Procedure to reconfigure JasperSoft 7.1.1 + when JasperSoft SQL database repository are moved or changed

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

JasperSoft uses a repository data source to store its profile data and this repository database is an integral part of the JasperSoft application. Without it, JasperSoft will not function. If making any changes to this repository data source such as its database server (Postgres, MySQL, SQL, Oracle, etc), configuration (port),  and/or access credential (name and password),  changes are required to the application context to reflect the repository data source changes.

Environment

JasperSoft 7.1.1 +
All Supported Windows Operating Systems
Tomcat Application Web Server

Resolution

JasperSoft SQL database moved to another SQL server location.  Similar steps can be used if other JasperSoft database changes (i.e. port, user name) are made.

1.  Stop the Apache Tomcat service on the JasperSoft server
2.  Take a backup of the SQL JasperSoft database and restore it to the new SQL server
3.  Take a backup of the <Apache Install Directory>\webapps\jasperserver-pro\META-INF\context.xml file on the JasperSoft server
4.  Using a text editor, open the <Apache Install Directory>\webapps\jasperserver-pro\META-INF\context.xml file on the JasperSoft server
5.  Locate the section that looks similar to the following

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="<dbusername>" password="<yourdppassword>" driverClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:tibcosoftware:sqlserver://<dbhostname>:<port, or 1433 is default port>;databaseName=jasperserver;SelectMethod=cursor;sendTimestampEscapeAsString=false factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>

6.  Change the URL parameter to reflect the new location of the JasperSoft database.
7.  Save changes to the file
8.  If it exists, delete the JASPERSERVER-PRO.XML file from the <Apache Install Directory>conf\Catalina\localhost directory on the JasperSoft server
9.  Restart the Apache Tomcat service on the JasperSoft server
10.  Test JasperSoft UI and functionality