kcd Posted October 13, 2011 Share Posted October 13, 2011 I have a report that executes fine in iReport and but throws the following error in jasperserver. I've re-uploaded it to double check.- First main report has subreport (a table) which uses $P{REPORT_CONNECTION} (dataset with the same query)- If I set the table to use an empty dataset it successfully returns nothing in iReport but the same error in jasperserver- Quick search for "REPORT_CONNECTION" in my jrxml and it is not present- No reason it should be a problem with the datasource because i use the same connection for other reports.What is wrong here?Code:The server has encountered an error. Please excuse the inconvenience.Error Messagenet.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONNECTION" does not exist.Error Tracenet.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONNECTION" does not exist. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:606) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getParameterValue(JRAbstractQueryExecuter.java:470) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getParameterValue(JRAbstractQueryExecuter.java:482) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.<init>(JRJdbcQueryExecuter.java:103) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:125) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:50) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:111) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:1054) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.executeQuery(ReportParametersAction.java:801) Link to comment Share on other sites More sharing options...
kcd Posted October 13, 2011 Author Share Posted October 13, 2011 Found it!The connection of concern was a query for a parameter (a list of countries to select from). Had selected the wrong data source. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now