nirum

Hi All I have a question for the user community of JasperSoft and impementation specialists/professional services of JasperSoft. Have you handled installations where thousands ( literally ~ 500000 users) have been deployed on a JasperServer. If so, how did you do the administration part for these thousands of users on a single Jasperserver. If each of the user needed their personal reports and adminstrative space, how did you set these up painlessly. Do you have any solutions/sugggestions for such a large installation. How scalable is JasperSoft in this respect and how did it handle hits to the server by atleast 10% of this population at a time. Thanks for your insights and help in this matter, Niru

I have implemented SSO and yes, JasperServer does add users without any password for such users. However, there is still a lot of folders/permissions/roles that is set up per user. Is there anyway we can avoid this setup as we have thousands of users and we need some automation in doing this. Thanks Niru

Hi, If we want to provide SSO with our database and not maintain **ANY** user information in the jasperserver database, is it possible to do so. This means I want to use our dataabase for everything - we don't want to have anything about the user in the jasperserver db or maintain anything in the long run. The reason is that we have a requirement where we will have around a milllion users in our system using JasperServer and we may have updates going on to alteast 5% of these users constantly. So we do not want to have to do anything on the JasperServer side as well. However, we want reporting to run off Jasperserver without any problems when these updates happen to our database (e.g., delete a user, delete a role etc). Thanks for your input, niru

Hi, I would like to implement a custom Voter that will implement the authorization functionality that is needed by our application. We have a complex combination of attributes and functions that will decide if a user is ALLOWED to or NOT ALLOWEd to see a report or execute certain parts of the report. However, I already see a custom accessdecisonmanager and voters that is implemented in your acegi security file. If I were to add another Voter to this list would it work? <bean id="hibernateRepoServiceSecurity" class="org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor"> <property name="authenticationManager"><ref local="authenticationManager"/></property> <property name="accessDecisionManager"><ref local="aclAccessDecisionManager"/></property> <property name="afterInvocationManager"><ref local="afterInvocationManager"/></property> <property name="objectDefinitionSource"><ref local="repositoryServiceMethodSecurity"/></property> </bean> <bean id="aclAccessDecisionManager" class="org.acegisecurity.vote.AffirmativeBased"> <property name="allowIfAllAbstainDecisions"><value>true</value></property> <property name="decisionVoters"> <list> <ref local="roleVoter"/> <ref local="aclUserAdminVoter"/> <ref local="aclUserUpdateVoter"/> <!-- <ref local="aclUserCreateVoter"/> --> <ref local="aclUserDeleteVoter"/> <ref local="aclUserReadVoter"/> <ref local="aclUserMoveVoter"/> <ref local="aclUserCopyVoter"/> </list> </property> </bean> Thanks for your help!!

Matt, Thanks for replying. I need to use an api to set the locale in JasperServer at runtime using a servlet filter, as the user logs in. We are not going to have JasperServer login as the goal is to offer reporting seamlessly using JasperServer but thru' our app interfaces. Also, this locale setting has to kick in when the user logs in at a user level, so I don't want to set it at a report level. Thanks Niru

Hi All I have a question about setting locales at runtime. I know you have resource bundles and locale bundles that can be configured in the spring applicationContext.xml files. I am looking for a way to pick up the locale bundle based on the user login or some properties of the user at runtime - how can this be configured. I know your web services provides a way for specifying a locale parameter. But I am looking for a way to do it while executing any normal report. Thanks for your help, Niru

hi JasperGurus I am getting a Null Pointer when I try to execute any url with ViewReportAction in the checkForParams method. Any idea why this would happen ? are all the report definitions meta data in the jasperserver database - if so, which table shoudl I check for my report meta definitions. thanks a lot for any feedback on debugging this. java.lang.NullPointerException

How do you translate these old urls to the new format? Thanks!

How do you translate these old urls to the new format? Thanks!

Hi All, I composed a report MainReport with a subreport SubReport - the main report and the sub report execute fine by themselves. Howver, the main report does not display the sub report. In the iReport designer, the design shows the subreport embedded in the main. But on execution, it never shows the details the subreport contains in the main report. I have attached both the MainReport.jrxml and the SubReport.jrxml. I am passing a parameter "Name" to the subreport based on which it is supposed to show some more details for that name. Any help/pointers would be appreciated.

