Unable to connect to JasperSoft Server via JasperSoft Studio

Article Id: 108033

Status: Published

Updated On: 26-07-2018 19:33

Products:

CLARITY PPM FOR ITG CA Project & Portfolio Management CLARITY PPM FEDERAL CA Project & Portfolio Management SAAS STARTER PACK-CLARITY PPM

Issue/Introduction:

Connection test for Data Adapter and JasperSoft Server through Studio fails with given exception:

Data Adapter connection test returns with an exception:
Reason: java.sql.SQLException: Server URL is invalid. Please check reporting server complete url in the JDBC URL.

Server Connection test returns socket exception:
faultString: java.net.SocketException: Connection reset

Cause:

Network Proxy restrictions is causing JasperSoft Studio connection failure with JasperSoft Server on SaaS.

Environment:

CA PPM SaaS

Resolution:

Please engage local network team to setup Manual Proxy on JasperSoft Studio available under Windows > Preferences > General > Network Connections > Active Provider to 'Manual' instead of 'Direct'.

NOTE: Alternatively you add it as 'Proxy Bypass Host' and your corporation Proxy allows this.

Additional Information:

Refer# Jaspersoft Studio Professional CA JDBC Adapter:
https://docops.ca.com/ca-ppm-saas/15-4/en/advanced-reporting-with-jaspersoft/jaspersoft-studio-professional-ca-jdbc-adapter