The following error appears when trying to connect JasperStudio to Service Desk Manager: jdbc:sdm:bop:@<service desk manager hostname>:2100; is invalid for driver com.ca.sdm.dal.sql.jdbc.driver.DalJdbcDriver

book

Article ID: 221315

calendar_today

Updated On:

Products

CA Service Desk Manager CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears when creating an adapter in Jasper Studio and trying to establish a connection in Jasper studio to SDM:

URL jdbc:sdm:bop:@<service desk manager hostname>:2100; is invalid for driver com.ca.sdm.dal.sql.jdbc.driver.DalJdbcDriver

 

Cause

Ports 2100 through 2200 are closed between the Service Desk Manager server and Jasper Studio server

 

Environment

Release : 17.3

Component : JASPERSOFT REPORTS FOR SERVICE MANAGEMENT

Resolution

Contact the network team to open ports 2100 through 2200 between the Service Desk Manager server and Jasper Studio server

It's recommended to have the NX_SLUMP_FIXED_SOCKETS option installed to force slump server to open ports as close as possible to 2100 value.

Related KB articles:

How does CA Service Desk Manager (SDM) behave within a network.

What ports does an ITSM 17.x system use?

How To Limit SDM Port Bindings

Additional Information

Create Data Adapter