greg.pigate

Using Jasper Studio 6.3.1 Usinger Jasper Server Product Version: 6.3.0 Build: 20160621_1840 I have a very simple query that returns a code and description. This has been created as an input control to return a result set showing in the parameter window when the report is launched such as the below. The parameter Name is ParameterCode Code | Description I have the Studio report set up to take in the ParameterCode parameter and use that in a where clause such as AND $X(IN, tableValue, ParameterCode) The parameter is set up as a java.util.Collection for the class and a nested type name as java.lang.String. The ParameterCode values are all VARCHAR2. This is running against an oracle database. I am getting a run time java exception below and would like to know if anyone else has gotten this to work or if you can guide me in the right direction. Thanks. Error MessageError filling report Error Tracecom.jaspersoft.jasperserver.api.JSException: Error filling report Arguments:at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1345)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: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)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: barpdnd.at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:344)at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:169)at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:114)at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)at net.sf.jasperreports.engine.fill.BaseReportFiller.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.sql.SQLSyntaxErrorException: ORA-00911: invalid characterat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310) ... 17 more[/code]

I have found that to be the case on more than one occassion. Did you as you recommended, not sure why I did not think of that. Very helpful information returned. Parameter Information Returned as <parameters> <parameterValues> <entry> <key>To_Date</key> <value xsi:type="xs:dateTime" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2016-04-13T00:00:00-04:00</value> </entry> <entry> <key>From_Date</key> <value xsi:type="xs:dateTime" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2015-01-01T00:00:00-05:00</value> </entry> <entry> <key>REPORT_TIME_ZONE</key> <value xsi:type="xs:string" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">America/New_York</value> </entry> </parameterValues></parameters> Modified my parameters to be (notice I changed datetime to date and changed the value to match. This is because the first schedule errored out with unable to cast java.util.date to java.sql.date)<parameters> <parameterValues> <entry> <key>To_Date</key> <value xsi:type="xs:date" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2016-04-13</value> </entry> <entry> <key>From_Date</key> <value xsi:type="xs:date" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2015-01-01</value> </entry> <entry> <key>REPORT_TIME_ZONE</key> <value xsi:type="xs:string" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">America/New_York</value> </entry> </parameterValues></parameters> After running with this set, I received the same error. See below. Still need to be able to pass java.sql.date. Any recommendations Message: Job: GSP2 (ID: 22079) Report unit: /reports/BannerBadDebt Quartz Job: ReportJobs.job_22079 Quartz Trigger: ReportJobs.trigger_22076_0 Error Message: The report was not completed. An error occurred while executing it. Exceptions: com.jaspersoft.jasperserver.api.JSException: Error filling report Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1294) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:922) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1847) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousReportFiller.fillReport(EngineServiceImpl.java:826) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1774) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1118) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1047) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:944) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:922) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:639) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReportUnitRequest(EngineServiceImpl.java:1980) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:67) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:525) at sun.reflect.GeneratedMethodAccessor1235.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80) at com.jaspersoft.ji.license.LicenseCheckAspect.runReport(LicenseCheckAspect.java:139) at sun.reflect.GeneratedMethodAccessor1234.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy62.execute(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.runReport(ReportExecutionJob.java:779) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:746) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:138) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:643) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:482) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:241) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:47) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: $P{From_Date} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:291) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:618) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:586) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1020) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:568) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:552) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:281) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:504) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:315) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:251) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:558) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) ... 41 more Caused by: java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Date at BannerBadDebt_1459952925410_607805.evaluate(BannerBadDebt_1459952925410_607805:287) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:277) ... 53 more

Attempting to schedule a job using REST V2 api. Report takes 2 parameters, from and to date. XML is below with most of the me specific items changed. These input parameters are java.sql.Date types. Simply trying to pass in 2 dates, have tried different combinations of formats until I am blue in the face. The report is scheduled, I get an email with an empty report. When opening the job schedule on the server I can see all of the options, the parameter tab is highlighted but it does not have values. If I manually schedule the report using the date pickers, same date format as the xml below, it works just fine. Jasper Reports server v6.2 <job> <source> <reportUnitURI>/reports/Some Report</reportUnitURI> <parameters> <parameterValues> <entry> <key>FROM_DATE</key> <value type="xs:date">2015-01-01</value> </entry> <entry> <key>TO_DATE</key> <value type="xs:date">2016-04-12</value> </entry> </parameterValues> </parameters> </source> <baseOutputFilename>Some Report</baseOutputFilename> <repositoryDestination> <folderURI>/ScheduledOutput</folderURI> <outputDescription/> <overwriteFiles>false</overwriteFiles> <sequentialFilenames>true</sequentialFilenames> <version>1</version> </repositoryDestination> <label>Some Label</label> <outputFormats> <outputFormat>PDF</outputFormat> </outputFormats> <jobMailNotification> <subject>Scheduled Report</subject> <resultSendType>SEND_ATTACHMENT</resultSendType> <toAddresses>myemail@myemail.com</toAddresses> </jobMailNotification> <simpleTrigger> <startDate>2016-04-12T19:03:00+00:00</startDate> <timezone>America/New_York</timezone> <version>1</version> <occurrenceCount>1</occurrenceCount> </simpleTrigger> <mailNotification> <bccAddresses/> <ccAddresses/> <includingStackTraceWhenJobFails>false</includingStackTraceWhenJobFails> <messageText>Report Output Attached. </messageText> <resultSendType>SEND_ATTACHMENT</resultSendType> <skipEmptyReports>false</skipEmptyReports> <skipNotificationWhenJobFails>false</skipNotificationWhenJobFails> <subject>some report</subject> <toAddresses> <address>some email</address> </toAddresses> <version>1</version> </mailNotification> <version>1</version></job> [/code]