glen

I need someone with very good java and JasperServer skills to customise the Acegi security flow, beans and classes in order to integrate JasperServer with an existing web application. This work could be done remotely in consultation with myself. Offering £40 per hour with an expected max of 10 hours on this task.

I have several Jasper projects at customers ongoing at the moment and I am looking for good people to help as this part of the business is growing rapidly. If you think you have the technical and people skills then please get in touch. Initially offering day rate work but with the potential to go permanent in time. Post Edited by glen at 01/21/2010 09:01 Post Edited by glen at 01/21/2010 09:02

I want to use an MDX report (not an anlysis view) to draw a pie chart of the number of each type of product sold in a particular depot and of a particular brand. The underlying Infobright DB fact table has 12 million rows. This is a very simple thing to ask and the MDX I thought was simple enough: SELECT NON EMPTY { [Measures].[Pcls] } ON COLUMNS, NON EMPTY { [Products].Members } ON ROWS FROM [Fact] WHERE ( [CollectionDEPOTIDs].[All CollectionDEPOTIDs].[0010] , [bRANDIDs].[All BRANDIDs].[2] ) But this generates several SQL queries into the DB each taking about 8 seconds, resulting in a 40 second response time for a query that if I write in SQL takes less than a 3 seconds to produce a resultset. So my question is what can I do to make the MDX more efficient in the SQL it generates ? Code:SELECT NON EMPTY { [Measures].[Pcls] } ON COLUMNS, NON EMPTY { [Products].Members } ON ROWSFROM [Fact]WHERE ( [CollectionDEPOTIDs].[All CollectionDEPOTIDs].[0010], [bRANDIDs].[All BRANDIDs].[2] )

Ace. Thanks Giulio. I saw that you had the new version out and was not sure if it was covered in there. So I will make sure that I get a copy of that. Glen

In the following thread http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=15491 Lucian makes the comment that "since you have only one measure on the column axis, you can also simply use Data as the field mapping". This works fine. Although I had to use Data(0,?). Still makes things simpler. My question is : Is there an equivalent syntax for Rows i.e. if I only have one dimension on the row axis can I use Rows(?,0) or something similar ? And is any of this in a reference manual somewhere ?

