Hi, I have this report that has been running fine for several weeks already. Now all of a sudden it complains about preparing for SQL statement. It's not just this report, all the reports are not running because of this exception. I suspect it has something to do with configurations I did, perhaps. I also tried it on different data sources (Vertica and Informix), they both complain about the same problem. I also tested the connection, so network issue is not the problem.com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT vrpt_otclink_blotter."TradeDate" AS TradeDate, vrpt_otclink_blotter."OrderReceiveTime" AS OrderReceiveTime, vrpt_otclink_blotter."OrderId" AS OrderId, vrpt_otclink_blotter."SenderMMID" AS SenderMMID, vrpt_otclink_blotter."ReceiverMMID" AS ReceiverMMID, vrpt_otclink_blotter."Symbol" AS Symbol, vrpt_otclink_blotter."Side" AS Side, vrpt_otclink_blotter."Quantity" AS Quantity, vrpt_otclink_blotter."Price" AS Price, vrpt_otclink_blotter."OrderType" AS OrderType, vrpt_otclink_blotter."TimeInForce" AS TimeInForce, vrpt_otclink_blotter."ExpireTime" AS ExpireTime, vrpt_otclink_blotter."InsideBid" AS InsideBid, vrpt_otclink_blotter."InsideAsk" AS InsideAsk, vrpt_otclink_blotter."OrderStatus" AS OrderStatus, vrpt_otclink_blotter."UpdateTime" AS UpdateTime, vrpt_otclink_blotter."ExecQty" AS ExecQty, vrpt_otclink_blotter."ExecPrice" AS ExecPrice, vrpt_otclink_blotter."ExecId" AS ExecId, vrpt_otclink_blotter."ClientExecId" AS ClientExecId, vrpt_otclink_blotter."ExecSequence" AS ExecSequence, vrpt_otclink_blotter."RemainingQty" AS RemainingQty, vrpt_otclink_blotter."EndTime" AS EndTimeFROM "public"."vrpt_otclink_blotter" vrpt_otclink_blotterWHERE vrpt_otclink_blotter."TradeDate" = ?ORDER BY vrpt_otclink_blotter."SenderMMID" ASC at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:266) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:157) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901) at com.jaspersoft.ji.engine.ProEngineServiceImpl.fillReport(ProEngineServiceImpl.java:251) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:732) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:390) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:891) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:320) at com.jaspersoft.ji.engine.ProEngineServiceImpl.execute(ProEngineServiceImpl.java:132) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:499) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:103) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:427) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)Caused by: com.vertica.util.PSQLException: Fetch size must be a value greater to or equal to 0. at com.vertica.jdbc2.AbstractJdbc2Statement.setFetchSize(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.setFetchSize(DelegatingStatement.java:276) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:229) ... 18 more[/code] Post Edited by yuejdesigner85 at 03/06/2012 16:52
