nelson.patino

I am creating a domain from a stored procedure using the statement: exect usp_aaa But when I execute it, it tells me: The query is not valid. A derived table query must start by SELECT and contain at least 4 words.

Good day, Currently I have installed jaspersoft 6.4.3 but it is very slow, I would like to know what options I can configure to improve the performance of the application. - How could the optimization of the execution of SQL queries improve, what options could enable - What options should I configure in the tomcat set JAVA_OPTS=%JAVA_OPTS% -Xms4096m -Xmx6144m -XX:PermSize=32m set JAVA_OPTS=%JAVA_OPTS% -XX:MaxPermSize=2048m -Xss2m -XX:+UseConcMarkSweepGC

Whenever you specify colors in the "Color Palette" for the HTML5 chart, then all colors will be replaced by black color. The issue is the same whatever HTML5 Chart you choose and appears as well on the Jasper Report Server when you publish the report. You can reproduce this issue easily by just changing or removing one color in the Color Palette of the chart.

Hello, I would like to know how to do so in the empty fields looks 0 (zero) in Jasperserver. I tryed the follow options: 1. IF(IsNull("ref_num"), '0', "ref_num") 2. IF("ref_num"=='', '0', "ref_num") But it still does not show the number 0 (zero)

Good day, I appreciate your collaboration indicating how I can do the following chart (html5) because it is required to grouping the subcategories by service as shown in the following image:

Good day, Could you please tell me how to adjust the size of the sheet in jasperserver, currently the sheet has a size of 5000x2000 pixels and requires it to be more than 7000x2000 pixels

No, there are no sub-reports. How could I validate the error with the parameters?

Hi Hozawa, When I delete the "Created Between" filter, I continue to generate the error: Error message Error filling report Error tracking com.jaspersoft.jasperserver.api.JSException: Failed to populate the report Arguments: in com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl $ FillResultListener.reportFillError (EngineServiceImpl.java:1345) in net.sf .jasperreports .engine.fill.BaseFillHandle.notifyError (BaseFillHandle.java:216) in net.sf.jasperreports.engine.fill.BaseFillHandle $ ReportFill.run (BaseFillHandle.java:138) in com.jaspersoft.jasperserver.api.engine .jasperreports .service.impl.EngineServiceImpl $ SynchronousExecutor.execute (EngineServiceImpl.java:924) 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:880) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport (EngineServiceImpl.java:1829) on com.jaspersoft .jasperserver .api.engine.jasperreports.se rvice.impl.EngineServiceImpl $ ReportFill.runWithDataSource (EngineServiceImpl.java:1169) in com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl $ ReportFill.runReport (EngineServiceImpl.java:1051) in com.jaspersoft. jasperserver.api.engine .jasperreports.service.impl.EngineServiceImpl $ ReportRunnable.run (EngineServiceImpl.java:946) in java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142) in java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor .java: 617) in java.lang.Thread.run (Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: java.lang.RuntimeException: exception initting subfilters in com. jaspersoft.ji.adhoc .strategy.StrategyAwareDomainQueryExecuter.createDatasource (StrategyAwareDomainQueryExecuter.java:167) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource (JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill. JRFillDataset.initDatasource (JRFillData set .java: 696) at net.sf.jasperreports.engine.fill.Ba seReportFiller.setParameters (BaseReportFiller.java:437) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java:548) at net.sf.jasperreports.engine.fill.BaseFillHandle $ ReportFill.run (BaseFillHandle. java: 123) ... 10 more Caused by: java.lang.RuntimeException: exception initting subfilters in com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getInitialSubFilterList (DomainDataStrategy.java:629) at com.jaspersoft.ji.adhoc .strategy.BaseDataStrategy.initSubFilterList (BaseDataStrategy.java:440) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getBaseQueryDataSet (DomainDataStrategy.java:145) at com.jaspersoft.ji.adhoc.strategy.DomainQueryDataStrategy.getBaseQueryDataSet (DomainQueryDataStrategy .java: 38) in com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery (CommonDomainDataStrategy.java:715) in com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery (CommonDomainDataStrategy.java:660) in com. jaspersoft.ji.adhoc.strategy.CommonDomainDataStrateg and.getWorkingDataSet (CommonDomainDataStrategy.java:1211) in com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet (CommonDomainDataStrategy.java:1199) in com.jaspersoft.ji.adhoc.strategy .StrategyAwareDomainQueryExecuter.createDatasource (StrategyAwareDomainQueryExecuter.java: 158) ... 15 more Caused By: com.jaspersoft.commons.dataset.expr.DomELParsingException in com.jaspersoft.commons.dataset.expr.BroadErrorStrategy.reportError (BroadErrorStrategy.java:33 ) at com.jaspersoft.commons.dataset .expr.DataSetExpressionParser.inRHS (DataSetExpressionParser.java:762) at com.jaspersoft.commons.dataset.expr.DataSetExpressionParser.comparisonExpr (DataSetExpressionParser.java:593) at com.jaspersoft.commons. dataset.expr.DataSetExpressionParser.notExpr (DataSetExpressionParser .java: 499) at com.jaspersoft.commons.dataset.expr.DataSetExpressionParser.andExpr (DataSetExpressionParser.java:423) at com.jaspersoft.commons.dat aset.expr.DataSetExpressionParser.orExpr (DataSetExpressionParser.ja va: 353) at com.jaspersoft.commons.dataset.expr.DataSetExpressionParser.booleanExpr (DataSetExpressionParser.java:298) at com.jaspersoft.commons.dataset.expr.ExpressionEvaluator.getUndefinedReferences (ExpressionEvaluator.java:674) in com.jaspersoft .ji.adhoc.strategy.DomainDataStrategy.getInitialSubFilterList (DomainDataStrategy.java:561) ... more Error message net.sf.jasperreports.engine.JRException: java.lang.RuntimeException: exception initting subfilters Error tracking net.sf.jasperreports.engine.JRException: java.lang.RuntimeException: exception initting subfilters in com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource (StrategyAwareDomainQueryExecuter.java:167) in net.sf.jasperreports.engine.fill

Good day, Perform a report build in JasperStudio and create two "Start Date and End Date" filters, then export it to JasperServer, but when you run it, a third filter that never creates "Created Between" will appear, which is mandatory, The error message after running the report is net.sf.jasperrreports.engine.JRException: java.lang.RuntimeException: exception initting subfilters net.sf.jasperrreports.engine.JRException: java.lang.RuntimeException: exception initting subfilters at com.jaspersoft.ji.adhoc.strategyAwareDomainQueryExcecuter.createDatasource(StrategyAwareDomainQueryExcetuter.java:167)