[How to check the first record of a page (Nth page) not from first page]

I need to check the first record of a any page (not from first page) of my report which consists more number of pages. Regardless of page number.. Please advise.

 

Thanks in advance, 

Maduraipandian Manivel. 

 

[Need to insert a empty row but not as a first row of a page]

I need to insert a empty row to break a group of records in the report but it should not appear when starting the report.

Now it shows as below,

(this row should be removed)
India
Tamilnadu
kerala
Bihar
Maharastra
United kingdom
london
Manchestor

I need as below,

India
Tamilnadu
Kerala
Bihar
Maharastra
United Kingdom
London
Manchestor

 

Currently i am created a group header but in some records empty rows displayes on starting of the page. Please help me.

Thanks in advance,

Maduraipandian Manivel

 

 

 

[Getting null pointer exception when running the Jasper report]

I am getting "java.lang.NullPointerException" in Jasper Studio 6.3.2 when trying to run jasper report which is developed in Jasper studio 6.6.0.

Please guide me on this issue if anyother things do i need to check to resolve this issue.

Thnaks in advance,

Maduraipandian Manivel.

************* Error Details****************

 

net.sf.jasperreports.engine.JRException: java.lang.NullPointerException
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:548)
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:523)
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:404)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.lang.NullPointerException
    at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.getInternalQE(WebServiceQueryExecuter.java:244)
    at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.close(WebServiceQueryExecuter.java:201)
    at net.sf.jasperreports.engine.fill.JRFillDataset.closeQueryExecuter(JRFillDataset.java:1322)
    at net.sf.jasperreports.engine.fill.JRFillDataset.closeDatasource(JRFillDataset.java:1303)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:608)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)
    at java.lang.Thread.run(Thread.java:745)

 

 

[Jasperserver has any user limits?]

Does Jasper supports only "N" number of users?

Please help. 

Thanks in advance, 

Maduraipandian Manivel. 

 

[How to enable SSL in Jasper Server, x.509 certificate setup]

Thanks for the reply Rodrigo, 

Yes I am talking about first one, need enable in tomcat in azure Rhel Linux.

Could you please guide me from initial stage step by step. 

Thanks again in advance,

Maduraipandian Manivel  

[How to enable SSL in Jasper Server, x.509 certificate setup]

I need to enable SSL in Jasper Server, also need to explore x.509 certificate setup.

Help me. 

 

Thanks in advance, 

Maduraipandian Manivel.

[User request details - Jasper server log]

I am planning to create internal load balancer in azure cloud VM

Question: Is it possible to capture user request details in Jasper Server log? I want to check that user requests are split across Jasper servers in QA.

Thanks in advance , 

Maduraipandian Manivel. 

[Jasper Server - Top Menu - Is this possible to hide the top menu ?]

I need to hide the top menu and repository folder in jasper server.

We may not be allowed to show the top menu . 

is it possible to hide the top menu and repository folders if yes please provide the procedure to do same.

Attached screenshot for the reference.

Please advise.

Thanks in advance,

Maduraipandian Manivel.

[Error running report with json data source "Error filling report"]

The same report works fine with another server which is installed in local where as my server is installed in azure cloud . Is this could be something related to proxy or firewall problem ?

Please advise.

Thanks in advance,

Maduraipandian Manivel.

 

[Error running report with json data source "Error filling report"]

Thanks hozawa, 

I have checked the above mentioned URL, but it didnt help me.

I have enabled the JSON data source and created adapter with required information (blob url).

Please help me.

Thanks again in advance,

Maduraipandian Manivel.

[Error when sharing a same db with two servers, server1 gets down - Error creating bean with name 'themeSource' defined in ServletContext resource]

So you meant ..  In this case do I need to install 2 repository databases?

As of now,  server1 having bundled postgresql dB and tomcat, server2 having only tomcat.

Please advice.

[Error when sharing a same db with two servers, server1 gets down - Error creating bean with name 'themeSource' defined in ServletContext resource]

Thanks hozawa. ..!!!

My plan is to use dedicated repository DB sharing all other servers. Is this possible?? And why this is not working.. What I need to do to resolve this issue?

