sirrond
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by sirrond
-
-
I have a report with 2 subreports which works perfectly in iReport. However in jasperServer it gives the following error on one of the subreports:
java.sql.SQLException: Column 'Code' not found.
There is no Column named "Code" defined in any of the report or subreports. And no SQL
This is JasperServer 2.1, and iReports 2.0.4.
Following is the error from JasperServer:
Code:
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : TeacherAssignmentDrill_detail
at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:622)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:344)
at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:346)
at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:305)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1382)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:610)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:326)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:737)
at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:258)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:269)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:175)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)
at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)
at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)
at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)
at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)
at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)
at org.springframework.webflow.engine.State.enter(State.java:200)
at org.springframework.webflow.engine.Transition.execute(Transition.java:229)
at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112)
at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572)
at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207)
at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:185)
at org.springframework.webflow.engine.State.enter(State.java:200)
at org.springframework.webflow.engine.Flow.start(Flow.java:557)
at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)
at org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:120)
at org.springframework.webflow.engine.State.enter(State.java:200)
at org.springframework.webflow.engine.Transition.execute(Transition.java:229)
at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112)
at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572)
at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207)
at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214)
at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238)
at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy13.resume(Unknown Source)
at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115)
at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : TeacherAssignmentDrill_detail
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:75)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:683)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:615)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1203)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795)
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:519)
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63)
at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209)
... 1 more
Caused by: java.sql.SQLException: Column 'Code' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:910)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353)
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:705)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3402)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1801)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)
... 10 more
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : TeacherAssignmentDrill_detail
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : TeacherAssignmentDrill_detail
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:75)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:683)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:615)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1203)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795)
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:519)
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63)
at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Column 'Code' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:910)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353)
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:705)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3402)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1801)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)
... 10 more
java.sql.SQLException: Column 'Code' not found.
java.sql.SQLException: Column 'Code' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:910)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353)
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:705)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3402)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1801)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:75)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:683)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:615)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1203)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795)
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:519)
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63)
at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209)
at java.lang.Thread.run(Thread.java:595)Here are the Parameters, the SQL Query and the fields from the subreport - please note that there is NOT any column named "code" or any part of the name "code":
Code: [code]
<parameter name="SESSIONKEY" isForPrompting="true" class="java.lang.String">
<parameterDescription><![CDATA[sessionKey]]></parameterDescription>
<defaultValueExpression ><![CDATA["test"]]></defaultValueExpression>
</parameter>
<parameter name="STARTDATE" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[start Date YYYY-MM-DD]]></parameterDescription>
<defaultValueExpression ><![CDATA["2007-09-01"]]></defaultValueExpression>
</parameter>
<parameter name="ENDDATE" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[start Date YYYY-MM-DD]]></parameterDescription>
<defaultValueExpression ><![CDATA["2008-07-31"]]></defaultValueExpression>
</parameter>
<queryString><![CDATA[select 'TeacherAssignmentDrill_detail' as qryName
, sessionKey
, assignmentAUID
, ownerAUID
, topicName
, topicReportOrder
, assignmentEffort
, gaNumAssigned
, gaScore
, gaPctTried
, stNumAssigned
, stPctTried
, tstNumAssigned
, tstScore
, tstPctTried
, classAUID
, className
, assignmentEffort_class
, gaNumAssigned_class
, gaScore_class
, gaPctTried_class
, stNumAssigned_class
, stPctTried_class
, tstNumAssigned_class
, tstScore_class
, tstPctTried_class
, numStudents_class
, studentAUID
, studentLastName
, studentFirstName
, assignmentEffort_student
, gaNumAssigned_student
, gaScore_student
, gaPctTried_student
, stNumAssigned_student
, stPctTried_student
, tstNumAssigned_student
, tstScore_student
, tstPctTried_student
, assignmentName
, assignmentTypeEN
, assignmentStartDateTime
, assignmentEndDateTime
, date_format(assignmentStartDateTime, '%M %d %Y') as monthddyyyy_assginmentStartDate
, date_format(assignmentEndDateTime, '%M %d %Y') as monthddyyyy_assginmentEndDate
, mainTopicName
, mainComponentName
, manAUID
from lmsReportsDatabase.teacherAssignmentDrill
where sessionKey = $P{SESSIONKEY}
order by topicReportOrder, className, studentLastName, studentFirstName
;]]></queryString>
<field name="qryName" class="java.lang.String"/>
<field name="sessionKey" class="java.lang.String"/>
<field name="assignmentAUID" class="java.lang.String"/>
<field name="ownerAUID" class="java.lang.String"/>
<field name="topicName" class="java.lang.String"/>
<field name="topicReportOrder" class="java.lang.Integer"/>
<field name="assignmentEffort" class="java.lang.Integer"/>
<field name="gaNumAssigned" class="java.lang.Integer"/>
<field name="gaScore" class="java.lang.Integer"/>
<field name="gaPctTried" class="java.lang.Integer"/>
<field name="stNumAssigned" class="java.lang.Integer"/>
<field name="stPctTried" class="java.lang.Integer"/>
<field name="tstNumAssigned" class="java.lang.Integer"/>
<field name="tstScore" class="java.lang.Integer"/>
<field name="tstPctTried" class="java.lang.Integer"/>
<field name="classAUID" class="java.lang.String"/>
<field name="className" class="java.lang.String"/>
<field name="assignmentEffort_class" class="java.lang.Integer"/>
<field name="gaNumAssigned_class" class="java.lang.Integer"/>
<field name="gaScore_class" class="java.lang.Integer"/>
<field name="gaPctTried_class" class="java.lang.Integer"/>
<field name="stNumAssigned_class" class="java.lang.Integer"/>
<field name="stPctTried_class" class="java.lang.Integer"/>
<field name="tstNumAssigned_class" class="java.lang.Integer"/>
<field name="tstScore_class" class="java.lang.Integer"/>
<field name="tstPctTried_class" class="java.lang.Integer"/>
<field name="numStudents_class" class="java.lang.Integer"/>
<field name="studentAUID" class="java.lang.String"/>
<field name="studentLastName" class="java.lang.String"/>
<field name="studentFirstName" class="java.lang.String"/>
<field name="assignmentEffort_student" class="java.lang.Integer"/>
<field name="gaNumAssigned_student" class="java.lang.Integer"/>
<field name="gaScore_student" class="java.lang.Integer"/>
<field name="gaPctTried_student" class="java.lang.Integer"/>
<field name="stNumAssigned_student" class="java.lang.Integer"/>
<field name="stPctTried_student" class="java.lang.Integer"/>
<field name="tstNumAssigned_student" class="java.lang.Integer"/>
<field name="tstScore_student" class="java.lang.Integer"/>
<field name="tstPctTried_student" class="java.lang.Integer"/>
<field name="assignmentName" class="java.lang.String"/>
<field name="assignmentTypeEN" class="java.lang.String"/>
<field name="assignmentStartDateTime" class="java.sql.Timestamp"/>
<field name="assignmentEndDateTime" class="java.sql.Timestamp"/>
<field name="monthddyyyy_assginmentStartDate" class="java.lang.String"/>
<field name="monthddyyyy_assginmentEndDate" class="java.lang.String"/>
<field name="mainTopicName" class="java.lang.String"/>
<field name="mainComponentName" class="java.lang.String"/>
<field name="manAUID" class="java.lang.String"/>Any help with this is greatly appreciated.
-
look for the file jasperserver-servlet.xml This file will be in the WEB-INF folder.
Inside that file will be the following text:
<prop key="/login.html">login_welcome</prop>
Modify that as follows:
<prop key="/login.html">login</prop>
Note: changing "login_welcome" to "login"
This file has various parameters for jasperserver, including which of the two logins should be used.
Restart your tomcat (or jboss) server and you will see the old "simple" login.
-
In the JRUltimate document there is a XML export. In the JasperServer I find export buttons for PDF, Excel, Word (RTF), and CSV. But I cannot find any way to export to XML.
How do I make JasperServer export to XML?
Thank you.
fyi - I am NOT a java programmer. I am a database engineer, and report designer. I use iReport reports and Jasper server to generate reports. So far I have be able to do what ever I've needed. But now I need to export a report as an XML document.
-
I am trying to get the web services samples to work. However I am not having any success.
I downloaded thJasperServer-1.2-WS-Client-Samples, but there are not any notes or documentation on how to set it up. I get the following error when I try to access this sample from my tomcat server
Code:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 3 in the jsp file: /index.jsp
Generated servlet error:
/var/lib/tomcat-5.5/work/Catalina/localhost/web/org/apache/jsp/index_jsp.java:52: package com.jaspersoft.jasperserver.sample does not exist
com.jaspersoft.jasperserver.sample.WSClient client = new com.jaspersoft.jasperserver.sample.WSClient(There were no setup instructions or notes in the readme, so here is what I did to set it up:
1. download the zip
2. unzip - which gave me the following
Code: [code]
SampleWebApp/
license.txt
phpclient/
readme.txt3. copy the directory "web" (inside SampleWebApp) to my tomcat webapps directory (the main location of all my web applications including jasperserver
4. restart tomcat
5. go to my "web" url and I get the error listed above.
I know I am missing something. There is a directory in the SampleWebApp named "src" which has what looks to me like the missing piece. But I don't know where this directory should be placed to make this work.
Any help would be greatly appreciated. Thanks
JasperServer database error
in Products
Posted
SessionKey is a string parameter passed from the Main Report into the subreport. SessionKey is read from the database in the MainReport. The subreport is the 2nd subreport called in the detail band of the Main Report.
The first subreport calls a stored procedure which build the data for the 2nd report.
The second subreport is a simple report which lists that detail.
The first subreport works - there is data in the database. The second subreport fails with the very strange error that I posted.
In iReports, this works perfectly. No errors at all, so I am unable to debug this.
Here is some information from the Main Report.
From the Main Report - Query to get SessionKey:
From the Main Report - Detail Band with Subreport definition - it is the 2nd subreport which gives errors:
<detail>
<band height="12" isSplitAllowed="true" >
<subreport isUsingCache="true">
<reportElement
x="0"
y="0"
width="552"
height="12"
key="subreport-calls_teacherAssignmentDrill"/>
<subreportParameter name="ZSQLCALL">
<subreportParameterExpression><![CDATA["CALL lmsReportsDatabase.sp_teacherAssignmentDrill('"
+ $F{sessionKey} + "','"
+ $P{ASSIGNMENTAUID} + "','"
+ $P{TOPICAUID} + "', '"
+ $P{COMPONENT} + "');"]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "callsp_teacherAssignmentDrill.jasper"]]></subreportExpression>
</subreport>
<subreport isUsingCache="true">
<reportElement
x="0"
y="0"
width="732"
height="12"
key="subreport-1"/>
<subreportParameter name="SUBREPORT_DIR">
<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="SESSIONKEY">
<subreportParameterExpression><![CDATA[$F{sessionKey}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="STARTDATE">
<subreportParameterExpression><![CDATA[$P{STARTDATE}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="ENDDATE">
<subreportParameterExpression><![CDATA[$P{ENDDATE}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "TeacherAssignmentDrill_detail.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>