Hi All, I am trying to generate a report with a couple of strings concatenated together to produce a column. I am getting out of memory errors whenever I try to execute the report - the report compiles fine. I have put this in a subreport. When I use this or even a much bigger query in the main report it works fine. Any ideas, Data is less than 1500 rows. Attached is the jrxml file. Fill 33205773: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more Fill 14189816: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more Fill 3161430: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more Fill 18083967: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more Fill 30945063: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more Fill 16322495: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more Fill 9791296: exception net.sf.jasperreports.engine.JRRuntimeException: java.lang.OutOfMemoryError: unab le to create new native thread at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(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(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:574) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.start(JRThre adSubreportRunner.java:76) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:610) ... 13 more

I did nto get an answer to this however I found out from other sources that there is a limitation set in applicationContext-adhoc.xml for the default number of rows/columns an ad hoc report can handle. so I increased that to 1000000 and restarted the server. However, it still crashed the server when I tried to run the report - it tried to run the report throws the following exception and dies. Thanks for any help in this matter, There are exactly 277000 rows in this particular table that I am accessing. 14:10:17,695 ERROR ViewAdhocReportAction,http-9090-Processor25:171 - error setti ng up report com.jaspersoft.commons.util.QueryExecutionTooManyRowsException: jsexception.Quer yExecutionTooManyRowsException at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSCo ntrolledResultSetDataSource.java:34) at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterat or.next(JRQueryDataSet.java:244) at com.jaspersoft.commons.datarator.jr.DataratorJRDataSource.next(Datara torJRDataSource.java:25) at com.jaspersoft.commons.datarator.jr.JRDataSourceAdapter$JRDataSetIter ator.next(JRDataSourceAdapter.java:134) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java :51) at com.jaspersoft.commons.datarator.DataSetCacheImpl.getCachedDataSet(Da taSetCacheImpl.java:132) at com.jaspersoft.commons.datarator.DataSetCacheImpl.getCachedDataSet(Da taSetCacheImpl.java:78) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(A dhocEngineServiceImpl.java:252) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(A dhocEngineServiceImpl.java:188) at com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.verifyData(ViewA dhocReportAction.java:147) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(Dispatc hMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction. java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAct ion.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedA ction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecu tor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.ja va: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(Transi tionableState.java:112) at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) at org.springframework.webflow.engine.impl.RequestControlContextImpl.sig nalEvent(RequestControlContextImpl.java:207) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.ja va: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.sta rt(RequestControlContextImpl.java:195) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowE xecutionImpl.java:189) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExec utorImpl.java:206) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti on(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo inpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityIntercep tor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami cAopProxy.java:210) at $Proxy17.launch(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handl eFlowRequest(FlowRequestHandler.java:131) at org.springframework.webflow.executor.mvc.FlowController.handleRequest Internal(FlowController.java:170) at org.springframework.web.servlet.mvc.AbstractController.handleRequest( AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.ha ndle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch erServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche rServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(Frame workServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl et.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter (UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(S witchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(Filt erSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Fi lterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTra nslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.ja va:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFil ter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAu thenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.jav a:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFi lter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicPr ocessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPr eferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProces singFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPr eferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilte r(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F ilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.jav a:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.j ava:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter (CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat ingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p rocessConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo int.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol lowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:684) at java.lang.Thread.run(Thread.java:595) Hi, I created a cross-tab report using the ad-hoc option in the JasperServer. Even as I designed the report ( adding the column groups and row groups), the tool gave a "Too many rows" error but it showed an overall design with a single row. When I tried to run the report, it gave me "The query for the report has been canceled becuase it returned more than 200000 rows. Modify the report to reduce the number of rows". Is this a limitation of JasperReports - is 200000 the maximum number of rows that it can return? How can we restrict our clients databases. This doesn't seeem to be reasonable expectation. Thanks Niru

Hi, I created a cross-tab report using the ad-hoc option in the JasperServer. Even as I designed the report ( adding the column groups and row groups), the tool gave a "Too many rows" error but it showed an overall design with a single row. When I tried to run the report, it gave me "The query for the report has been canceled becuase it returned more than 200000 rows. Modify the report to reduce the number of rows". Is this a limitation of JasperReports - is 200000 the maximum number of rows that it can return? How can we restrict our clients databases. This doesn't seeem to be reasonable expectation. Thanks Niru

I tried to attach the html but it doesn't seem to do it... Niru

Hi, Where exactly are the samples for crosstabs in the samples directory. Is it the CustomDAtasources/repotrs/hqlTest.jrxml ? Can we design crosstab reports using iReport? thanks Niru