Please advise 

Thanks in advance , 

Maduraipandian Manivel

[Error running report with json data source "Error filling report"]

When running a report connected to json data source (blob storage), getting error as below.

Please help me on this issue.

Environment:

Jasper server 7.1.1 Enterprise edition

Thanks in advance,

Maduraipandian Manivel.

=============Error log ===================

Error MessageError filling reportError Tracecom.jaspersoft.jasperserver.api.JSException: Error filling report Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1336) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:216) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:138) 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: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new net.sf.jasperreports.engine.data.JsonDataSource("https://morspoc.blob.core.windows.net/asset-and-accruals/json30kV2.json","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.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1183) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1135) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:271) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:106) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:607) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) ... 10 more Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: https://morspoc.blob.core.windows.net/asset-and-accruals/json30kV2.json. at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:116) at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:45) at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:149) at net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:190) at net.sf.jasperreports.repo.RepositoryUtil.getInputStreamFromLocation(RepositoryUtil.java:167) at net.sf.jasperreports.engine.util.JsonUtil.parseJson(JsonUtil.java:166) at net.sf.jasperreports.engine.data.JsonDataSource.<init>(JsonDataSource.java:139) at net.sf.jasperreports.engine.data.JsonDataSource.<init>(JsonDataSource.java:147) at ReadAzureBlobPoC_1557500057302_637138.evaluate(ReadAzureBlobPoC_1557500057302_637138:183) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:305) ... 23 more Caused by: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: https://morspoc.blob.core.windows.net/asset-and-accruals/json30kV2.json. at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:343) at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:99) ... 32 more Caused 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.getInputStream0(HttpURLConnection.java:1564) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263) at java.net.URL.openStream(URL.java:1045) at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:339) ... 33 more Caused by: 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.validator.PKIXValidator.doBuild(PKIXValidator.java:397) at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:302) at sun.security.validator.Validator.validate(Validator.java:260) at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:324) at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:229) at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:124) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496) ... 47 more Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141) at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126) at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280) at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:392) ... 53 more[/code]

 

 

 

[Error when sharing a same db with two servers, server1 gets down - Error creating bean with name 'themeSource' defined in ServletContext resource]

Scenario: Trying to design a cluster - Sharing repository db from Server1(VM1) to Server2 (VM2) - Linux(Azure cloud) - Server1 got down and Server2 is up and running using db from Server1.

Server1 : (Jasper server 7.1.1 Enterprise edition - tomcat 8.5.34)

This server is installed using installer method (bundled postgresql and bundled tomcat)

Server2: (Jasper server 7.1.1 Enterprise edition - tomcat 8.5.34)

This server is installed using war file distribution method (Sharing DB from server1 and separate tomcat installed)

After installing Server2, the Server1 gets down but Server2 is up and running.

Please help me on this issue.

=============== Error Log ===============================================================

2019-05-09 11:19:47,198 ERROR ContextLoader,localhost-startStop-1:331 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeSource' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'themeCache' while setting bean property 'themeCache'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeCache' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'unsecureRepositoryService' while setting bean property 'repositoryService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'auditContext' while setting bean property 'auditContext'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auditContext' defined in ServletContext resource [/WEB-INF/applicationContext-audit.xml]: Cannot resolve reference to bean 'mtLoggingContextProvider' while setting bean property 'loggingContextProvider'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtLoggingContextProvider' defined in ServletContext resource [/WEB-INF/applicationContext-multiTenancy.xml]: Cannot resolve reference to bean 'loggingEventsService' while setting bean property 'loggingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'loggingEventsService': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'routingMapPro' defined in ServletContext resource [/WEB-INF/applicationContext-audit.xml]: Cannot resolve reference to bean 'accessService' while setting constructor argument with key [TypedStringValue: value [com.jaspersoft.jasperserver.api.logging.access.domain.AccessEvent], target type [class java.lang.Class]]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'accessService' defined in ServletContext resource [/WEB-INF/applicationContext-events-logging.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'driverDeleteListener' while setting bean property 'eventListeners' with key [TypedStringValue: value [post-commit-delete], target type [null]]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configurationBean': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.springframework.context.MessageSource com.jaspersoft.jasperserver.war.common.ConfigurationBean.messages; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [com.jaspersoft.jrs.data.webservice.WebServiceDataSourceDefinition] for bean with name 'webServiceDataSource' defined in ServletContext resource [/WEB-INF/applicationContext-WebServiceDataSource.xml]; nested exception is java.lang.ClassNotFoundException: com.jaspersoft.jrs.data.webservice.WebServiceDataSourceDefinition        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1131)        at org.springframework.ui.context.support.UiApplicationContextUtils.initThemeSource(UiApplicationContextUtils.java:58)        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.onRefresh(AbstractRefreshableWebApplicationContext.java:195)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:476)        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)        at java.util.concurrent.FutureTask.run(FutureTask.java:266)        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)@                                                                                                                                                            @                                                                                                                                                            @                                                                                                                                                            @                                                                                                                                                            @                                                                                                                                                            [/code]

 

 

[Where I can get .bin.zip file for enterprise edition to install Jasper server using war file distribution method]

Yes, I got the file as you guided Paul.

Thank you so much Paul and Hozawa !!! :) 

 

[Unable to install the jasper server with pointing to the existing database using installer]

When I trying to install jasper server with pointing to the existing data base, it shows the below message...

PostgreSQL Installation

Please select the PostgreSQL configuration you want to use

[1] I want to use the bundled PostgreSQL database
[2] I want to use an existing PostgreSQL database
Please choose an option [1] : 2

Setup will try to install new JasperReports Server databases and will overwrite any existing duplicates.  Do you want to continue?  Selecting 'No' will exit the installer. [Y/n]:

So how do I install the jasper server pointing to another data base using installer.

Please help me on this problem.

Thanks in advance,

Maduraipandian Manivel.

 

[Where I can get .bin.zip file for enterprise edition to install Jasper server using war file distribution method]

I need to install Jasper server enterprise edition using war file distribution method. 

For that I need JasperServer.bin.zip file for enterprise edition

Where I can get this. 

Could you please help me with this problem. 

Note. It's available for community edition. 

I am planning design a cluster in azure cloud instance. 

 

Thanks in advance, 

Maduraipandian Manivel. 

 

 

 

[Running report using json data source throws Error "An error occurred while creating the connection. Try again"]

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]

 

