syntel

Hi, I tried to generate jasper report in java using an xml datasource.I get the following exception while running it as a java application:java.lang.SecurityException: class "org.apache.commons.digester.SetNestedPropertiesRule"'s signer information does not match signer information of other classes in the same packageNative Method)JRXmlLoader.java:203)JRXmlLoader.java:168)JRXmlLoader.java:152)JasperCompileManager.java:150)JasperTest.java:39) I am clueless as to what the problem is.I am a newbie to jasper reports.Please help me with this issue.Thanks in advance. Exception in thread "main" at java.lang.ClassLoader.checkCerts(Unknown Source) at java.lang.ClassLoader.preDefineClass(Unknown Source) at java.lang.ClassLoader.defineClass(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$100(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged( at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at net.sf.jasperreports.engine.xml.JRXmlLoader.load( at net.sf.jasperreports.engine.xml.JRXmlLoader.load( at net.sf.jasperreports.engine.xml.JRXmlLoader.load( at net.sf.jasperreports.engine.JasperCompileManager.compileReport( at JasperTest.main( Code:import java.util.HashMap; import net.sf.jasperreports.engine.JREmptyDataSource;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JasperCompileManager;import net.sf.jasperreports.engine.JasperExportManager;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperReport;import net.sf.jasperreports.engine.data.JRXmlDataSource; public class JasperTest { public static void main(String args[]) { JasperReport jasperReport; try{ jasperReport = JasperCompileManager.compileReport("D:/workspace/control/BarcodeSample/sample.jrxml"); // String reportFileName = "/addressbook.jasper"; String outFileName = "D:/workspace/control/BarcodeSample/addressbook.pdf"; String xmlFileName = "D:/workspace/control/BarcodeSample/addressbook.xml"; String recordPath = "/addressbook/category/person"; JRXmlDataSource jrxmlds; jrxmlds = new JRXmlDataSource(xmlFileName,recordPath); JasperPrint jasperPrint; jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap(), jrxmlds); //generates PDFJasperExportManager.exportReportToPdfFile(jasperPrint, outFileName); //generates HTML //generates XML }catch(JRException jrException){jrException.printStackTrace(); }}}

Thats true, I did generated Analysis Report as the final output using Views. But the my current problem is, I am unable to generate mondrian.xml using Views via Workbench, According to the first snapshot I am not getting any view name from the DB using workbench. All I get is a column called alias. According to the second snapshot I am able to see the list of the tables from the DB using workbenchBut , I did generated my mondrian.xml using Views via CubeDesigner. But my development envronment is suppose to be workbench . Hence my qusetion is using Workbench, like I can see the list of tables, is there any way that I can see the list of of database views? Note - I am currently working with Workbench-3.5.4 & postgresql. Just now I noticed that views are also getting listed along with tables. However, let me verify it again. Post Edited by syntel at 07/17/2009 12:27

Hi, For any dabase operation, we can treat views similar to tables. Hence, can you please confirm whether database views instead of tables can be used for Analysis Report.

Hi,As part of my POC, I was asked to generate a Business Intelligence Analysis report using any free tool . I ended up completing two seperate POC one using Jasper Server and the other using Jpivot (deploying Jsp custom tags in tomcat). Now I am unable to decide whether to use Jasper Server / Jpivot for my Project. But I am sure there should be some appropriate situation as to when we should go for Jasper Server or JPivot. I beleive, using Jasper Server and JPivot tags together in the same project doesen't make any sense.As per my understanding both can be used for generating BI Analysis Report in its own way. But I cant think beyond that.Can you distinguish and also find out the similarities by comparing Jasper Server Vs Jpivot, and also let me know the Pros & Cons ? Post Edited by syntel at 07/14/2009 10:59

When I enter all the connection details like Driver,URL,username,password etc in the Jasper Server console V3.5, and click test connection, all I get is test failed. Is there any detailed log available in any folder, to get exception reason as because of which invalid parameter the test connection is failing. Test failed is a very high level reason and it is difficult to debug particularly when you feel all the connection paratemetrs provided is correct. Post Edited by syntel at 07/14/2009 15:08

I am not clear with your phrase, " What I found to be the problem was when I imported the backup from 3.0, the encypted passwords for my db connections were re-encrypted with the 3.5 import.", To the best of my knowledge, I am not importing any backup from my previous version for my db connections. I am re-typing all the connection details manually (including the password) in the jasperserver console server. Because of this connection problem which occurs in V3.5, I am forced to use the older version of jasper server.

