Jump to content
We've recently updated our Privacy Statement, available here ×

nirum

Members
 View Profile  See their activity

  • Posts

    17

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by nirum

    scalability of JasperServer

    in Products

    Posted

    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

    Users in JasperServer DB

    in Products

    Posted

     

      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

    Users in JasperServer DB

    in Products

    Posted

    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

     

    Implementing our own Voter

    in Products

    Posted

    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!!

     

    locale setting at runtime in JasperServer 3.0

    in Products

    Posted

    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

    locale setting at runtime in JasperServer 3.0

    in Products

    Posted

    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

    Nullpointer when I try to execute any ViewReportAc

    in Products

    Posted

    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
     

    subreport not displayed in the main report

    in Products

    Posted

    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.

    OutOfMemory Errors

    in Products

    Posted

    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



    cross tab reports

    in Products

    Posted

    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

    cross tab reports

    in Products

    Posted

    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

    html versus pdf content for the same report

    in Products

    Posted

    Hi,

    I produced a report in pdf and html formats. The html format looks ugly and seems to be missing a lot of images. I have attached both - can you tell me if I have missed something.



      Also, does JasperSoft support paginated html - how would I be able to demonstrate this ( with simply a lot of data spanning several pages?)



     Thanks


    Niru



    input control based on multi-select query

    in Products

    Posted

    Hi,

    I am trying to construct a report where I would like to

      a) populate an input control with a list from the database

     b) let the user select one or more of these and pass it to the report

    The input control shows the list allright and lets me select but when executing the query it fails with

    1 - Incompatible java.util.ArrayList value assigned to parameter first_name_last_name in the payRollTabularReport dataset.

    java.lang.Exception: 1 - Incompatible java.util.ArrayList value assigned to parameter first_name_last_name in the payRollTabularReport dataset.

    at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:394)

    at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:311)

    at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:80)

    at java.lang.Thread.run(Thread.java:595)

    Here is my query:

    <parameter name="first_name_last_name" isForPrompting="true" class="java.lang.String"/>

    select (concat(e.LAST_NAME,concat( ', ',e.FIRST_NAME))), e.payroll, w.pdate ,w.shift, w.code , w.rate,  w.on_time , w.off_time
     from worked w , emp e
    where w.payroll = e.payroll and $X{IN, Employee, first_name_last_name};

    Could you please provide pointers on what exactly I need to provide here. I tried changing the java.lang.String to java.util.ArrayList but then it would not show me my drop down filled with the first name, last name.

    Thanks for your help.

     

    Niru

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore