twohandsgaz
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by twohandsgaz
-
-
Hi,
Have you added the same parameters in Jasperserver?
Are you sure the report produces data?
-
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
Report runs perfectly in iReport but fails after one run.
in Products
Posted
HI All.
I have a report containg one main report and 4 subreports, Data is retrieved from four sources and there is one parameter required at the very begining.
As you can see from the attcahed screenshot, the subreports are there but the error seems to be saying there not!!!
Confused.
Any ideas are gladly received. :)
Thanks for your help guys n girls.