I am trying to produce a very simple report single pie chart report in Jasperserver 3.5 from an XMLA datasource using the default demo data and configuration. The trace below is a debug log file output - it shows: the MDX request; the SQL; the MDX result; the error message (Invalid field mapping "[Measures].[Number of Sales]") ; and the java stack trace. The MDX runs through fine and returns what looks to me like a valid resultset. But then I get an error about an invalid field mapping? The error refers to the first statement in the MDX query. However, I can see that element - [Measure].[Number of Sales] - in the resultset so it is certainly there. I can open the report in iReport 3.5.2 and run it perfectly from there. I would really appreciate some help on this one. _____________________________________________________ 19:58:00,509 DEBUG DefaultXmlaServlet,http-8080-Processor25:138 - XML/A request content <?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Body> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"> <Command xmlns="urn:schemas-microsoft-com:xml-analysis"> <Statement xmlns="urn:schemas-microsoft-com:xml-analysis">SELECT NON EMPTY { [Measures].[Number of Sales] } ON COLUMNS, NON EMPTY { [Account Location].[Country].Members } ON ROWS FROM [salesAnalysis]</Statement> </Command> <Properties xmlns="urn:schemas-microsoft-com:xml-analysis"> <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"> <Catalog xmlns="urn:schemas-microsoft-com:xml-analysis">SugarCRM</Catalog> <AxisFormat xmlns="urn:schemas-microsoft-com:xml-analysis">TupleFormat</AxisFormat> <DataSourceInfo xmlns="urn:schemas-microsoft-com:xml-analysis">Provider=Mondrian;DataSource=SugarCRM;</DataSourceInfo> <Format xmlns="urn:schemas-microsoft-com:xml-analysis">Multidimensional</Format> </PropertyList> </Properties> </Execute> </soapenv:Body> </soapenv:Envelope> 19:58:00,510 DEBUG XmlaServlet,http-8080-Processor25:248 - Handling XML/A message header 19:58:00,510 DEBUG XmlaServlet,http-8080-Processor25:269 - Invoking callbacks preAction 19:58:00,510 DEBUG XmlaServlet,http-8080-Processor25:299 - Handling XML/A message body 19:58:00,511 DEBUG XmlaHandler,http-8080-Processor25:1644 - mdx: "SELECT NON EMPTY { [Measures].[Number of Sales] } ON COLUMNS, NON EMPTY { [Account Location].[Country].Members } ON ROWS FROM [salesAnalysis]" 19:58:00,514 DEBUG XmlaHandler,http-8080-Processor25:2798 - XmlaHandler.getDataSource: dataSourceInfo=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1; 19:58:00,515 DEBUG XmlaHandler,http-8080-Processor25:2809 - XmlaHandler.getDataSource: ds.dataSourceInfo=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1; 19:58:00,515 DEBUG XmlaHandlerImpl,http-8080-Processor25:124 - XmlaHandlerImpl.getConnection: ds.dataSourceInfo=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1; 19:58:00,515 DEBUG XmlaHandlerImpl,http-8080-Processor25:215 - looking up DataSource name=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1;, info=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1;, url=null 19:58:00,559 DEBUG XmlaHandlerImpl,http-8080-Processor25:242 - Connection Found for catalog: SugarCRM 19:58:00,565 DEBUG XmlaHandlerImpl,http-8080-Processor25:215 - looking up DataSource name=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1;, info=Provider=Mondrian;DataSource=SugarCRM;TenantID=organization_1;, url=null 19:58:00,608 DEBUG XmlaHandlerImpl,http-8080-Processor25:242 - Connection Found for catalog: SugarCRM 19:58:00,611 DEBUG mdx,http-8080-Processor25:593 - 9: select NON EMPTY {[Measures].[Number of Sales]} ON COLUMNS, NON EMPTY {[Account Location].[Country].Members} ON ROWS from [salesAnalysis] 19:58:00,613 DEBUG sql,http-8080-Processor25:108 - 19: Segment.load: executing sql [ select `sales_location`.`country` as `c0`, count(`sales_fact`.`id`) as `m0` from `sales_location` as `sales_location`, `sales_fact` as `sales_fact` where `sales_fact`.`sales_location_id` = `sales_location`.`id` group by `sales_location`.`country` ] 19:58:00,632 DEBUG sql,http-8080-Processor25:144 - 19: , exec 19 ms 19:58:00,633 DEBUG sql,http-8080-Processor25:190 - 19: , exec+fetch 20 ms, 3 rows 19:58:00,634 DEBUG mdx,http-8080-Processor25:630 - 9: exec: 23 ms 19:58:00,643 DEBUG XmlaHandler,http-8080-Processor25:560 - XmlaHandler.process: time = 132 19:58:00,643 DEBUG XmlaHandler,http-8080-Processor25:561 - XmlaHandler.process: FREE_MEMORY: 87560kb 67.23% 19:58:00,644 DEBUG XmlaServlet,http-8080-Processor25:320 - Invoking callbacks postAction 19:58:00,644 DEBUG DefaultXmlaServlet,http-8080-Processor25:538 - XML/A response content <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > <SOAP-ENV:Header> </SOAP-ENV:Header> <SOAP-ENV:Body> <xmla:ExecuteResponse xmlns:xmla="urn:schemas-microsoft-com:xml-analysis"> <xmla:return> <root xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified"> <xsd:complexType name="MemberType"> <xsd:sequence> <xsd:element name="UName" type="xsd:string"/> <xsd:element name="Caption" type="xsd:string"/> <xsd:element name="LName" type="xsd:string"/> <xsd:element name="LNum" type="xsd:unsignedInt"/> <xsd:element name="DisplayInfo" type="xsd:unsignedInt"/> <xsd:sequence maxOccurs="unbounded" minOccurs="0"> <xsd:any processContents="lax" maxOccurs="unbounded"/> </xsd:sequence> </xsd:sequence> <xsd:attribute name="Hierarchy" type="xsd:string"/> </xsd:complexType> <xsd:complexType name="PropType"> <xsd:attribute name="name" type="xsd:string"/> </xsd:complexType> <xsd:complexType name="TupleType"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Member" type="MemberType"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="MembersType"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Member" type="MemberType"/> </xsd:sequence> <xsd:attribute name="Hierarchy" type="xsd:string"/> </xsd:complexType> <xsd:complexType name="TuplesType"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Tuple" type="TupleType"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="CrossProductType"> <xsd:sequence> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <xsd:element name="Members" type="MembersType"/> <xsd:element name="Tuples" type="TuplesType"/> </xsd:choice> </xsd:sequence> <xsd:attribute name="Size" type="xsd:unsignedInt"/> </xsd:complexType> <xsd:complexType name="OlapInfo"> <xsd:sequence> <xsd:element name="CubeInfo"> <xsd:complexType> <xsd:sequence> <xsd:element name="Cube" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element name="CubeName" type="xsd:string"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="AxesInfo"> <xsd:complexType> <xsd:sequence> <xsd:element name="AxisInfo" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element name="HierarchyInfo" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="UName" type="PropType"/> <xsd:element name="Caption" type="PropType"/> <xsd:element name="LName" type="PropType"/> <xsd:element name="LNum" type="PropType"/> <xsd:element name="DisplayInfo" type="PropType" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> <xsd:sequence> <xsd:any processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" use="required"/> </xsd:complexType> </xsd:element> </xsd:sequence> <xsd:attribute name="name" type="xsd:string"/> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="CellInfo"> <xsd:complexType> <xsd:sequence> <xsd:sequence minOccurs="0" maxOccurs="unbounded"> <xsd:choice> <xsd:element name="Value" type="PropType"/> <xsd:element name="FmtValue" type="PropType"/> <xsd:element name="BackColor" type="PropType"/> <xsd:element name="ForeColor" type="PropType"/> <xsd:element name="FontName" type="PropType"/> <xsd:element name="FontSize" type="PropType"/> <xsd:element name="FontFlags" type="PropType"/> <xsd:element name="FormatString" type="PropType"/> <xsd:element name="NonEmptyBehavior" type="PropType"/> <xsd:element name="SolveOrder" type="PropType"/> <xsd:element name="Updateable" type="PropType"/> <xsd:element name="Visible" type="PropType"/> <xsd:element name="Expression" type="PropType"/> </xsd:choice> </xsd:sequence> <xsd:sequence maxOccurs="unbounded" minOccurs="0"> <xsd:any processContents="lax" maxOccurs="unbounded"/> </xsd:sequence> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="Axes"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Axis"> <xsd:complexType> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <xsd:element name="CrossProduct" type="CrossProductType"/> <xsd:element name="Tuples" type="TuplesType"/> <xsd:element name="Members" type="MembersType"/> </xsd:choice> <xsd:attribute name="name" type="xsd:string"/> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="CellData"> <xsd:sequence> <xsd:element name="Cell" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence maxOccurs="unbounded"> <xsd:choice> <xsd:element name="Value"/> <xsd:element name="FmtValue" type="xsd:string"/> <xsd:element name="BackColor" type="xsd:unsignedInt"/> <xsd:element name="ForeColor" type="xsd:unsignedInt"/> <xsd:element name="FontName" type="xsd:string"/> <xsd:element name="FontSize" type="xsd:unsignedShort"/> <xsd:element name="FontFlags" type="xsd:unsignedInt"/> <xsd:element name="FormatString" type="xsd:string"/> <xsd:element name="NonEmptyBehavior" type="xsd:unsignedShort"/> <xsd:element name="SolveOrder" type="xsd:unsignedInt"/> <xsd:element name="Updateable" type="xsd:unsignedInt"/> <xsd:element name="Visible" type="xsd:unsignedInt"/> <xsd:element name="Expression" type="xsd:string"/> </xsd:choice> </xsd:sequence> <xsd:attribute name="CellOrdinal" type="xsd:unsignedInt" use="required"/> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:element name="root"> <xsd:complexType> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="OlapInfo" type="OlapInfo"/> <xsd:element name="Axes" type="Axes"/> <xsd:element name="CellData" type="CellData"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:schema> <OlapInfo> <CubeInfo> <Cube> <CubeName>SalesAnalysis</CubeName> </Cube> </CubeInfo> <AxesInfo> <AxisInfo name="Axis0"> <HierarchyInfo name="Measures"> <UName name="[Measures].[member_UNIQUE_NAME]"/> <Caption name="[Measures].[member_CAPTION]"/> <LName name="[Measures].[LEVEL_UNIQUE_NAME]"/> <LNum name="[Measures].[LEVEL_NUMBER]"/> <DisplayInfo name="[Measures].[DISPLAY_INFO]"/> </HierarchyInfo> </AxisInfo> <AxisInfo name="Axis1"> <HierarchyInfo name="Account Location"> <UName name="[Account Location].[member_UNIQUE_NAME]"/> <Caption name="[Account Location].[member_CAPTION]"/> <LName name="[Account Location].[LEVEL_UNIQUE_NAME]"/> <LNum name="[Account Location].[LEVEL_NUMBER]"/> <DisplayInfo name="[Account Location].[DISPLAY_INFO]"/> </HierarchyInfo> </AxisInfo> <AxisInfo name="SlicerAxis"> <HierarchyInfo name="Start Period"> <UName name="[start Period].[member_UNIQUE_NAME]"/> <Caption name="[start Period].[member_CAPTION]"/> <LName name="[start Period].[LEVEL_UNIQUE_NAME]"/> <LNum name="[start Period].[LEVEL_NUMBER]"/> <DisplayInfo name="[start Period].[DISPLAY_INFO]"/> </HierarchyInfo> <HierarchyInfo name="Close Period"> <UName name="[Close Period].[member_UNIQUE_NAME]"/> <Caption name="[Close Period].[member_CAPTION]"/> <LName name="[Close Period].[LEVEL_UNIQUE_NAME]"/> <LNum name="[Close Period].[LEVEL_NUMBER]"/> <DisplayInfo name="[Close Period].[DISPLAY_INFO]"/> </HierarchyInfo> <HierarchyInfo name="Sale State"> <UName name="[sale State].[member_UNIQUE_NAME]"/> <Caption name="[sale State].[member_CAPTION]"/> <LName name="[sale State].[LEVEL_UNIQUE_NAME]"/> <LNum name="[sale State].[LEVEL_NUMBER]"/> <DisplayInfo name="[sale State].[DISPLAY_INFO]"/> </HierarchyInfo> <HierarchyInfo name="Sales Person"> <UName name="[sales Person].[member_UNIQUE_NAME]"/> <Caption name="[sales Person].[member_CAPTION]"/> <LName name="[sales Person].[LEVEL_UNIQUE_NAME]"/> <LNum name="[sales Person].[LEVEL_NUMBER]"/> <DisplayInfo name="[sales Person].[DISPLAY_INFO]"/> </HierarchyInfo> <HierarchyInfo name="Account Categorization"> <UName name="[Account Categorization].[member_UNIQUE_NAME]"/> <Caption name="[Account Categorization].[member_CAPTION]"/> <LName name="[Account Categorization].[LEVEL_UNIQUE_NAME]"/> <LNum name="[Account Categorization].[LEVEL_NUMBER]"/> <DisplayInfo name="[Account Categorization].[DISPLAY_INFO]"/> </HierarchyInfo> </AxisInfo> </AxesInfo> <CellInfo> <Value name="VALUE"/> <FmtValue name="FORMATTED_VALUE"/> <FormatString name="FORMAT_STRING"/> </CellInfo> </OlapInfo> <Axes> <Axis name="Axis0"> <Tuples> <Tuple> <Member Hierarchy="Measures"> <UName>[Measures].[Number of Sales]</UName> <Caption>Number of Sales</Caption> <LName>[Measures].[MeasuresLevel]</LName> <LNum>0</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> <Axis name="Axis1"> <Tuples> <Tuple> <Member Hierarchy="Account Location"> <UName>[Account Location].[All Locations].[Canada]</UName> <Caption>Canada</Caption> <LName>[Account Location].[Country]</LName> <LNum>1</LNum> <DisplayInfo>1</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="Account Location"> <UName>[Account Location].[All Locations].[Mexico]</UName> <Caption>Mexico</Caption> <LName>[Account Location].[Country]</LName> <LNum>1</LNum> <DisplayInfo>131081</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="Account Location"> <UName>[Account Location].[All Locations].[uSA]</UName> <Caption>USA</Caption> <LName>[Account Location].[Country]</LName> <LNum>1</LNum> <DisplayInfo>131075</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> <Axis name="SlicerAxis"> <Tuples> <Tuple> <Member Hierarchy="Start Period"> <UName>[start Period].[All Periods]</UName> <Caption>All Periods</Caption> <LName>[start Period].[(All)]</LName> <LNum>0</LNum> <DisplayInfo>5</DisplayInfo> </Member> <Member Hierarchy="Close Period"> <UName>[Close Period].[All Periods]</UName> <Caption>All Periods</Caption> <LName>[Close Period].[(All)]</LName> <LNum>0</LNum> <DisplayInfo>5</DisplayInfo> </Member> <Member Hierarchy="Sale State"> <UName>[sale State].[All Types]</UName> <Caption>All Types</Caption> <LName>[sale State].[(All)]</LName> <LNum>0</LNum> <DisplayInfo>10</DisplayInfo> </Member> <Member Hierarchy="Sales Person"> <UName>[sales Person].[All Sales People]</UName> <Caption>All Sales People</Caption> <LName>[sales Person].[(All)]</LName> <LNum>0</LNum> <DisplayInfo>4</DisplayInfo> </Member> <Member Hierarchy="Account Categorization"> <UName>[Account Categorization].[All Accounts]</UName> <Caption>All Accounts</Caption> <LName>[Account Categorization].[(All)]</LName> <LNum>0</LNum> <DisplayInfo>7</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> </Axes> <CellData> <Cell CellOrdinal="0"> <Value xsi:type="xsd:int">880</Value> <FmtValue>880</FmtValue> <FormatString>#,##0</FormatString> </Cell> <Cell CellOrdinal="1"> <Value xsi:type="xsd:int">529</Value> <FmtValue>529</FmtValue> <FormatString>#,##0</FormatString> </Cell> <Cell CellOrdinal="2"> <Value xsi:type="xsd:int">3447</Value> <FmtValue>3,447</FmtValue> <FormatString>#,##0</FormatString> </Cell> </CellData> </root> </xmla:return> </xmla:ExecuteResponse> </SOAP-ENV:Body> </SOAP-ENV:Envelope> 19:58:00,663 ERROR ManagementService,http-8080-Processor23:1225 - caught Throwable exception: Invalid field mapping "[Measures].[Number of Sales]". net.sf.jasperreports.engine.JRRuntimeException: Invalid field mapping "[Measures].[Number of Sales]". at net.sf.jasperreports.olap.JROlapDataSource.init(JROlapDataSource.java:248) at net.sf.jasperreports.olap.JROlapDataSource.<init>(JROlapDataSource.java:113) at net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuter.createDatasource(JRXmlaQueryExecuter.java:122) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:676) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:596) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1223) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:853) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:439) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:748) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:367) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:876) 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:301) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.execute(AdhocEngineServiceImpl.java:1535) at com.jaspersoft.jasperserver.ws.axis2.ManagementService.runReport(ManagementService.java:1148) 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.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 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.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:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PasswordExpirationProcessingFilter.doFilter(PasswordExpirationProcessingFilter.java:85) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:182) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.JIPortletAuthenticationProcessingFilter.doFilter(JIPortletAuthenticationProcessingFilter.java:87) 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)

