error preparing SQL statement

[yuejdesigner85]

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

[jcuser]

Do u recently update something? I remember there's something about the max length from the UI.