Error: The Server has returned an error with code 1 and with the message Error executing SQL statement

[darwin66]

java.lang.Exception: The Server has returned an error with code 1 and with the message Error executing SQL statement
 at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:406)
 at com.jaspersoft.studio.server.protocol.soap.SoapConnection.runReport(SoapConnection.java:233)
 at com.jaspersoft.studio.server.protocol.ProxyConnection.runReport(ProxyConnection.java:205)
 at com.jaspersoft.studio.server.WSClientHelper.runReportUnit(WSClientHelper.java:415)
 at com.jaspersoft.studio.server.editor.ReportRunControler$2.run(ReportRunControler.java:169)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
 

Thanks for your Help.

 

[Tom C]

You should inspect server log to see what kind of SQL error you are getting to help diagnose the problem. Can you provide more detail on what you are trying to do in the Studio when encountering this error?

[vbence]

Same problem. The problem comes up, when I added some input controls to the report on the web ui and after when i wanted to open project int the tree in the jaspersoft studio repository explorer, i got this error.

 

[sjmerchant]

Did anyone resolve this issue? if so, can you please post the solution/workaround?

Thank you.