yeah - 3.5.0 did not have it if I recall

wish I could help you but I am neck deep in the same garbage debugging exercise :-( i can only add sympathy - java error messages are rubbish (cr*@!p) when you are really trying to work with a product

Use iReport netbeans 3.5.1, connect to the repository, browse to the file, right click, open in editor. Only way as far as I know I have asked -- and got no response

Would it not work to create the report definition using an input parameter as the report datasource like you do for sub-reports. Then pass that as a parameter in the SOAP call ?

Issue 2765255 raised on Tracker

Yeah - any idea how to get a developer to take a look for us ?

There is already a CSV datasource so I don't need to write one for that. The trick is a custom datasource I think that allows a user to access local resources at runtime. Which I think will involve finding some jsp that provides a file browse control and adding that into DefaultParametersForm.jsp. Also not so simple because I cannot just pass the filename as a paramater to the report because the server will not be able to access that file. The input control has to upload the file into memeory and use it while running the main report.

JasperServer does work through Liferay which provides authentication (and authorisation I believe) in a JSR168 portlet. Maybe using the jasperserver WAR would be a solution for you ? Otherwise, each report in the Jasperserver is accessed via a URL. You could probably hide all the URLs in your application and load them as part of your application. Or use JasperReports and just embed the reports. But I assume you want to use JasperServer for a particular reason (scheduling, dashboards perhaps). Post Edited by Glen Bremner-Stokes at 04/02/09 12:18

I have built a report that uses a csv with a list of customer numbers as input. The report reads the csv into the main report and then retrieves customer details from a database and prints them in a subreport. All fine if I run this in iReport. The challenge I have is : 1. the report needs to run from the JasperServer (3.5) and 2. the csv is a file that will be on the users local machine (exact filename and directory will vary each time) So the idea is for the report on the JasperServer to have an input control which 1. allows the user to browse their local directory and select the right csv file 2. then read the contents of that file and use it as an input list into the main report Hopefully that use case is clear. I have spent a few days hunting through samples of custom input controls and datasources but I cannot find a suitable solution. Suggestions / Solutions much appreciated.