maduraipandian.manivel Posted May 2, 2019 Share Posted May 2, 2019 Hi Team,Have create JSON data source using the blob file url (where json file is stored in blob storage) and query is data and uploaded an jrxml report and connected the json data source.Now running the report throws error "An error occurred while creating the connection. Try again"Could you please help me on this issue. Thanks in advance,Maduraipandian Manivel. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.3.2.final using JasperReports Library version 6.3.2 --><!-- 2019-05-01T18:25:54 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="MainReportPoC2" pageWidth="595" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="cb680906-7050-4fae-8e60-e81b7c5e8184"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <property name="ireport.jasperserver.url" value="http://10.171.23.7:8080/jasperserver-pro/"/> <property name="ireport.jasperserver.user" value="superuser"/> <property name="ireport.jasperserver.reportUnit" value="/organizations/organization_1/reports/MainReportPoC2"/> <queryString language="SQL"> <![CDATA[data]]> </queryString> <summary> <band height="25"> <subreport> <reportElement x="0" y="0" width="28" height="25" uuid="a84dd20f-b176-410a-9120-7f328bd2a7bd"/> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JsonDataSource("https://morspoc.blob.core.windows.net/asset-and-accruals/asset-and-accruals-taxlots.json","data")]]></dataSourceExpression> <subreportExpression><![CDATA["sub_report_pdf.jasper"]]></subreportExpression> </subreport> </band> </summary></jasperReport>[/code]======================== Error Log =========================================================2019-05-02 02:24:43,987 ERROR AsyncJasperPrintAccessor,pool-6-thread-16:321 - Error during report executionnet.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new net.sf.jasperreports.engine.data.JsonDataSource(new URL("https://morspoc.blob.core.windows.net/xxxxx/xxxxxxxx.json").openStream(),"data") at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:287) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:319) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:616) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:584) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1164) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:463) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:354) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:383) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:506) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillNoData(JRVerticalFiller.java:2604) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:178) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:607) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:961) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1840) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1159) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1088) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:983) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: java.net.ConnectException: Connection timed out (Connection timed out) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:673) at sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173) at sun.net.NetworkClient.doConnect(NetworkClient.java:180) at sun.net.www.http.HttpClient.openServer(HttpClient.java:463) at sun.net.www.http.HttpClient.openServer(HttpClient.java:558) at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264) at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191) at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)[/code] Link to comment Share on other sites More sharing options...
hozawa Posted May 8, 2019 Share Posted May 8, 2019 JSON needs to be a String. You're probably fetching it as a binary stream. Link to comment Share on other sites More sharing options...
sushobhan.b Posted December 11, 2019 Share Posted December 11, 2019 Hi Manivel, if that json url has username and password, how to login using url?any idea is acceptable. 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