Code:Hi,Can anyone tell me what is the problem with this MDX query:select {[Measures].[Marks]} ON COLUMNS, NON EMPTY Crossjoin(Hierarchize({[Department],[student]})) ON ROWSfrom [student Analysis]The error I got for this MDX query in jasper server version 2.1 is : The following is not a valid MDX Query: Mondrian Error:All arguments to function '{}' must have same hierarchy. I used this schema:<?xml version="1.0"?> <Schema name="CollegeSchema"><!-- Shared dimensions --> <Dimension name="College"> <Hierarchy hasAll="true" allMemberName="All Colleges" primaryKey="CollegeCode"> <Table scheme ="College" name="College"/> <Level name="College" column="CollegeName" uniqueMembers="true"/> </Hierarchy> </Dimension> <Dimension name="Department"> <Hierarchy hasAll="true" allMemberName="All Departments" primaryKey="DeptCode"> <Table scheme ="College" name="Department"/> <Level name="Department" column="DeptName" uniqueMembers="true"/> </Hierarchy> </Dimension><Dimension name="Student"> <Hierarchy hasAll="true" allMemberName="All Students" primaryKey="StudentId"> <Table scheme ="College" name="Student"/> <Level name="Students" column="StudentName" uniqueMembers="true"/> </Hierarchy> </Dimension> <Cube name="Student Analysis"> <Table scheme ="College" name="Student"/> <DimensionUsage name="College" source="College" foreignKey="CollegeCode"/> <DimensionUsage name="Department" source="Department" foreignKey="DeptCode" /> <DimensionUsage name="Student" source="Student"/> <Measure name="Marks" column="Mark" aggregator="sum" formatString="#,###.00"/><!-- <CalculatedMember name="Variance Percent" dimension="Measures" formula="([Measures].[Variance]/[Measures].[budget])*100" /> --> </Cube></Schema>My Table Details:Student table use CollegeCode and DeptCode as foreign KeyCollege table and Department Table are individual tables. Post Edited by syntel at 07/15/2009 09:26 Code:[code] ghccccccccccccccccccccccccccccccccccccccccccccccccccc Post Edited by syntel at 07/15/2009 09:28 Code:[code]The following is not a valid MDX Query: Mondrian Error:All arguments to function ‘{}’ must have same hierarchy. Post Edited by syntel at 07/15/2009 09:31

Hi , I am trying to create an analysis view with JasperServer 2.1 version.I am able to open my analysis view but when I try to drill down I am getting the below mentioned exception. Code: My Schema file and MDX query are as follows,for your information: Schema: <?xml version="1.0"?> <Schema name="CollegeSchema"> <!-- Shared dimensions --> <Dimension name="College"> <Hierarchy hasAll="true" allMemberName="All Colleges" primaryKey="CollegeCode"> <Table scheme ="College" name="College"/> <Level name="College" column="CollegeName" uniqueMembers="true"/> </Hierarchy> </Dimension> <Dimension name="Department"> <Hierarchy hasAll="true" allMemberName="All Departments" primaryKey="DeptCode"> <Table scheme ="College" name="Department"/> <Level name="Department" column="DeptName" uniqueMembers="true"/> </Hierarchy> </Dimension> <Dimension name="Student"> <Hierarchy hasAll="true" allMemberName="All Students" primaryKey="StudentId"> <Table scheme ="College" name="Student"/> <Level name="Students" column="StudentName" uniqueMembers="true"/> </Hierarchy> </Dimension> <Cube name="Student Analysis"> <Table scheme ="College" name="Student"/> <DimensionUsage name="College" source="College" foreignKey="CollegeCode"/> <DimensionUsage name="Department" source="Department" foreignKey="DeptCode" /> <DimensionUsage name="Student" source="Student"/> <Measure name="Marks" column="Mark" aggregator="sum" formatString="#,###.00"/> <!-- <CalculatedMember name="Variance Percent" dimension="Measures" formula="([Measures].[Variance]/[Measures].[budget])*100" /> --> </Cube> </Schema> MDX Query: Select {[Measures].[Marks]} ON COLUMNS, {([College],[Department],[student])} ON ROWS from [student Analysis] Any help please? Thanks. Post Edited by syntel at 07/13/2009 13:44

Hi, I want to work with a schema workbench to create the xml schema file which I will later upload in the jasperserver to create an analysis view .I used Jasperserver version 3.5.0 .The jdk version I use is jdk 1.5.0_11.When I tried to run the .bat file of workbench version 3.5.4 I am getting the following exception. Code: I guess this is an incompatibility issue.But where does the problem lie?Is it with my jdk version or the workbench version?Please tell me how to resolve this.Also please tell me which are the compatible versions of jdk/workbench for jasper server versions 2.1 and 3.1 and also where to download those workbenches. Thanks. Post Edited by syntel at 07/13/2009 13:36

Hi, Let me eloborate the above issue. I am using Jasper Server V2.1. in Windows OS as a jasperadmin user with default role settings, I logged into jasper server console and uploaded my schema xml file which has cube definitions. I tried to use a locally defined jdbc connection and entered all the connection details like Driver,URL,username,password etc..When I tested the connection the test was successful. But when I tried the same jdbc connection with the same connection details in Jasper Server V3.5 the connection test failed. I am clueless how this happens.Any suggestions would be of great help. Post Edited by syntel at 07/13/2009 08:42

Hi, The Database test connection parameters which worked in Jaspet Server V2.1 is not working in V3.5. Any body has faced this problem so far ? Post Edited by syntel at 07/13/2009 08:39 Post Edited by syntel at 07/13/2009 08:43