Can't connect to database in installation of Jasperserver 7.9 (js-install.bat)

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Jaspersoft installer not able to connect to Oracle database - won't accept the SID.

Environment

Release : 17.3

Component : SDM - Reporting/BOXI/JasperSoft

Resolution

use service name instead of SID in "default_master.properties" property file and see if connection gets successful.

You can uncomment below property to use service name, so that connection URL will be : jdbc:tibcosoftware:oracle://hostname:1521;ServiceName=ABCDEF.com

serviceName=ABCDEF.com