maduraipandian.manivel

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.

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

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)

Does Jasper supports only "N" number of users? Please help. Thanks in advance, Maduraipandian Manivel.

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

I need to enable SSL in Jasper Server, also need to explore x.509 certificate setup. Help me. Thanks in advance, Maduraipandian Manivel.

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.

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.

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.

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.

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.

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

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]

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]

Yes, I got the file as you guided Paul. Thank you so much Paul and Hozawa !!! :)