victor.jonathan Posted October 8, 2019 Share Posted October 8, 2019 I have just downloaded and installe JaspeSoft Studio 7.1.0. How do I connect it to our SaaS JasperSoft Server. My understanding is that once I installed the studio I will then link it to the server but I never got to that step in my installation.Am I missing a step or something in my installation file? Link to comment Share on other sites More sharing options...
joseng62 Posted October 11, 2019 Share Posted October 11, 2019 Hi victor.jonathan. When in the jasperstudio. Look for the 'Repository' tab.If yo ucannot find it, in the studio top menu, select 'Window', look for 'Show View' amd then other. In the pop up, look for Repository Explorer. Ok so now you should have the 'Repository' tab. Select it and right click on Servers and select the 'create jasperreports server connection'Now you should be familiar with the normal stuff. i.e. URL etc. Not on Organization textbox : for community edition leave it blank for pro I cannot remember excatly, but it might be 'organization' and if you have other organization it might be 'organization/other_org_name' Hope this all helps. Good luck. Link to comment Share on other sites More sharing options...
victor.jonathan Posted October 28, 2019 Author Share Posted October 28, 2019 Thanks Joseng62. I have actually being able to setup the connection to the server except I am still waiting to resolve some issues with our SSL certificates for direct connectivity.See error here:Error from JASPERSOFT when testing the Data Adapter connection to CA PPM Development: net.sf.jasperreports.engine.JRException: java.sql.SQLException: Error Occured.Please check Data Adapter configuration values. at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:130) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:155) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51) at java.lang.Thread.run(Thread.java:748)Caused by: java.sql.SQLException: Error Occured.Please check Data Adapter configuration values. at com.jaspersoft.web.rest.JasperRestConnector.validateAdapterConfiguration(JasperRestConnector.java:616) at com.jaspersoft.jdbc.driver.JasperDriver.connect(JasperDriver.java:62) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:168) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128) ... 4 moreCaused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1514) at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216) at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1026) at sun.security.ssl.Handshaker.process_record(Handshaker.java:961) at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1072) at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385) at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413) at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397) at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:559) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185) at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1334) at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1309) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:259) at com.jaspersoft.web.rest.JasperRestConnector.validateAdapterConfiguration(JasperRestConnector Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now