Report unit runs once then fails

[twohandsgaz]

I have ireport 3.7.4 with compatibility turned back to 3.6.2, The report is then displayed via jasperserver 3.7 community edition. The main report has 4 subreports with one parameter passed through the subreports, taking data from 3 data sources. When the report is previewed in ireport it works all day long. When the report is previewed in ireport via "run report unit" it runs once perfectly, but then subsequent attempts to run it produces errors

java.lang.Exception: 1 - Error executing SQL statement for : Surveyor main info screen      at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403)      at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320)      at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 

In Jasperserver the error is,

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : Surveyor main info screen

VERY VERY Frustrating. I have tried to save the report in various versions all to no avail. Any help would be greatly appreciated.

Post Edited by twohandsgaz at 07/22/2010 08:24