Jaspersoft Connection issues - master KB of known issues
Article ID: 227723
Updated On:
Products
Clarity PPM On Premise
Clarity PPM SaaS
Issue/Introduction
Known issues related to Jaspersoft Connection issues including Jaspersoft Studio and Jaspersoft Server
Resolution
Table of Contents
Database change / issue related
- Jaspersoft "Database Connection Check" report error after move of Clarity DB
- Error "HTTP Status 404-Not Found" when entering Jaspersoft reporting server URL - this is related to Database connectivity issues. Error in logs mentions Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
- Jaspersoft Install error 'java.nio.BufferUnderflowException' when trying to establish a connection with JDBC on DB - Jaspersoft with Oracle 12.1.0.2.0 to 12.2.0.0.0
Post CSA changes
- Unable to access Advanced Reporting / "Error 500..." after changes are made to CSA -The Create and Update Jaspersoft Users job fails with error:
Failed to get an instance of ClarityJasperAdmin :: Exception getting ClarityJasperAdmin : Connection refused: connect - Jasper reports connection error after changing the Clarity default port - In the jasperserver.log file, connection errors such as "http 302" or "network connection failed" are seen.
Configuration Issues
- Jaspersoft install script fails with Error "Invalid connection string format..."
- Jasper tomcat fails to start with Error "Connection refused:" when there is an incorrect profile configuration
- Unable to publish report from Jaspersoft Studio due to setting
- Jasper Studio query "Error preparing statement for executing the report query" (Parameter issue)
- Error '(401) Unauthorized' when trying to connect from Jasper Studio in Clarity
- Jaspersoft Studio connection error 401 or 404 when a proxy is used
- Jaspersoft studio error 404 or 401 when 'Use SOAP PROTOCOL ONLY' is checked
Certificate Issues
- Unable to connect to Jaspersoft Studio - SSLHandshakeException: Remote host closed connection during handshake
- Jaspersoft Studio unable to connect when there is a SSL handshake failure in Clarity SaaS
Network Issues
- Unable to connect to JasperSoft Server via JasperSoft Studio - errors "Server URL is invalid" / "Connection reset"
- Jaspersoft Studio client fails to connect to Jaspersoft reporting server URL in Clarity SaaS (Related to Firewall issues)
- Jaspersoft does not start - Errors: "HTTP 404" / "Cannot open connection" - After recent DNS / Network changes
- Jaspersoft reports fail with TCP/IP connection failure - Error mentions: The TCP/IP connection to the host cw-001526, port 1433 has failed
- Secured (https) connection not working in Jaspersoft server - Error 503 in Clarity (Load Balancer configuration related)
- Jaspersoft Studio cannot save the Proxy configuration authentication (VPN related)
How tos/Questions:
Additional Information
Feedback
Yes
No
Powered by
