sure919 Posted July 22, 2008 Share Posted July 22, 2008 Hello, I am getting errors while trying to deplpoy my report (with query language as XMLA-MDX which runs fine on Jasper Studio) on Jasper Server. the error message isNo query executer factory class registered for xmla-mdx queries. Create a propery named net.sf.jasperreports.query.executer.factory.xmla-mdxWhat changes I have to make to deploy the xmla-mdx based reports.Looking for the kindest reply,thanks,Sure Link to comment Share on other sites More sharing options...
lucianc Posted July 22, 2008 Share Posted July 22, 2008 What you need to do is to is to edit $TOMCAT/webapps/jasperserver/WEB-INF/classes/jasperreports.properties and add the following line:net.sf.jasperreports.query.executer.factory.xmla-mdx=net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuterFactoryHTH,Lucian Link to comment Share on other sites More sharing options...
sure919 Posted July 23, 2008 Author Share Posted July 23, 2008 Thanks Lucian,I tried setting the propertynet.sf.jasperreports.query.executer.factory.xmla-mdx=com.cincom.jasperreports.JRXmlaQueryExecuterFactoryThe reports doesnt throw error upon execution but doesnt show result either. It displayed the following WARN Messages on Tomcat console14:43:30,953 WARN JRXmlaQueryExecuter,http-8080-Processor22:62 - The supplied url is null.14:43:30,969 WARN JRXmlaQueryExecuter,http-8080-Processor22:71 - The supplied datasource is null14:43:30,969 WARN JRXmlaQueryExecuter,http-8080-Processor22:80 - The supplied catalog is null. indicating that the XMLA connection parameters are not being passed.Any help is great!!Thanks,sure Link to comment Share on other sites More sharing options...
sure919 Posted July 23, 2008 Author Share Posted July 23, 2008 Thanks Lucian,I tried setting the propertynet.sf.jasperreports.query.executer.factory.xmla-mdx=com.cincom.jasperreports.JRXmlaQueryExecuterFactoryThe reports doesnt throw error upon execution but doesnt show result either. It displayed the following WARN Messages on Tomcat console14:43:30,953 WARN JRXmlaQueryExecuter,http-8080-Processor22:62 - The supplied url is null.14:43:30,969 WARN JRXmlaQueryExecuter,http-8080-Processor22:71 - The supplied datasource is null14:43:30,969 WARN JRXmlaQueryExecuter,http-8080-Processor22:80 - The supplied catalog is null. indicating that the XMLA connection parameters are not being passed.Any help is great!!Thanks,sure Link to comment Share on other sites More sharing options...
lucianc Posted July 23, 2008 Share Posted July 23, 2008 Are you using a XMLA connection as report data source in JasperServer?Regards,Lucian Link to comment Share on other sites More sharing options...
sure919 Posted July 23, 2008 Author Share Posted July 23, 2008 Hi LucianThanks for replyingI am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.hope this helps you to understand what i am doing.Thanks,Sure Link to comment Share on other sites More sharing options...
sure919 Posted July 23, 2008 Author Share Posted July 23, 2008 Hi LucianThanks for replyingI am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.hope this helps you to understand what i am doing.Thanks,Sure Link to comment Share on other sites More sharing options...
sure919 Posted July 23, 2008 Author Share Posted July 23, 2008 Hi LucianThanks for replyingI am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.hope this helps you to understand what i am doing.Thanks,Sure Link to comment Share on other sites More sharing options...
lucianc Posted July 23, 2008 Share Posted July 23, 2008 What JasperServer version are you using?The JasperServer sample data includes a report defined on a XML/A data source (at /analysis/reports/FoodmartSalesXmlaReport). Do you have the sample data loaded into JasperServer? If so, can you try the sample XML/A report and see whether it works?Regards,Lucian Link to comment Share on other sites More sharing options...
sure919 Posted July 24, 2008 Author Share Posted July 24, 2008 Dear Lucian,That report is working but has the query language as "mdx" and all my reports have query language as "xmla-mdx".is there any work around for deploying "xmla-mdx" based reports?Thanks,Sure Link to comment Share on other sites More sharing options...
sure919 Posted July 24, 2008 Author Share Posted July 24, 2008 Dear Lucian,I have my Dashboards working in Jasper Studio (when using xmla-mdx) is there any eary way to deploy them on Jasper Server (i am using 2.0.1),As an alternative i also able to deploy reports with modifications (using mdx as query language) on JS but have issues when I deploy the Dashboard. the issue is that the sub-reports are not getting displayed.Any help is highly valuable for me.Thanks,Sure Link to comment Share on other sites More sharing options...
lucianc Posted July 24, 2008 Share Posted July 24, 2008 That report is working but has the query language as "mdx" and all my reports have query language as "xmla-mdx". is there any work around for deploying "xmla-mdx" based reports? Did you set the net.sf.jasperreports.query.executer.factory.xmla-mdx property?If you change the sample's report query language, does it work? Link to comment Share on other sites More sharing options...
lucianc Posted July 24, 2008 Share Posted July 24, 2008 I have my Dashboards working in Jasper Studio (when using xmla-mdx) is there any eary way to deploy them on Jasper Server (i am using 2.0.1), As an alternative i also able to deploy reports with modifications (using mdx as query language) on JS but have issues when I deploy the Dashboard. the issue is that the sub-reports are not getting displayed. I assume that a dashboard is a (master) report that includes several subreports. When you deploy it to JasperServer, do you use a XMLA connection as dashboard report data source? If so, do you pass the master connection parameters to the subreports?Regards,Lucian Link to comment Share on other sites More sharing options...
sure919 Posted July 25, 2008 Author Share Posted July 25, 2008 I'd set the property and copied the cincom-jr-xmla.jar and rex.jar ; but then the report never shows the result added to that i see warn messages on the tomcat console saying URL, Datasource and catalog are null.... Link to comment Share on other sites More sharing options...
lucianc Posted July 25, 2008 Share Posted July 25, 2008 I don't know what cincom-jr-xmla.jar is. Aren't you using the built-in JasperReports XML/A query executer?Regards,Lucian Link to comment Share on other sites More sharing options...
biaggi Posted July 31, 2008 Share Posted July 31, 2008 You need to copy the cincom and rex jars from ireport/lib to WEB-APP/lib and create a spring bean as data source for the report :) that bean will give the connection information to the report, but you must set the parameters as I explain in this posthttp://www.jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=42893 else youll keep getting the messages URL is null, catalog is null ... Thats works for me :) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now