Jump to content
We've recently updated our Privacy Statement, available here ×

Jivan Phadtare

Jaspersoft Staff
 View Profile  See their activity

  • Posts

    50

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by Jivan Phadtare

  1. Jivan Phadtare
    Issue : While creating a domain based on Postgres Table with declarative partition, not able to select the main as it is not listed the list of tables, only partitions of the table are listed. (Please see attached doc : "Domain_partition_table.docx" ) Cause : We found that the issue is with PostgreSQL jar. In JasperServer 7.5 we were using postgresql-42.2.5 where there is no issue. In 7.9 and above, we are using a later version of the jar (42.2.16) where the issue is seen. Resolution : To make this working, request customer to use attached older(postgresql-42.2.5.jar) jar file and place that jar file at "<Tomcat_Installed_Path>lib" then restart the server. domain_partition_table.docx postgresql-42.2.5.jar
  2. Jivan Phadtare
    Hello, To print non-English characters in exported pdf file you have to add custom font for non-English characters which are in json. To gain a comprehensive understanding for incorporating custom fonts into the exported PDF file, we recommend referring to the following resources: https://community.jaspersoft.com/wiki/custom-font-font-extension https://community.jaspersoft.com/wiki/embedding-and-exporting-different-foreign-languages-fonts-hindi-japanese-korean-russian-and Hope this will find you useful !!
  3. Jivan Phadtare
    Hello, Could you please check if you have java installed on machine where you are installing the software. also, please make sure java version is compatible as per platform support guide document. Check with java 11 as well.
  4. Jivan Phadtare
    Hello, Kindly try with below and check it. 1. Create a variable: First, create a variable in your main report to track whether the subreport has been printed on the current page. Let's call this variable "subreportPrinted" and set its initial value to false. The variable will be used to determine the visibility of the Group Header and Column Footer. 2. Update the subreport: In the subreport, create a variable to set the "subreportPrinted" variable in the main report to true when the subreport is printed. Make sure this variable is evaluated on each page. 3. Configure the Group Header: In the Group Header band properties, set the "Print When Expression" to $V{subreportPrinted} == false. This will hide the Group Header when the subreport has been printed. 4. Configure the Column Footer: In the Column Footer band properties, set the "Print When Expression" to $V{subreportPrinted} == false. This will hide the Column Footer when the subreport has been printed. Hope this will help you to tackle your problem.
  5. Jivan Phadtare
    Looking at the error message it is showing caused by "Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist" Kindly make sure in your oracle databae "DIL_LIVE_ORDERS_VIEW" this view is present. It's possible that the table or view you are referencing does not exist in the database. Verify that the table or view exists by checking the database Apart from this also check on below possibilities : Incorrect Table or View Name Missing Schema or Owner Name Insufficient Privileges : Check if the user executing the query has the necessary privileges to access the table or view. Ensure that the user has been granted the appropriate
  6. Jivan Phadtare
    Hello, Kindly try below - Go to detail band properties and set the "Split Type " to "Prevent". It looks like your issue is similar to below community URL https://community.jaspersoft.com/questions/532951/table-row-splitted-page-break-how-fix Hope this will help you !!
  7. Jivan Phadtare
    Hello, Using parameter you can pass main dataset to subdataset, Please refer below community URL for details. https://community.jaspersoft.com/questions/823038/passing-main-parameter-sub-datasets-jasperstudio For Dataset and subdataset details, please refer below URL : https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v640/datasets-and-subdatasets Hope this will helps you !!
  8. Jivan Phadtare
    Customer is getting below error during multiple ad hoc view report run. Error : ------------------------ 2023-06-08T11:44:04,399 ERROR JsonView,http-nio-8080-exec-37:41 - IO Exception occurred when trying to write model to output stream org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:351) at org.apache.catalina.connector.OutputBuffer.flushByteBuffer(OutputBuffer.java:784) at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:687) at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:386) at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:364) at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96) at org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.write(OnCommittedResponseWrapper.java:638) at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2171) at com.fasterxml.jackson.core.json.UTF8JsonGenerator.writeRaw(UTF8JsonGenerator.java:689) at com.fasterxml.jackson.core.json.UTF8JsonGenerator.writeRaw(UTF8JsonGenerator.java:661) at com.fasterxml.jackson.core.base.GeneratorBase.writeRawValue(GeneratorBase.java:328) at com.jaspersoft.ji.adhoc.converter.AdhocStreamingBaseConverter.write(AdhocStreamingBaseConverter.java:112) at com.jaspersoft.ji.adhoc.converter.AdhocTableToJsonStreamingConverter.write(AdhocTableToJsonStreamingConverter.java:48) at com.jaspersoft.ji.adhoc.converter.AdhocTableToJsonStreamingConverter.write(AdhocTableToJsonStreamingConverter.java:21) at com.jaspersoft.ji.adhoc.JsonView.renderMergedOutputModel(JsonView.java:36) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:316) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1406) at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1150) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) at javax.servlet.http.HttpServlet.service(HttpServlet.java:529) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:74) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:42) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.api.security.csrf.CorsAuthRedirectionFilter.doFilter(CorsAuthRedirectionFilter.java:50) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:112) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:166) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:236) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:223) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:217) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:96) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:85) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:236) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:163) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:72) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:155) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:66) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.jasperserver.war.SessionXssNonceSetterFilter.doFilter(SessionXssNonceSetterFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.springframework.web.filter.ForwardedHeaderFilter.doFilterInternal(ForwardedHeaderFilter.java:156) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:596) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.io.IOException: Broken pipe at java.base/sun.nio.ch.FileDispatcherImpl.write0(Native Method) at java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) at java.base/sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:113) at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:79) at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:50) at java.base/sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:462) at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:136) at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1431) at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:775) at org.apache.tomcat.util.net.SocketWrapperBase.writeBlocking(SocketWrapperBase.java:600) at org.apache.tomcat.util.net.SocketWrapperBase.write(SocketWrapperBase.java:544) at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.doWrite(Http11OutputBuffer.java:540) at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:112) at org.apache.coyote.http11.Http11OutputBuffer.doWrite(Http11OutputBuffer.java:193) at org.apache.coyote.Response.doWrite(Response.java:603) at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:338) ... 175 more ------------------------- Resolution Steps : There are multiple reasons why get "Broken pipe" error but in most of the cases this error is from network context. Below command text can be carried out to narrow down the cause of error. 1) Verify property "Ad Hoc Query Timeout (seconds)" by navigating to Manage --> Server setting --> Ad hoc setting. Make sure timeout value is mentioned propertly. 2) Do clean restart of tomcat by clearing the tomcat cache tomcatworkCatalinalocalhostjasperserver-pro -->clear content from this folder <tomcat>/temp --> Rename this folder so that at the time of restart tomcat will re-create the new one. If required - will rename the below folder as well. Tomcat will re-create during restart. <tomcat>/work 3) Make sure JDBC/JNDI connection settings of datasource on which domain is build. 4) Verify the load balancer/ proxy gateway server timeout setting and gateway proxy server log. In this case, the issue was, timeout configured at load balancer end was at 1 mins. Increasing it to 10 mins resolved the issue. 5) Test accessing ad hoc view by-passing proxy load balancer server. 6) In lower environment, try to reproduce the behaviour and see if there also persist the same issue. 7) To capture more granular error message, put the below loggers into debug mode. Hoc AJAX requests adhocAjaxRequests Ad Hoc WorkingDataSet com.jaspersoft.commons.datarator.WorkingDataSet Ad Hoc/MDX query result as text com.jaspersoft.ji.adhoc.strategy.MDXDataStrategy Generated MDX queries for Ad Hoc com.jaspersoft.ji.adhoc.mdx.MDXGenerator SQL query executer net.sf.jasperreports.engine.query.JRJdbcQueryExecuter Ad Hoc cache activity com.jaspersoft.commons.datarator.CachedData 8) Reproduce the issue and collect the HAR file and console error screenshot.
  9. Jivan Phadtare
    Hello, It looks like your requirement is more into SQl context how to write sql query to display specific portion of column than ireport design. You can use SQL string replace function to replace e.g. [{"trackables" : [{"code" : part of container column with space. You might need to use more such replace and concatinate SQL functions to write the query.
  10. Jivan Phadtare
    Hello, It looks like without changing locale, it's difficult to dynamically change the pattern used for formatting numbers. We found similar below community article where similar situation was encountered. https://community.jaspersoft.com/questions/518137/dynamic-double-pattern Might be this article help you however, we request you to log a feature request for your idea.
  11. Jivan Phadtare
    Hello, Looking at final caused by error message it seems that, connection is failed because authentication failure with error code 18. Kindly check connection string configured. Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 10.18.192.88:27021. The full response is {"operationTime": {"$timestamp": {"t": 1686039755, "i": 1}}, "ok": 0.0, "errmsg": "Authentication failed.", "code": 18, We tried to search over internet about this code and found some of the URL where similar error listed. Kindly have a look at below suggested resolution. https://howtodoinjava.com/mongodb/command-failed-with-error-18/ https://www.mongodb.com/community/forums/t/mongosecurityexception-exception-authenticating-mongocredential/106790 https://www.mongodb.com/community/forums/t/mongodb-replicaset-error-authenticationfailed-code-18/205762/4 Hope this will help you !!
  12. Jivan Phadtare
    Hello, Per error trace, it looks like isSplitTypePreventInhibited is called on null. Seems to happen when a table is located in a detail band and the cell of the table is overflowing, that is generating a page break. Found similar error on below community portal. https://community.jaspersoft.com/jasperreports-library/issues/10451 Hope this finds you useful !!
  13. Jivan Phadtare
    Issue : Customers are getting attached error ("JRS_8.2_install.docx") while installing bundled JRS version 8.2 Error : --------------- E:Jaspersoftjasperreports-server-8.2.0buildomatic>echo off ECHO is off. Script stderr: 17 was unexpected at this time. Error running E:Jaspersoftjasperreports-server-8.2.0/buildomatic/js-ant.bat import-minimal-pro: 17 was unexpected at this time. Problem running post-install step. Installation may not complete correctly Error running E:Jaspersoftjasperreports-server-8.2.0/buildomatic/js-ant.bat import-minimal-pro: 17 was unexpected at this time. [08:34:27] START: Installing Tomcat as a Windows service with name jasperreportsTomcat Installing Tomcat as a Windows service with name jasperreportsTomcat Executing E:Jaspersoftjasperreports-server-8.2.0apache-tomcatscriptsserviceinstall.bat INSTALL STOP Script exit code: 0 --------------- Resolution : 1) From your home directory (usually located at: C:Users<user_name>), kindly create a backup of the keystore files (.jrsks and .jrsksp) in a different folder. Once backed up, remove these keystore files from the home directory, as new keystore files will be generated during the installation process. 2) We can request for application server log file ad jasperserver.log file to make sure any helpful message might have capture in loggers. 3) As per the log error message it looks like JAVA version issue so please check on version of Java/jdk. Sometimes java is also not installed in that case it gives same error. If multiple JDK available then kindly only keep single JDK instance running and re-test the installation. jrs_8.2_install.docx
  14. Jivan Phadtare
    Issue : Constantly receiving below error when ReportExecution Job run. Error : ------------------------ 2023-05-24T12:00:59,994 DEBUG WebSocketServiceImpl,pool-20-thread-27:90 - Connecting to ws server ws://localhost:36458/devtools/browser/71f4f3a0-a2cf-4d1c-b5dd-9026533f6526 2023-05-24T12:01:00,015 WARN WebSocketServiceImpl,pool-20-thread-27:105 - Failed connecting to ws server ws://localhost:36458/devtools/browser/71f4f3a0-a2cf-4d1c-b5dd-9026533f6526... javax.websocket.DeploymentException: Handshake error. at org.glassfish.tyrus.client.ClientManager$3$1.run(ClientManager.java:679) . . Caused by: org.glassfish.tyrus.core.HandshakeException: Response code was not 101: 403. . . 2023-05-24T12:01:00,018 DEBUG ChromeInstance,pool-20-thread-27:98 - ending use of chrome instance 18 2023-05-24T12:01:00,018 ERROR BaseDashboardRenderer,pool-20-thread-27:82 - Error rendering dashboard net.sf.jasperreports.engine.JRRuntimeException: com.github.kklisura.cdt.services.exceptions.WebSocketServiceException: Failed connecting to ws server {} at net.sf.jasperreports.chrome.IsolatedPageCreator.getBrowserDevToolsService(IsolatedPageCreator.java:163) . . 2023-05-24T12:01:00,020 ERROR DashboardExecutionJob,JasperServerScheduler_Worker-1:213 - The dashboard export job for /reports/Bases_de_Datos/Replicas_Logs failed to execute. java.util.concurrent.ExecutionException: net.sf.jasperreports.engine.JRRuntimeException: com.github.kklisura.cdt.services.exceptions.WebSocketServiceException: Failed connecting to ws server {} . Caused by: net.sf.jasperreports.engine.JRRuntimeException: com.github.kklisura.cdt.services.exceptions.WebSocketServiceException: Failed connecting to ws server {} . at java.lang.Thread.run(Thread.java:748) Caused by: com.github.kklisura.cdt.services.exceptions.WebSocketServiceException: Failed connecting to ws server {} . Caused by: javax.websocket.DeploymentException: Handshake error. . Caused by: org.glassfish.tyrus.core.HandshakeException: Response code was not 101: 403. ------------------------ Resolution : 1) With below additonal loggers, try to collect the debug logs. Debug logger provides more granuler information about error. com.github.kklisura.cdt.services.impl = DEBUG com.github.kklisura.cdt.launch = DEBUG net.sf.jasperreports.chrome = DEBUG 2) Post chrome upgrade might get same error. By looking to the error, we could see below web socket connection failure error. It's failing to connect to the web socket server. connecting to ws server ws://localhost:36458/devtools/browser/71f4f3a0-a2cf-4d1c-b5dd-9026533f6526 This might be websocket port connection issue. Please check if there is any firewall restrictions on port. Kindly request administrator to make sure if this websocket port is open. "telnet localhost <port>" Using this command websocket port connectivity can be checked to see port is open or not. 3) This error might be related to chromium/chrom also. CHeck what version of chrom/chromium configured and make sure on whether recently chrom/chromium upgraded. Additionally, analyse below files to check more chrome properties configuration. ...webappsjasperserver-proWEB-INFjs.config.properties ...WEB-INFclassesjasperreports.properties In 'js.config.properties' file, check below properties : chrome.path=/bin/chromium-browser deploy.base.local.url=http://localhost:8080/jasperserver-pro In 'jasperreports.properties' file, check below properties : net.sf.jasperreports.chrome.argument.no-sandbox=true net.sf.jasperreports.chrome.argument.ignore-certificate-errors=true
  15. Jivan Phadtare
    Please check the java jdk version. We tried to JDK 11 and didn't face any issue. We request you to try with JDK 11 version.
  16. Jivan Phadtare
    Hello, Not sure if this is becaaus of memory but you can verify max memory parameter configured in file "Jaspersoft Studio Professional.ini". This file is located at studio installed path. (C:Program Files<studio_installed_Path>Jaspersoft Studio Professional.ini) and make sure max heap configured more than 2GB like below. -Xmx2048m It is good to check for studio log while launching studio. You can navigate to help --> TIBCO Jaspersoft® Studio Professional --> Installation Details --> click on 'Configuration' log and check the logs to see any possible error logged in log file. Hope this will help you !!
  17. Jivan Phadtare
    Hello, What is the exact fail messages. When a script fails, it should output a reason for the failure in installation log file. What is the exact steps you've taken? It seems your issue might be simillar with below URL. https://community.jaspersoft.com/jasperreports-server/issues/13956 Kindly refer to this URL. Hope this will find you useful.
  18. Jivan Phadtare
    Hello, Please try to use latest studio 8.x.x version and give try adding wrapper and check if it works in Jaspersoft studio. Without wrapper added - What error you see in jasperserver.log file on JasperReports Server. Looking at error log might help us to narrow down this.
  19. Jivan Phadtare
    Hello, Not sure what exact error you are getting while exporitng into .xlsx format. But seems that for .xlsx format you need to change the formula. The formula for .xls and .xlsx is slightly differs that why for .xlsx format you might be getting blank. Try using & instead of & in formula to export in .xlsx format. For more details you can refer to below article. https://community.jaspersoft.com/wiki/exporting-crosstab-formula-sum-excel Hope this will help you.
  20. Jivan Phadtare
    Hello, From error it looks like there is error while evaluating parameter $P{memberid}. Not sure what expression you configured for this parameter but seems that you have an issues with your expression. We kindly request you test the report in jasperstudio before deploying to jaspersever.
  21. Jivan Phadtare
    Hello, Reports variables are special objects build on top of a report expression. They can perform various calculation based on corresponding expression. So it seems that, it's difficult to have a variable in the report that is not controlled by the report engine. Hope this will helpful !!
  22. Jivan Phadtare
    Hello, By looking to below error it seems that, parameter $P{SUBREPORT_DIR} is getting null value as a path for reports. Somehow correct path of report is not getting passed in main report parameter $P{SUBREPORT_DIR}. net.sf.jasperreports.engine.JRException: Resource not found at: nullsub_subreport.jasper. Please check how directory name was passed to parameter $P{SUBREPORT_DIR}. also first try to run the subreport indivisualy to make sure it's working fine and then try to embed in main report.
  23. Jivan Phadtare
    Hello, while importing the package n jrxml report, we could see it was mentioned as wrong like cp, kindly correct and republish report. <import value="cp,.av.jasper.GetExpressionFromStringScriptlet"/> Also, you can try editing WEB-INF/applicationContext-adhoc.xml and add the following property somewhere inside the adhocEngineService bean: <property name="reportUnitClassLoadingEnabled" value="true"/> Reference : https://community.tibco.com/s/article/jasperserver-unable-load-scriplet-jars-repository Hope this will find you useful.
  24. Jivan Phadtare
    Hello, Seems like you are looking to represent number on dashboard using dashlates. If so then while creating dashbaord you can select Text filed (shown in attachment "Dashboard_1.PNG") as a dashlate in dashboard. Alternatively you can have report or ad hoc view designed to represent number and then use that report/as hoc view as dashlate while creating dashboard. Hope this helps you.
  25. Jivan Phadtare
    Hello, It looks like you are looking for page size configuration while printing. You can do so in jaspersoft studio at bottom right corner pannel. I have attached the screenshot (Studio_1.PNG, Studio_2.PNG) For more details you can refer to below URL of studio user guide document. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v8/getting-started-jaspersoft-studio Hope this will find you useful.
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore