Issue
When trying to upload a report with Stored procedure from Jaspersoft Studio to JasperReports Server , one of the following exceptions is trown:
org.apache.http.client.HttpResponseException: Bad Request
at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:60)
at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:55)
at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:520)
at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:312)
at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:190)
at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:68)
at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:305)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
or
org.apache.http.client.HttpResponseException: Invalid JRXML
at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptorList(RESTv2ExceptionHandler.java:87)
at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:104)
at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:56)
at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:52)
at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:445)
at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:290)
at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:184)
at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:61)
at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:302)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Possible causes and solutions
The first thing to make sure is that PLSQL language is configured on JasperReports Server. This language is not configured by default. You'll have to follow steps from this article:
The jar file mentioned there can be downloaded from here:
If that does resolve the issue still, try changing the query language in your report from 'plsql' to 'sql'. This will give a syntax report in the Studio (as it should), but the report should still run:
.jpg.87ed9ef1b778933f67412d19fee7d4fa.jpg)
Recommended Comments
There are no comments to display.