[How to read flat file from azure blob using json data source in Jasper Server]

I am using Jasper server version 7.1.1 Enterprise edition installed in redhat Linux 7.6 in azure cloud .. Also enabled json data source in applicationContext-Remote-services.xml file 

[How to read flat file from azure blob using json data source in Jasper Server]

What is the procedure to access json file stored in azure blob

[How to read flat file from azure blob using json data source in Jasper Server]

Hi Team, 

 

I need to use flat file as input data source to the Jasper template, the flat file which is stored in azure blob, the flat file consisting api. 

So how to read flat file stored in azure blob using json data source in Jasper Server. 

 

Thanks in advance, 

Maduraipandian Manivel. 

 

[How to implement single sign on - Jasper server 7.1.1 Enterprise edition - azure cloud redhat 7.6]

Sure. Thank you Hozawa. 

[How to implement single sign on - Jasper server 7.1.1 Enterprise edition - azure cloud redhat 7.6]

Hi Team, 

 

I need to configure single sign on with my Jasper server 7.1.1 Enterprise edition which is installed in azure cloud Linux Rhel 7.6.

 

What is the procedure to implement single sign on configuration in azure cloud Jasper server  

 

What are all the prerequisite needed. 

 

Could you please provide me the detailed complete information, would be helpful. 

 

Thanks in advance, 

Maduraipandian Manivel. 

 

 

[Connection timed out and could not connect to SMTP host - Email notification - SMTP configuration]

Okay Thank you hozawa.!

[Connection timed out and could not connect to SMTP host - Email notification - SMTP configuration]

Hozawa,  I tried this using cat < /dev/tcp/smtpe.bnymellon.net/25, there also

Getting connection timed out error.  So what I need to do now. Please help