ktrinad's Content - Jaspersoft Community

ireport et PHP : FATAL ERROR:NO USABLE FONTS

By: eric - greatmaster ireport et PHP : FATAL ERROR:NO USABLE FONTS 2003-11-27 07:55 Hi, i'm trying to use ireport with PHP by calling the ireport and JASPER api from PHP. Then i call a java class to compile reports and modify on the fly parameters. I use php on APACHE with CGI. I have a FATAL ERROR:NO USABLE FONTS FOUND when i try to modify the .XML with the ireport API. Is there someone who ever tried that ??? What is this error ? Thanks eric the code of my class follows : <code> import dori.jasper.engine.*; import dori.jasper.view.*; import it.businesslogic.ireport.connection.*; import it.businesslogic.ireport.*; import java.util.*; import java.lang.*; public class PHPJRConnector { private HashMap parametres; public PHPJRConnector(){ this.parametres = new HashMap(); } public String run(String srcFileName, String dstFileName) { try { dori.jasper.engine.JasperPrint print=null; dori.jasper.engine.JRExporter exporter=null; //////////////////////////////////////////////// // CONNEXION A LA BASE DE DONNEES //////////////////////////////////////////////// JDBCConnection maConnection = new JDBCConnection(); maConnection.setJDBCDriver("com.mysql.jdbc.Driver"); maConnection.setUrl("jdbc:mysql://dep.ac-orleans-tours.fr/deptest"); //maConnection.setDatabase("deptest"); maConnection.setUsername("dep"); maConnection.setPassword("pozv68"); //////////////////////////////////////////////// // EXPORTATION DU RAPPORT EN PDF //////////////////////////////////////////////// print = dori.jasper.engine.JasperFillManager.fillReport( srcFileName, null, maConnection.getConnection()); exporter = new dori.jasper.engine.export.JRPdfExporter(); exporter.setParameter( JRExporterParameter.OUTPUT_FILE_NAME,dstFileName); exporter.setParameter( JRExporterParameter.JASPER_PRINT,print); exporter.exportReport(); return "YES"; } catch (Exception ex) { return "ERREUR!"; } } public void addParametre(String nom,String valeur){ //System.out.print(nom+" "+valeur+" "+this.parametres); this.parametres.put(nom,valeur); } public HashMap getParametres(){ return parametres; } public void modifieXML(String srcFileName, String dstFileName){ HashMap m = this.getParametres(); Report rapport = new Report(srcFileName); Vector v = new Vector(); // Ajouter deux param tres /* JRParameter p1 = new JRParameter("session","java.lang.String",false); p1.setDefaultValueExpression("new String("2002")"); v.add(p1); JRParameter p2 = new JRParameter("serie","java.lang.String",false); p2.setDefaultValueExpression("new String("S-SCI")"); v.add(p2); */ // Modifier des param tres existants v = rapport.getParameters(); Enumeration enum = v.elements(); while (enum.hasMoreElements()) { it.businesslogic.ireport.JRParameter p = (it.businesslogic.ireport.JRParameter)enum.nextElement(); if (m.containsKey(p.getName().toString())) p.setDefaultValueExpression(m.get(p.getName()).toString()); } rapport.setParameters(v); rapport.saveXMLFile(dstFileName); } public void compileXML(String srcXML,String dstJASPER){ JasperCompileManager compilateur = new JasperCompileManager(); try{ compilateur.compileReportToFile(srcXML, dstJASPER); System.out.print(" OK :-)"); }catch (JRException jrex){ System.out.print("ERREURS de compilation :-("); } } } </code> By: Giulio Toffoli - gt78SourceForge.net SubscriberProject Admin RE: ireport et PHP : FATAL ERROR:NO USABLE FONTS 2003-11-27 08:16 Try to test your class outside PHP. Check that you have an Xserver running (or java 1.4 with the parameter java.awt.headless=true, or xvb running). BE sure that your fonts (if you use TTF fonts) are in the classpath. Could be an error in XML, be sure that your pdf text encoding for textfields is set to Cp1250 and not CP1259 (note the case of the first two chars). Giulio By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-27 23:51 i tested my class in a JAVA environment by calling it in a main function. It works fine, i generate without any problem the PDF. I'm going to see the fonts, i'm under win32, with apache. I didn't know that it uses TTF fonts. And i'm going to see the java.awt.headless=true. It's a parameter to put in php ???? thanks a lot for the help !!! see you very soon ! By: Giulio Toffoli - gt78SourceForge.net SubscriberProject Admin RE: ireport et PHP : FATAL ERROR:NO USABLE FONTS 2003-11-28 00:52 java.awt.headless is not useful under win32. So the problem is not here. What means "when i try to modify the .XML with the ireport API" ? What are you doing exactly? Giulio By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-28 04:12 i'm trying to add a parameter to .xml representing the report i build with ireport. But, in order to pass parameters dynamicly to the report i must modify this .xml and recompile it and then export the PDF. That's what i try to do . I manage to do this in pure JAVA but when i call the java class from php i have an error !!! to be continued ... By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-28 04:18 " Could be an error in XML, be sure that your pdf text encoding for textfields is set to Cp1250 and not CP1259 (note the case of the first two chars). " what do you mean when you say this ? How can i change this encoding for textfields ? eric By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-28 04:37 the error happens when i try to call this JAVA method : public void modifieXML(String srcFileName, String dstFileName){ HashMap m = this.getParametres(); Report rapport = new Report(srcFileName); Vector v = new Vector(); // Modifier des param tres existants v = rapport.getParameters(); Enumeration enum = v.elements(); while (enum.hasMoreElements()) { it.businesslogic.ireport.JRParameter p = (it.businesslogic.ireport.JRParameter)enum.nextElement(); if (m.containsKey(p.getName().toString())) p.setDefaultValueExpression(m.get(p.getName()).toString()); } rapport.setParameters(v); rapport.saveXMLFile(dstFileName); } I added the ttf fonts located in c:windowsfonts but no change i have always the same error in APACHE log: FATAL ERROR : NO USABLE FONTS FOUND However calling this method (i use NETBEANS) in a java main causes no problems !! So ? I'm going to take a look to the it.businesslogic.ireport.Report class to see what it needs !!!! ... By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-28 04:58 my pdfencoding is CP1252 is it correct ? eric By: Giulio Toffoli - gt78SourceForge.net SubscriberProject Admin RE: ireport et PHP : FATAL ERROR:NO USABLE FONTS 2003-11-28 05:00 I dont understand why you are using a similar method to set parameters value... Is as set global variables in a program and recompile before start it instead to simply pass parameters on a command line! Anyway, an attribute of textfield tag in XML is pdfEncoding. In certain cases iReport put an invalid value (CPXXXX instead CpXXXX). This can be result in a font error. You have only to open the XML file loaded as src to check the encoding used. Anyway the problem is throwed when the print is generated, and not saving the XML.... Take a look to the it.businesslogic.ireport.Report class is a good start of point. Only a little think. iReport is GPLed, not LGPL, so the use of the *code* of iReport or part of it (not JasperReports) is covered by GPL license and it's not fisible use this code in commercial solutions. I'm sure that your work is covered by a GPL license. If not you should ask for a proper license. I hope this helps you. Giulio Giulio By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-28 06:42 i changed my pdfEncoding="CP1252" in pdfEncoding="Cp1252" but no improvement !!!! always FATAL ERROR:NO USABLE FONT FOUND ARE the correct fonts in the ireport or jasperreport packages or in WINDOWS ? One more question : i need to generate pdf relative to parameter choosen by users in a php form. So How could i do this without modifying the .xml files and recompile them ????? thanks a lot for support :-) By: Giulio Toffoli - gt78SourceForge.net SubscriberProject Admin RE: ireport et PHP : FATAL ERROR:NO USABLE FONTS 2003-11-28 08:13 A parameter is a think that can be have a default value, but generally the value is supplied by the user. The core jasperReports method to fill a report is: fillReport This method take as function parameter an HashMap trought wich you can pass to report engine values for parameters. Example: java.util.HashMap map = new java.util.HashMap(); map.put("IDCustomer",new Integer(1234)); String customer_report = "com/elvox/catalog/print/customer.jasper"; dori.jasper.engine.JasperPrint print=null; dori.jasper.engine.JasperReport report = dori.jasper.engine.JasperManager.loadReport(cl.getResourceAsStream( customer_report )); print = dori.jasper.engine.JasperFillManager.fillReport( report , map,this.getConnection()); dori.jasper.engine.JRExporter exporter = new dori.jasper.engine.export.JRPdfExporter(); String fileName = "customer.pdf"; exporter.setParameter(dori.jasper.engine.JRExporterParameter.OUTPUT_FILE_NAME,fileName); exporter.setParameter(dori.jasper.engine.JRExporterParameter.JASPER_PRINT,print); exporter.exportReport(); ______________________________ Giulio By: eric - greatmaster RE: ireport et PHP : FATAL ERROR:NO USABLE FO 2003-11-28 08:14 The fonts used in the XML are SansSerif and Helvetica. But i don't have sansSerif.ttf in the c:windowsfonts i put in the classpath. How could i know the name of the fonts mentionned in the XML ? Here is the XML of my report : <?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="notesAuBac" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <parameter name="session" isForPrompting="false" class="java.lang.String"/> <parameter name="serie" isForPrompting="false" class="java.lang.String"/> <queryString><![CDATA[sELECT * FROM `etat_BCG` WHERE session LIKE '$P!{session}%' and serie LIKE '$P!{serie}%' ORDER BY session, cod_eta, serie, mati re]]></queryString> <field name="identifiant_s rie" class="java.lang.String"/> <field name="candidatsAcad mie" class="java.lang.Double"/> <field name="candidats" class="java.lang.Integer"/> <field name="ecartEtab" class="java.lang.Double"/> <field name="moyEtab" class="java.lang.Double"/> <field name="maxiAcad" class="java.lang.Double"/> <field name="miniAcad" class="java.lang.Double"/> <field name="mediAcad" class="java.lang.Double"/> <field name="moyAcad" class="java.lang.Double"/> <field name="mati re" class="java.lang.String"/> <field name="cod_mat" class="java.lang.String"/> <field name="libelle_court_diplome" class="java.lang.String"/> <field name="cod_osp" class="java.lang.String"/> <field name="cod_spe" class="java.lang.String"/> <field name="libelle_etab" class="java.lang.String"/> <field name="uaidnc" class="java.lang.String"/> <field name="uaidnp" class="java.lang.String"/> <field name="cod_eta" class="java.lang.String"/> <field name="serie" class="java.lang.String"/> <field name="session" class="java.lang.String"/> <field name="libelle_long_diplome" class="java.lang.String"/> <group name="session" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{session}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <group name="cod_eta" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{cod_eta}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="21" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="5" y="0" width="524" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </rectangle> <line direction="TopDown"> <reportElement mode="Opaque" x="135" y="0" width="0" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="388" y="0" width="0" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="10" y="3" width="122" height="13" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[Nombre de candidats]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="#" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="139" y="3" width="244" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{candidatsAcad mie}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="391" y="3" width="133" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{candidats}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <group name="serie" isStartNewColumn="false" isStartNewPage="true" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{serie}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="13" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="7" y="2" width="178" height="11" forecolor="#CCCCCC" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[Notes au Baccalaur at]]></text> </staticText> </band> </title> <pageHeader> <band height="101" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="135" y="51" width="394" height="29" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToBottom" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </rectangle> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="8" y="5" width="518" height="22" forecolor="#41237E" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{uaidnp} + " " + $F{uaidnc}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="7" y="29" width="79" height="16" forecolor="#41237E" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[baccalaur at]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="89" y="29" width="314" height="16" forecolor="#41237E" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{libelle_long_diplome}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="411" y="29" width="48" height="16" forecolor="#41237E" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <text><![CDATA[session]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="460" y="29" width="50" height="16" forecolor="#41237E" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{session}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="144" y="56" width="239" height="17" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Acad mie]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="393" y="56" width="124" height="17" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Etablissement]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="388" y="51" width="0" height="28" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <rectangle radius="0" > <reportElement mode="Opaque" x="5" y="78" width="524" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </rectangle> <line direction="BottomUp"> <reportElement mode="Opaque" x="135" y="78" width="0" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="12" y="80" width="117" height="17" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[Epreuve]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="137" y="79" width="60" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[moyenne]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="201" y="79" width="61" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[m diane]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="265" y="79" width="59" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[minimum]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="329" y="79" width="56" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[maximum]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="200" y="78" width="0" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="264" y="78" width="0" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="328" y="78" width="0" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="388" y="78" width="0" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="393" y="79" width="59" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[moyenne]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="465" y="79" width="59" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <text><![CDATA[ cart acad mie]]></text> </staticText> <line direction="TopDown"> <reportElement mode="Opaque" x="458" y="78" width="0" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="22" isSplitAllowed="true" > <rectangle radius="0" > <reportElement mode="Opaque" x="5" y="0" width="524" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </rectangle> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="8" y="2" width="123" height="16" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mati re}]]></textFieldExpression> </textField> <line direction="BottomUp"> <reportElement mode="Opaque" x="135" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="BottomUp"> <reportElement mode="Opaque" x="200" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="BottomUp"> <reportElement mode="Opaque" x="264" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="BottomUp"> <reportElement mode="Opaque" x="328" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="BottomUp"> <reportElement mode="Opaque" x="388" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="BottomUp"> <reportElement mode="Opaque" x="458" y="0" width="0" height="21" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="##.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="138" y="4" width="52" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{moyAcad}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="##.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="203" y="4" width="52" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{mediAcad}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="##.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="268" y="4" width="52" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{miniAcad}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="##.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="331" y="4" width="52" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{maxiAcad}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="##.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="394" y="4" width="52" height="11" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{moyEtab}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#0.00" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="465" y="4" width="52" height="11" forecolor="#000000" backcolor="#

Login Problem

ktrinad posted a topic in Products

By: YSutarko - ysutarko Login Problem 2006-07-11 00:17 Hi, 1. downloaded JasperIntelligence-1.0.1-bin 2. installed mysql-essential-5.0.22-win32.msi 3. extracted the jasperserver.war and modify the context.xml so it can connect to mysql using user jasperadmin / jasperadmin 4. tried to run ji-import.bat --import-path=ji-catalog --import-file=ji-catalog.xml but encountered this problem : ExportImportCommand: START import dirname value=ji-catalog import filename value=ji-catalog.xml ExportImportCommand: - running PROD Env mode ExportImportCommand: caught exception, exception: Error registering bean with name 'olapConnectionService' defined in class path resource [applicationContext-for-export.xml]: Unexpected failure during bean definition parsing; nested exception is java.lang.UnsupportedClassVersionError: com/tonbeller/jpivot/olap/model/OlapModel (Unsupported major.minor version 49.0) org.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'olapConnectionService' defined in class path resource [applicationContext-for-export.xml]: Unexpected failure during bean definition parsing; nested exception is java.lang.UnsupportedClassVersionError: com/tonbeller/jpivot/olap/model/OlapModel (Unsupported major.minor version 49.0) java.lang.UnsupportedClassVersionError: com/tonbeller/jpivot/olap/model/OlapModel (Unsupported major.minor version 49.0) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:539) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at java.net.URLClassLoader.defineClass(URLClassLoader.java:251) at java.net.URLClassLoader.access$100(URLClassLoader.java:55) at java.net.URLClassLoader$1.run(URLClassLoader.java:194) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:219) at org.springframework.util.ClassUtils.forName(ClassUtils.java:108) at org.springframework.beans.factory.support.BeanDefinitionReaderUtils.createBeanDefinition(BeanDefinitionReaderUtils.java:65) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:565) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:531) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseDefaultElement(DefaultXmlBeanDefinitionParser.java:397) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitions(DefaultXmlBeanDefinitionParser.java:371) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.registerBeanDefinitions(DefaultXmlBeanDefinitionParser.java:206) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:388) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:259) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:209) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:184) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:128) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:144) at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:113) at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:81) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:89) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:279) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:87) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:72) at com.jaspersoft.jasperserver.util.ExportImportCommand.setUpRepositoryConnections(ExportImportCommand.java:671) at com.jaspersoft.jasperserver.util.ExportImportCommand.runImport(ExportImportCommand.java:187) at com.jaspersoft.jasperserver.util.ExportImportCommand.main(ExportImportCommand.java:106) [JPivot] 11 Jul 2006 14:04:36,315 ERROR [session ] com.jaspersoft.jasperserver.util.ImportResource#process: ERROR: caught exception unmarshalling catalog, file=ji-catalog/ji-catalog.xml, exception: null java.lang.NullPointerException at com.jaspersoft.jasperserver.util.ImportResource.getAllRoles(ImportResource.java:1096) at com.jaspersoft.jasperserver.util.ImportResource.process(ImportResource.java:885) at com.jaspersoft.jasperserver.util.ImportResource.processUsersRoles(ImportResource.java:252) at com.jaspersoft.jasperserver.util.ImportResource.process(ImportResource.java:163) at com.jaspersoft.jasperserver.util.ExportImportCommand.runImport(ExportImportCommand.java:197) at com.jaspersoft.jasperserver.util.ExportImportCommand.main(ExportImportCommand.java:106) ExportImportCommand: DONE 5. so i tried manually running the scripts like mysql -u jasperadmin -p Enter password: *********** Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 27 to server version: 5.0.22-community-nt Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> connect foodmart Connection id: 28 Current database: foodmart mysql> source FoodMart-MySQL-032006.sql // ...success executing script mysql> connect sugarcrm Connection id: 29 Current database: sugarcrm mysql> source db-dump-113005.sql // ...success executing script mysql> connect jasperserver Connection id: 31 Current database: jasperserver mysql> source jasperserverCreate.ddl // ...success executing script mysql> source jasperserverCreateDefaultSecurity.ddl // ...success executing script 6. deployed the war to tomcat, and started successfully 7. opened http://localhost/jasperserver and asked for user and password and tried these: - TestUser/newPassword - NewUser/newPassword - tomcat/tomcat - joeuser/joe i also peeked into the jasperserverCreateDefaultSecurity INSERT INTO `JSUser` (`username`,`fullname`,`emailAddress`,`password`,`externallyDefined`,`enabled`) VALUES ('anonymousUser','Anonymous User',NULL,'',0,1); INSERT INTO `JSUser` (`username`,`fullname`,`emailAddress`,`password`,`externallyDefined`,`enabled`) VALUES ('jasperadmin','Jasper Administrator',NULL,'newPassword',0,1); so i tried also: - anonymousUser/NULL (blank password) - jasperadmin/newPassword but it seems i cannot login , always rejected: Invalid credentials supplied. Could not login to JasperServer. with the log: 14:15:01,764 WARN LoggerListener,http-80-1:55 - Authentication event AuthenticationFailureBadCredentialsEvent: joeuser; details: org.acegisecurity.ui.WebAuthenticationDetails@fffe3f86: RemoteIpAddress: 128.21.32.104; SessionId: 8F0EB1B802DAF7D2EC2928414E6E949B; exception: Bad credentials 14:15:01,764 WARN JSCommonController,http-80-3:85 - There was a login error is this a bug, or am i missing something? can anyone help? thank you very much.. if you want, i can post the full log4j INFO when starting the tomcat instance regards, yusuf By: T Kavanagh - tkavanagh RE: Login Problem 2006-07-13 09:11 From the first exception stack trace that you included at the top of your post, it looks like there might be a problem with java versions. The released version of the JasperIntelligence application was compiled using java 1.5.xx. However, in our code we do not use any of the 1.5 features in order to be compliant with java 1.4. I am wondering if some java 1.5 code made it into the code base (or perhaps one of the dependent jars has a 1.5 dependency). In the stack trace: (Unsupported major.minor version 49.0) usually indicates a problem like this. Are you running with java 1.4? Is it possible to try under 1.5? (ie. in order to run the ji-import can have the sample data created). Regarding login... The default login that gets created by the jasperCreateDefaultSecurity.sql is jasperadmin/newPassword (note the uppercase in the pass). When the installation runs you are prompted to enter your own password for this user - but it seams this didn't work.

Problems starting JasperServer

ktrinad posted a topic in Products

By: BlueIced - blueiced Problems starting JasperServer 2006-09-02 04:54 Hello everyone, I have a problem with starting JasperServer. And the solutions provided previously don't seem to work or apply. I am using MySQL 5.0.22, Tomcat 5.5.15, JVM 1.4.2 and OS Fedora Core 5 (2.6.17-1.2174_FC5). I am not very familiar with Java, so I don't really know what all the errors mean. I have put the log below: Created MBeanServer with ID: [uID: 291184,1157196921924,-32768]:fedora.localdomain:1 2-Sep-06 1:35:24 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/i386 2-Sep-06 1:35:25 PM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 2-Sep-06 1:35:25 PM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 2599 ms 2-Sep-06 1:35:25 PM org.apache.catalina.core.StandardService start INFO: Starting service Catalina 2-Sep-06 1:35:25 PM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5.15 2-Sep-06 1:35:25 PM org.apache.catalina.core.StandardHost start INFO: XML validation disabled 2-Sep-06 1:35:25 PM org.apache.catalina.startup.HostConfig deployDescriptor SEVERE: Error deploying configuration descriptor jasperserver.xml 2-Sep-06 1:35:27 PM org.apache.catalina.startup.HostConfig deployDescriptor SEVERE: Error deploying configuration descriptor jasper.xml 2-Sep-06 1:35:29 PM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive jasper.war 2-Sep-06 1:35:29 PM org.apache.catalina.core.NamingContextListener addResource WARNING: Failed to register in JMX: javax.naming.NamingException: Cannot create resource instance 2-Sep-06 1:35:51 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() 2-Sep-06 1:35:51 PM org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextInitialized() 2-Sep-06 1:35:54 PM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() 2-Sep-06 1:35:55 PM org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextInitialized() 2-Sep-06 1:35:57 PM org.apache.catalina.core.ApplicationContext log INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]] log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: jasperserver.log (Permission denied) at gnu.java.nio.channels.FileChannelImpl.open(libgcj.so.7) at gnu.java.nio.channels.FileChannelImpl.<init>(libgcj.so.7) at java.io.FileOutputStream.<init>(libgcj.so.7) at java.io.FileOutputStream.<init>(libgcj.so.7) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:166) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:162) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:254) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:107) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:95) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:655) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:508) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:416) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:429) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:447) at org.apache.log4j.LogManager.<clinit>(LogManager.java:120) at java.lang.Class.initializeClass(libgcj.so.7) at org.apache.log4j.Logger.getLogger(Logger.java:104) at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229) at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65) at java.lang.reflect.Constructor.newInstance(libgcj.so.7) at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(commons-logging-api.jar.so) at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(commons-logging-api.jar.so) at org.apache.commons.logging.LogFactory.getLog(commons-logging-api.jar.so) at org.apache.catalina.core.ContainerBase.getLogger(catalina.jar.socs9zxl.so) at org.apache.catalina.valves.ValveBase.createObjectName(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardPipeline.registerValve(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardPipeline.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardContext.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChildInternal(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectory(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectories(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployApps(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.lifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardEngine.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardService.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardServer.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.Catalina.start(catalina.jar.socs9zxl.so) at java.lang.reflect.Method.invoke(libgcj.so.7) at org.apache.catalina.startup.Bootstrap.start(bootstrap.jar.so) at org.apache.catalina.startup.Bootstrap.main(bootstrap.jar.so) 2-Sep-06 1:36:11 PM org.apache.catalina.core.NamingContextListener addResource WARNING: Failed to register in JMX: javax.naming.NamingException: Cannot create resource instance 2-Sep-06 1:36:11 PM org.apache.catalina.core.NamingContextListener addResource WARNING: Failed to register in JMX: javax.naming.NamingException: Cannot create resource instance 2-Sep-06 1:36:11 PM org.apache.catalina.core.NamingContextListener addResource WARNING: Failed to register in JMX: javax.naming.NamingException: Cannot create resource instance 13:38:27,450 ERROR ContextLoader,main:200 - Context initialization failed org.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'reportJobUpdateVoter' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Class that bean class [org.acegisecurity.vote.BasicAclEntryVoter] depends on not found; nested exception is java.lang.NoClassDefFoundError: org.acegisecurity.vote.AbstractAclVoter java.lang.NoClassDefFoundError: org.acegisecurity.vote.AbstractAclVoter at java.lang.Class.initializeClass(libgcj.so.7) at java.lang.Class.initializeClass(libgcj.so.7) at java.lang.Class.forName(libgcj.so.7) at org.springframework.util.ClassUtils.forName(ClassUtils.java:108) at org.springframework.beans.factory.support.BeanDefinitionReaderUtils.createBeanDefinition(BeanDefinitionReaderUtils.java:65) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:565) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:531) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseDefaultElement(DefaultXmlBeanDefinitionParser.java:397) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitions(DefaultXmlBeanDefinitionParser.java:371) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.registerBeanDefinitions(DefaultXmlBeanDefinitionParser.java:206) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:388) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:259) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:209) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:184) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:128) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:144) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:126) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:95) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:90) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:280) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:241) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardContext.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChildInternal(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectory(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectories(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployApps(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.lifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardEngine.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardService.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardServer.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.Catalina.start(catalina.jar.socs9zxl.so) at java.lang.reflect.Method.invoke(libgcj.so.7) at org.apache.catalina.startup.Bootstrap.start(bootstrap.jar.so) at org.apache.catalina.startup.Bootstrap.main(bootstrap.jar.so) Caused by: java.lang.ClassNotFoundException: org.aspectj.lang.JoinPoint$StaticPart at org.apache.catalina.loader.WebappClassLoader.loadClass(catalina.jar.socs9zxl.so) at org.apache.catalina.loader.WebappClassLoader.loadClass(catalina.jar.socs9zxl.so) at java.lang.Class.forName(libgcj.so.7) at java.lang.Class.initializeClass(libgcj.so.7) ...44 more 13:38:27,983 ERROR [/jasperserver],main:? - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'reportJobUpdateVoter' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Class that bean class [org.acegisecurity.vote.BasicAclEntryVoter] depends on not found; nested exception is java.lang.NoClassDefFoundError: org.acegisecurity.vote.AbstractAclVoter java.lang.NoClassDefFoundError: org.acegisecurity.vote.AbstractAclVoter at java.lang.Class.initializeClass(libgcj.so.7) at java.lang.Class.initializeClass(libgcj.so.7) at java.lang.Class.forName(libgcj.so.7) at org.springframework.util.ClassUtils.forName(ClassUtils.java:108) at org.springframework.beans.factory.support.BeanDefinitionReaderUtils.createBeanDefinition(BeanDefinitionReaderUtils.java:65) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:565) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:531) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseDefaultElement(DefaultXmlBeanDefinitionParser.java:397) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitions(DefaultXmlBeanDefinitionParser.java:371) at org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.registerBeanDefinitions(DefaultXmlBeanDefinitionParser.java:206) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:388) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:259) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:209) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:184) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:128) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:144) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:126) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:95) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:90) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:280) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:241) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardContext.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChildInternal(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectory(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectories(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployApps(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.lifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardEngine.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardService.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardServer.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.Catalina.start(catalina.jar.socs9zxl.so) at java.lang.reflect.Method.invoke(libgcj.so.7) at org.apache.catalina.startup.Bootstrap.start(bootstrap.jar.so) at org.apache.catalina.startup.Bootstrap.main(bootstrap.jar.so) Caused by: java.lang.ClassNotFoundException: org.aspectj.lang.JoinPoint$StaticPart at org.apache.catalina.loader.WebappClassLoader.loadClass(catalina.jar.socs9zxl.so) at org.apache.catalina.loader.WebappClassLoader.loadClass(catalina.jar.socs9zxl.so) at java.lang.Class.forName(libgcj.so.7) at java.lang.Class.initializeClass(libgcj.so.7) ...44 more log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: jasperserver.log (Permission denied) at gnu.java.nio.channels.FileChannelImpl.open(libgcj.so.7) at gnu.java.nio.channels.FileChannelImpl.<init>(libgcj.so.7) at java.io.FileOutputStream.<init>(libgcj.so.7) at java.io.FileOutputStream.<init>(libgcj.so.7) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:166) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:162) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:254) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:107) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:95) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:655) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:508) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:416) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:429) at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:335) at org.springframework.util.Log4jConfigurer.initLogging(Log4jConfigurer.java:72) at org.springframework.web.util.Log4jWebConfigurer.initLogging(Log4jWebConfigurer.java:156) at org.springframework.web.util.Log4jConfigListener.contextInitialized(Log4jConfigListener.java:52) at org.apache.catalina.core.StandardContext.listenerStart(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardContext.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChildInternal(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.addChild(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectory(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployDirectories(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.deployApps(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.HostConfig.lifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardHost.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.ContainerBase.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardEngine.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardService.start(catalina.jar.socs9zxl.so) at org.apache.catalina.core.StandardServer.start(catalina.jar.socs9zxl.so) at org.apache.catalina.startup.Catalina.start(catalina.jar.socs9zxl.so) at java.lang.reflect.Method.invoke(libgcj.so.7) at org.apache.catalina.startup.Bootstrap.start(bootstrap.jar.so) at org.apache.catalina.startup.Bootstrap.main(bootstrap.jar.so) 2-Sep-06 1:38:31 PM org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart 2-Sep-06 1:38:31 PM org.apache.catalina.core.StandardContext start SEVERE: Context [/jasperserver] startup failed due to previous errors 2-Sep-06 1:39:28 PM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8080 2-Sep-06 1:39:28 PM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 2-Sep-06 1:39:28 PM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/307 config=null 2-Sep-06 1:39:29 PM org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource 2-Sep-06 1:39:29 PM org.apache.catalina.startup.Catalina start INFO: Server startup in 244038 ms By: Sherman Wood - sgwood RE: Problems starting JasperServer 2006-09-02 06:37 First thing: please post on JasperForge at http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=showcat&catid=10 You have 2 problems. I don't know why writing to your log file is not working. It usually is in TOMCAT/bin, though it can be moved by editing WEB-INF/classes/log4j.properties. The missing class problem is strange. The classes being complained about are in WEB-INF/lib/acegi-security-1.0.1.jar. You can't have one without the other. Have you got other acegi-security jars on the classpath in Tomcat? Sherman JasperSoft By: BlueIced - blueiced RE: Problems starting JasperServer 2006-09-03 08:36 Sorry for posting, I came across this one first. In log4j.properties there is the following line: #log4j.appender.fileout.File=${webapp.root}/WEB-INF/log4j.log. Is this the line you are talking about? Because it is commented out. Should I enable it? I can only find acegi-security-1.0.0.jar on my server. So I am not sure if this is right. Arjan.

crosstab problem details

ktrinad posted a topic in Products

By: shohan_db - shohan_db crosstab problem details 2006-08-09 01:36 When i create crosstab report... The following types of error occurring: Error filling print... net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:638) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634) ... 12 more Print not filled. Try to use an EmptyDataSource...! After this i write "crosstab-1" in summary band Then 3 error occurring: Errors compiling D:inteaccreportscrosstab1.jasper! it.businesslogic.ireport.ReportClassLoader@f3ff7d net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. crosstab cannot be resolved value = (java.lang.Boolean)(crosstab-1); <------> 2. crosstab cannot be resolved value = (java.lang.Boolean)(crosstab-1); <------> 3. crosstab cannot be resolved value = (java.lang.Boolean)(crosstab-1); <------> 3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:131) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:473) at java.lang.Thread.run(Unknown Source) Please help with proper instruction Thanks mainur

Unable access WS on jasperintelligenge 1.0.1

ktrinad posted a topic in Products

By: Luca Gioppo - luca_gioppo Unable access WS on jasperintelligenge 1.0.1 2006-07-21 02:49 Installed jasperIntelligence on JBoss 4.0.4 with MySQL. The Web UI runs correctly, but when I try to use the web service (I wanted to try the php integration) it doesnt respond anything. Chenged security to allow anon use and to give anon USER_ROLE. I'm UNable to get the WSDL. Tryed with: http://localhost:8080/jasperserver/services/repository?wsdl But got: - <error> <description>Unable to generate WSDL for this service</description> <reason>Either user has not dropped the wsdl into META-INF or operations use message receivers other than RPC.</reason> </error> Where is the URL for WSDL? Does the WS function or it's still in the work? Thanks Luca By: Virulence - virulence RE: Unable access WS on jasperintelligenge 1. 2006-07-23 18:26 I encounter same problem too in http://localhost:8080/jasperserver/services/repository?wsdl i got an error <error> <description>Unable to generate WSDL for this service</description> <reason>Either user has not dropped the wsdl into META-INF or operations use message receivers other than RPC.</reason> </error> and in http://localhost:8080/jasperserver/view-services/JasperServerService?wsdl it's fine. tried making a simple php client accessing the latter, and got error SOAP_Fault Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 Code: => WSDLPARSER [message] => Unable to parse WSDL file http://localhost:8080/jasperserver/view-services/JasperServerService?wsdl XML error on line 15: Mismatched tag is this the WS fault, or issit possible an error somewhere in the installation? By: medspx - medux RE: Unable access WS on jasperintelligenge 1. 2006-08-07 02:27 Hello, I've got the same error. The problem comes from the fact that you shoudl authenticate yourself in order to reach the WSDL file returned by the server. When trying to get the WSDL file, I've got the following error: <html><head><title>Apache Tomcat/5.5.17 - Rapport d'erreur</title><style></style> </head><body><h1>Etat HTTP 500 - </h1><HR size="1" noshade="noshade">type Rapport d'exceptionmessage description Le serveur a rencontrÃ© une erreur interne () qui l'a empÃªchÃ© de satisfaire la requÃªte.exception <pre>org.acegisecurity.AuthenticationCredentialsNotFoundException: An Authentication object was not found in the SecurityContext org.acegisecurity.intercept.AbstractSecurityInterceptor.credentialsNotFound(AbstractSecurityInterceptor.java:329) org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:244) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:104) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) And the NuSoap wsdl parser is not able to understand it. I'am trying to find a way to get the wsdl file from PHP after authentication. By: Drooler - bhaugland RE: Unable access WS on jasperintelligenge 1. 2006-08-07 05:47 I had the same problem under JBoss. You will need to alter the login-config.xml which is located in the conf area of your server. At the bottom is an application-policy section named other. Change its contents to look like this <authentication > <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required> <module-option name="dsJndiName">java:/jdbc/jasperserver</module-option> <module-option name="principalsQuery">select password from JIUser where username = ?</module-option> <module-option name="rolesQuery">select rolename, 'Roles' from JIUser, JIRole, JIUserRole where JIUser.username = ? and JIUserRole.userId = JIUser.id and JIUserRole.roleId = JIRole.id</module-option> </login-module> </authentication> Note: I am using Oracle so if you are using my sql the table names are different. This will allow you to access the WSDL for view-services/JasperServerServices?wsdl. The services/repository?wsdl does not seem to be working. By: medspx - medux RE: Unable access WS on jasperintelligenge 1. 2006-08-07 05:59 Hello, I found another method by altering the configuration of the Acegi (WEB-INF/applicationContext-security.xml): I've changed the bean filterChainProxy: replace "basicProcessingFilter,JIAuthenticationSynchronizer" by "anonymousProcessingFilter" for the /view-services/** line. Then , in the same file I add anonymous access to the filterInvocationInterceptor bean: /view-services/**=ROLE_USER,ROLE_ANONYMOUS Then restart tomcat and WSDL file can be accessed anymously. NuSoap is then able to parse the wsdl file...

blank PDF

ktrinad posted a topic in Products

By: thomas - thomasincairo blank PDF 2006-08-07 02:42 Hi, I am testing JasperIntelligence and I have a problem with a PDF export from the web interface. When I click on the button PDF, I have a blank page in acrobat reader. (I'm using firefox 1.5.0.6). I made my report with iReport 1.2.4 + plugin The PDF view for the sample reports works fine. Have an idea ? Thanks By: thomas - thomasincairo RE: blank PDF 2006-08-07 05:24 I check some styles parameters and I see that this problem occurs when I use "Identity-H (Unicode with horizontal writing)" for the PDF encoding. Problem is now how to write PDF files with arabic data (using unicode beacause my report mix latin and arabe alphabet) thanks a lot

SoapAPI class

ktrinad posted a topic in Products

By: Daniel Miller - heres4 SoapAPI class 2006-07-07 12:47 I can't find the com.jaspersoft.jasperserver.ws.SoapAPI file in the source repository. Has it been checked in? If so, where is it? I'd like to have a way to fetch a report in PDF format using SOAP. Is there a way to do that yet? Also, are there any plans to make a REST API where report parameters can be passed in the URL? That would be much easier to use than SOAP (IMHO). By: Sherman Wood - sgwood RE: SoapAPI class 2006-07-09 12:41 We are moving from having both Axis 1.3 and Axis2, to focusing on Axis2, so the SoapAPI is no longer there. The iReport plugin uses this. The thing missing in the Axis2 API is running reports that produce HTML, PDF etc. I am working on that now. There was a hack in 0.9.2 that allowed reports to be run without parameters. That has been removed for now. We are working on enhancing REST/URL interactivity so that people can call reports with parameters in the URL which will allow drillable reports and charts. Sherman JasperSoft By: Daniel Miller - heres4 RE: SoapAPI class 2006-07-10 13:56 It's great to hear that you're working on a REST API. I'm not asking for a hard date, but do you have any idea of the time frame that this will be available? I'm planning on using JasperServer in a project and generating parameterized PDF reports is a requirement. Thanks for all your hard work so far. I really like the iReport integration. ~ Daniel By: Sherman Wood - sgwood RE: SoapAPI class 2006-07-12 06:09 We are still working out the release plan for the next couple of months, and this will be in there. We may get some interim releases out, but expect the REST API in about 2 months. Sherman JasperSoft By: Daniel Miller - heres4 RE: SoapAPI class 2006-08-01 12:13 Thanks Sherman. I'll be looking forward to that. ~ Daniel

schedule in jasperserver

ktrinad posted a topic in Products

By: mardaraj - mardaraj schedule in jasperserver 2006-07-29 05:12 Hi, i am using jasperserver. and i want schedule some reports in my application.so for this what i ahve to do can any one help. i know in jasperintiligence schedule is there. but i dont want it to change. is there any plugin or any patch file there for this ? plz help me abt this. with regards Mardaraj By: T Kavanagh - tkavanagh RE: schedule in jasperserver 2006-08-01 11:34 If you take a look at the JasperIntelligence-User-Guide.pdf (found online or in the installation docs directory) you will find a description of how to use the scheduler. So, you should not have to change anything to do this. Also, please note that the forums have moved to http://www.jasperforge.org. You will need to create a regular account and then a developer account to be able to post to the forums in there. Cheers, -Tony

Is XMLA feature in IR-JI plugin functional??

ktrinad posted a topic in Products

By: sure919 - sure919 Is XMLA feature in IR-JI plugin functional?? 2006-07-27 03:13 Hi, I have installed IReport 1.2.4 with JI plugin, I get "MEP, Not yet implemented" message once i check all options. Can anyone help By: T Kavanagh - tkavanagh RE: Is XMLA feature in IR-JI plugin functiona 2006-07-28 16:35 Hi, you are definitely getting a configuration error. I assume you are using the older 0.9.2 product? One thing I would suggest is updating to the most current jasperserver / jasperintelligence 1.0.1. If you run either the linux or windows installer, it will install a pre-configured iReport (with JI plugin) on your machine. So, all you would have to do is startup jasperintelligence and iReport and then follow the steps in the jasperintelligence-user-guide.pdf (from the docs directory or download from online site) to create a connection from iReport to jasperintelligence. This is really just a matter of pointing to the web service location http://localhost:8080/jasperserver/services/repository and give a username/password (tomcat/tomcat or jasperadmin/<your-installed-password> The user guide also mentions this potential error, and mentions that you need to have a valid username/password as well as having the correct URL (mentioned above). Also, iReport currently will not allow you to create an xmla connection. This would be done in the jasperintelligence application itself.

Connect to pre-existing Oracle DB - newb

ktrinad posted a topic in Products

By: sivlE35 - sivle35 Connect to pre-existing Oracle DB - newb 2006-07-28 07:20 OK...I've got JasperIntelligence installed (on WinXP Pro) and works great with the default MySQL DB. I'm trying to figure out how to connect to my pre-existing Oracle 9i DB. I've already created an I-report that I would like to allow users to run themselves. I'm not sure what to download if anything and where/how to configure this. Detailed steps would be greatly appreciated. Thanks. By: sivlE35 - sivle35 RE: Connect to pre-existing Oracle DB - newb 2006-07-28 13:27 looks like it has something to do with my Oracle URL..i didn't realize there was more to the error message. Essentially this is the error: Caused by: java.sql.SQLException: Invalid Oracle URL specified Here's the url i'm using...i can't figure out where i'm going wrong. jdbc:oracle:thin:@is-can-d3.ads.is.edu:1521:CA03 Any ideas?

Reports with XMLA Connection raising errors

ktrinad posted a topic in Products

By: sure919 - sure919 Reports with XMLA Connection raising errors 2006-07-03 02:23 Hi, I was trying to create Reports with OLAP View with XMLA Connection Type, I shall update u with what i have done: Connection Type: XMLA and then selected "Locally Defined XML/A OLAP Client Connection" for XML/A Connection specified (using mondrian food mart) catalog="FoodMart" (defined earlier OLAP Schema) Datasource="Provider=Mondrian;DataSource=MondrianFoodmart;" URI="http://localhost:8080/mondrian/xmla" (where mondrian is configure and is running on my machine) lastly username=tomcat and password= tomcat. later specified this mdx query ------------------ SELECT NON empty {{[store].[store Country].Members} * {[Time].[Quarter].Members} * {[Customers].[Country].Members}} ON COLUMNS, {{ [Product].[Product Family].Members } *{[Education Level].[Education Level].Members} } ON ROWS FROM [sales] WHERE ( [Promotions].[All Promotions] ) ------------- and when trying to save the settings.. i am getting this error(pasting below) Error Message: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@16a6512 targetAction = com.jaspersoft.jasperserver.war.action.OlapUnitAction@11b4c2, attributes = map[[empty]]] in state 'saveOlapUnit' of flow 'olapUnitFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Null URI Error Trace: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@16a6512 targetAction = com.jaspersoft.jasperserver.war.action.OlapUnitAction@11b4c2, attributes = map[[empty]]] in state 'saveOlapUnit' of flow 'olapUnitFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Null URI org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@16a6512 targetAction = com.jaspersoft.jasperserver.war.action.OlapUnitAction@11b4c2, attributes = map[[empty]]] in state 'saveOlapUnit' of flow 'olapUnitFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Null URI com.jaspersoft.jasperserver.api.JSException: Null URI at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:355) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getReference(HibernateRepositoryServiceImpl.java:466) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.getReference(RepoResource.java:141) at com.jaspersoft.jasperserver.api.metadata.olap.domain.impl.hibernate.RepoOlapUnit.copyOlapClientConnection(RepoOlapUnit.java:96) at com.jaspersoft.jasperserver.api.metadata.olap.domain.impl.hibernate.RepoOlapUnit.copyFrom(RepoOlapUnit.java:89) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.copyFromClient(RepoResource.java:95) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$3.execute(HibernateRepositoryServiceImpl.java:206) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:74) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:65) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl ----------------- can any one help me on this... Thanks in advance By: sure919 - sure919 RE: Reports with XMLA Connection raising errors 2006-07-03 02:35 hi again!! i have tried this by creating the "Mondrian XML/A Source".. Created the xmla olap client connection (for foodmart) and execute the same Query.. it gave a different error.... (pasted below for reference) ----------------------------- Error Message: com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales Error Trace: com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:152) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:94) 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.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:418) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:374) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) 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:136) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) 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 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:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) 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) Caused by: com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales at com.tonbeller.jpivot.xmla.XMLA_SOAP.discoverDim(XMLA_SOAP.java:342) at com.tonbeller.jpivot.xmla.XMLA_Model.initCubeMetaData(XMLA_Model.java:728) at com.tonbeller.jpivot.xmla.XMLA_Model.initialize(XMLA_Model.java:173) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:129) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:76) at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:37) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:180) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:150) ... 57 more com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales at com.tonbeller.jpivot.xmla.XMLA_SOAP.discoverDim(XMLA_SOAP.java:342) at com.tonbeller.jpivot.xmla.XMLA_Model.initCubeMetaData(XMLA_Model.java:728) at com.tonbeller.jpivot.xmla.XMLA_Model.initialize(XMLA_Model.java:173) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:129) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:76) at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:37) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:180) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:150) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:94) 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.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:418) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:374) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.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(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 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.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) 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:136) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) 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 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:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) 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) -------------- Has ne on created OLAP Reports using XML/A (i am able to create OLAP REports uisng Mondrian, but not XML/A.... Plse helpe if u have got my problem!! Thanks sure By: Sherman Wood - sgwood RE: Reports with XMLA Connection raising erro 2006-07-03 07:48 I don't know your exact problem, but here is the general approach. You need to set up an XML/A Connection to define where the UI is going to connect, and a Mondrian XML/A Source to define what the XML/A Connection is going to connect to. The example data has a Mondrian XML/A Source defined for the Foodmart in the repository at /olap/xmla/definitions/FoodmartXmlaDefinition, and an XML/A connection to that Source at /olap/connections/FoodmartXmlaConnection. I successfully set up an OLAP view with your query by using the FoodmartXmlaConnection. Sherman JasperSoft By: sure919 - sure919 RE: Reports with XMLA Connection raising errors 2006-07-03 23:14 GoodDay Sherman!! let me tell you what i have done / explain my problem: (i have installed using war.. so i am unable to see the samples with OLAP view that uve mentioned..) 1. Defined JDBC Datasource for Postgres. 2. Created OLAP Schema --> giving reference to FoodMart.xml file (Catalog information) 3. OLAP Client Connection--> (Mondrian Connection Definition)--> selecting the OLAP Schema defined in step 2 and JDBC Datasource defined in step 1. 4. OLAP View --> Using Mondrian Connection (step3) --> Report was created successful.. 5. Mondrian XML/ A Source --> Catalog : FoodMart and refering mondrian connection Step 3. 6. Olap Client Conection--> Catalog (drop down contains FoodMart) and uri=http://localhost:8080/mondrian/xmla and DataSource=Provider=Mondrian;DataSource=MondrianFoodmart; username=tomcat, password=tomcat. 7. Creating olap view using step 6 settings. and the same mdx query "SELECT NON empty {{[store].[store Country].Members} * {[Time].[Quarter].Members} * {[Customers].Country].Members}} ON COLUMNS, {{ [Product].[Product Family].Members } *{[Education Level].[Education Level].Members} } ON ROWS FROM [sales] WHERE ( [Promotions].[All Promotions] )" (there are no issues with the query as it runs when used with Mondrian OLAP connection. Has problem while executing the same with XMLA OLap connection. sends the error message... from JPivot --> ....... com.tonbeller.jpivot.olap.model.OlapException: No metadata schema dimensions for catalog: FoodMart and cube: Sales ....... Do let me know if my steps are incorrect or is there anything more that i need to do. I wish to execute OLAP Reports using XMLA OLAP Client connection. Thankyou very much. Regards, sure By: Sherman Wood - sgwood RE: Reports with XMLA Connection raising erro 2006-07-09 18:08 Check out the User Guide at http://jasperintel.sourceforge.net/docs/1-0-0/JasperServer-User-Guide-1.0.0.pdf (I just noticed that the docs in the Windows installer are old - I will update them). To set up an end-to-end XML/A connection, you need to set up a Mondrian XML/A Source, which defines the server side configuration, and an XML/A Client Connection that points to the URL of the Mondrian XML/A Source. Sherman JasperSoft By: sure919 - sure919 RE: Reports with XMLA Connection raising errors 2006-07-27 03:09 Hi Sherman!! Thanks!! the samples work and for the documentation. I am trying to run xmla views from my own cube defined. defined OLAP Schema (giving reference to my cube, xml file) DEfined XMLA Datasource, XMLA client connection and then providing MDX Query at the end (Query has no issues) but i get the soap error (pasted below). Any help would be of great value. Thanks ----------------- com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBB04 fault string=XMLA SOAP bad Discover RequestType element fault actor=Mondrian Error Trace: com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBB04 fault string=XMLA SOAP bad Discover RequestType element fault actor=Mondrian com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBB04 fault string=XMLA SOAP bad Discover RequestType element fault actor=Mondrian at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:152) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:94) 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.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod By: Sam Birney - sbirney RE: Reports with XMLA Connection raising erro 2006-07-28 12:27 Hello, when something goes wrong with XMLA on the server end, it generates a SOAP Fault response, and then the XMLA client prints it's error stacktrace when it receives that fault response. So, the error message that will be more helpful is in the jasperserver log on the XMLA server instance - can you try to find that and post so we can help diagnose it? thanks, Sam

Adding a Resource

ktrinad posted a topic in Products

By: Drooler - bhaugland Adding a Resource 2006-07-14 04:45 I discovered that if I have an Input Control defined for a report unit I cannot add a resource. In order to add a resource I must first delete my Input controls, add the resource and then add the controls back in. This occurs with both iReports, and JasperIntelligence Server. By: T Kavanagh - tkavanagh RE: Adding a Resource 2006-07-26 13:43 Hmm, that is strange. I will add this to the tracker bug list. By: T Kavanagh - tkavanagh RE: Adding a Resource 2006-07-26 13:44 Hmm, that is strange. I will add this to the tracker bug list on jasperforge.org

Problem Building Source

ktrinad posted a topic in Products

By: flavio - flavio_toledo Problem Building Source 2006-07-17 09:45 I need build source of jasperserver, i mounted all structure of folders and execute all scripts on MySQL, but when i execute in command line the command: mvn install show the error: C:JASPER>mvn install [iNFO] Scanning for projects... [iNFO] ------------------------------------------------------------------------ [ERROR] FATAL ERROR [iNFO] ------------------------------------------------------------------------ [iNFO] Error building POM (may not be this project's POM). Project ID: com.jaspersoft.jasperserver.api.metadata.impl:jasperserver-reposito y-hibernate POM Location: C:JASPERjasperserver-repository-hibernatepom.xml Validation Messages: [0] 'dependencies.dependency.artifactId' with value '${repository.database driver.artifactId}' does not match a valid id pattern. [1] 'dependencies.dependency.groupId' with value '${repository.database.dr ver.groupId}' does not match a valid id pattern. Reason: Failed to validate POM [iNFO] ------------------------------------------------------------------------ [iNFO] Trace org.apache.maven.reactor.MavenExecutionException: Failed to validate POM at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:365) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:278) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:115) at org.apache.maven.cli.MavenCli.main(MavenCli.java:256) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430 at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.project.InvalidProjectModelException: Failed to val date POM at org.apache.maven.project.DefaultMavenProjectBuilder.processProjectLo ic(DefaultMavenProjectBuilder.java:926) at org.apache.maven.project.DefaultMavenProjectBuilder.buildInternal(De aultMavenProjectBuilder.java:737) at org.apache.maven.project.DefaultMavenProjectBuilder.buildFromSourceF leInternal(DefaultMavenProjectBuilder.java:416) at org.apache.maven.project.DefaultMavenProjectBuilder.build(DefaultMav nProjectBuilder.java:192) at org.apache.maven.DefaultMaven.getProject(DefaultMaven.java:515) at org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:447) at org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:491) at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:351) ... 11 more [iNFO] ------------------------------------------------------------------------ [iNFO] Total time: 2 seconds [iNFO] Finished at: Mon Jul 17 13:36:23 GMT-03:00 2006 [iNFO] Final Memory: 1M/3M [iNFO] ------------------------------------------------------------------------ What's wrong???? Thank you FlÃ¡vio By: Sherman Wood - sgwood RE: Problem Building Source 2006-07-17 21:14 See http://jasperintel.sourceforge.net/docs/1-0-0/JasperServer-Source-Code-Build.htm You need to set your ~/.m2/settings.xml Sherman JasperSoft By: T Kavanagh - tkavanagh RE: Problem Building Source 2006-07-26 13:42 The contents of this source build doc has been updated and moved to a new doc: jasperintelligence-source-build-and-developer-guide.pdf

Connetion to jasper from External reporting

ktrinad posted a topic in Products

By: mardaraj - mardaraj Connetion to jasper from External reporting 2006-07-18 06:27 Hi all, I am working on a Reporting Project. We are using Jasper Server 0.9.2. I am trying to write a java program which should have the following functionality. * This should be a stand alone java program. * There must be a method to login to the jasper by giving username/password. * There must be a method to fetch all the users/roles created in jasper server. Basically i need to login and get details from jasper server from a different application. I could not find any help or sample code in any of the forums since last 2-3 days. Can you help me ? It will be really helpful if you can provide any links or sample code. thanks and regards, Mardaraj By: T Kavanagh - tkavanagh RE: Connetion to jasper from External reporti 2006-07-26 13:38 Mardaraj, Unfortunately, there is not any straight-forward source code example for this. However, there is the jasperserver-ireport plugin code and this code does the same thing as what you would like to do. Take a look as the WSClient.java module. You would be able to collect information from jasperserver via the web services interface.

iReport-plug-in -not able to login

ktrinad posted a topic in Products

By: mardaraj - mardaraj iReport-plug-in -not able to login 2006-07-18 07:16 Hi all , Please any body help regarding i reprot plug-in to jasper server as i am unable to do plug-in. Set up done 1)Deployed Jasperserver 0.9.2 in tomcat 5.5 2)Deployed Axis2 3)Deployed Japserserver-ws 4)Installed iReport 1.1.2 and done all configuration set up . I am not getting any error but on login from iReport to jasper no action happens and in tomcat console a warning is displayed as follows, Repository: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl@1eb139e 19:11:38,391 WARN ResourceBundleMessageSource,http-8080-Processor25:184 - ResourceBundle [jasperserver_messages] not found for MessageSource: Can't find bundle for base name jasperserver_messages, locale en_US I will be very much helpfull if any can provide any document or direction. Thanks and regards, Mardaraj By: T Kavanagh - tkavanagh RE: iReport-plug-in -not able to login 2006-07-26 13:33 I think the warning is not playing a role in the problem. Usually if I have trouble logging into jasper from iReport I find an error in the iReport logs (which go to a console - behind the swing app on your desktop). I am surprised that iReport is not giving an error message. Also, one thing that might be helpful is that jasperintelligence 1.0 has been released (next version of jasperserver/jasperintelligence). There is an installer for both linux and windows. In this installer, there is an automatic installation and configuration of iReport along with jasperserver/jasperintelligence. Also, there is a jasperintelligence-user-guide.pdf (and .odt) which shows how to log and do operations in iReport when connected to jasperserver.

jasperserver API for logging an user

ktrinad posted a topic in Products

By: mardaraj - mardaraj jasperserver API for logging an user 2006-07-05 05:06 i have a application.and in this application i am fetching reports of an user of jasperserver. so, i want to know whats the API are jasperserver using for a user to login. also give me the idea whats the API using to fetch report of an user. thanks Mardaraj By: Sherman Wood - sgwood RE: jasperserver API for logging an user 2006-07-05 06:25 We use the Acegi Security framework for authentication and authorization. Acegi can be configured to authenticate against a variety of authentication sources, such as LDAP. We also have a default authentication source that uses an internal database. You can configure the object level security in JI to allow users access only to the reports and other resources that are relevant for their roles, or down to the individual user level. You can set the security for folders or individual reports, say. The various browser UIs in the system call the repository API: repositoryService.loadResourcesList repositoryService.getAllFolders repositoryService.getSubFolders The lists of results are filtered to show only what objects the user has access to. The report browser wporks this way. Sherman JasperSoft By: mardaraj - mardaraj RE: jasperserver API for logging an user 2006-07-05 23:22 thank u Sherman, your answer is some thing high level. i am not getting about that. in code level to login for an user is ---- UsernamePasswordAuthenticationToken authRequest = new UsernamePasswordAuthenticationToken(username, password); setDetails(request, authRequest); request.getSession().setAttribute("ACEGI_SECURITY_LAST_USERNAME", username); return getAuthenticationManager().authenticate(authRequest); now tell me for fetching report of an user in code level and in which jar i will get this. i want some idea.its urgent plz help me. with regards Mardaraj By: Sherman Wood - sgwood RE: jasperserver API for logging an user 2006-07-06 06:00 In the new release, there is an example in RepositoryAction (war-jar). List pathFolders = getPathFolders(folderURI); List folders = repository.getSubFolders(null, folderURI); FilterCriteria reportUnitCriteria = FilterCriteria.createFilter(ReportUnit.class); reportUnitCriteria.addFilterElement(FilterCriteria.createParentFolderFilter(folderURI)); List reportUnits = repository.loadResourcesList(reportUnitCriteria); The list of reports that are available for the logged in user will be in the reportUnits variable. Sherman JasperSoft By: spoorthi - spoo_anu RE: Isolating Jasper Server from MySQL 2006-07-22 00:32 Dear All, This is shivaraj here ,my problem is.. At the time of jasper server installation i want to isolate mysql database from Jasper server. is there any new jasper server installable is available ? If u have any solution will u plz let me know at spoo_anu@rediffmail.com with thank and regards SHIVARAJ By: T Kavanagh - tkavanagh RE: jasperserver API for logging an user 2006-07-26 13:24 Shivaraj, There is not a way to have no interaction with the mysql database if you use the installer. The installer will attempt to connect to a database in order to create and populate the jasperserver database. However, this is the only database affected. Alternatively, you can use the jasperintelligence-1.0.1-bin.zip which is a "stand-alone" war archive. You can use this in tomcat or jboss and then all of the database setup is done "by hand" using the instructions found in the doc jasperintelligence-WarFile-install-guide.pdf. -Tony

How to Run Samples on Intelligence?

ktrinad posted a topic in Products

By: chenq - chenq How to Run Samples on Intelligence? 2006-07-19 20:40 I have Intelligence installed and I choose to install the sample database,but there is not any sample after I login. I try to add a report unit from the sample directory, and failed running it. what's the matter? Error Message: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@13887c2 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@58ff51, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. test.TestScriptlet cannot be resolved to a type value = (java.lang.String)(((test.TestScriptlet)parameter_REPORT_SCRIPTLET.getValue()).message()); <----------------> 2. test.TestScriptlet cannot be resolved to a type value = (java.lang.String)(((test.TestScriptlet)parameter_REPORT_SCRIPTLET.getValue()).message()); <----------------> 3. test.TestScriptlet cannot be resolved to a type value = (java.lang.String)(((test.TestScriptlet)parameter_REPORT_SCRIPTLET.getValue()).message()); <----------------> 3 errors Thanks a lot By: chenq - chenq RE: How to Run Samples on Intelligence? 2006-07-19 23:04 BTW: when I'm in Locate Data Source page of Report Wizard, there is nothing available in Repository list, and so does all repository options in other such pages. Need I set anything after setup? By: T Kavanagh - tkavanagh RE: How to Run Samples on Intelligence? 2006-07-26 13:18 If there is not any sample data, then it seems as though something has gone wrong during the installation. Try this: go to the documents section and get the JasperIntelligence-WarFile-Install-Guide.pdf (it's also available as an open office doc in your local docs directory inside your installation directory). Anyway, get the one online to make sure it's the latest. It has a section on how to create the sample data. You will create the sugarcrm, etc database by hand, load data into it. Then also run the ji-import.bat/sh in order to get the sample metadata into the jasperintel repository. Once all the sample data is there then you should be able to view reports. Then you can follow the User Guide in order create a report. -Tony

problem installing jasper server

ktrinad posted a topic in Products

By: maclennan - mmaclennan problem installing jasper server 2006-07-24 17:04 I have been trying to install jasper server on a linux maching. I have installed mysql, apache tomcat. I followed the detailed instructions for installing jasper server by droping the war file in tomcat and setting up the databases with a fresh install of mysql but can't get it to run. When I type localhost:8080/jasperserver I get the error 'The requested resource (/jasperserver/) is not available. When I try to start the service in the tomcat management consol it say that it fails to start. I have also checked the logs and the only error that is appaent to me is a warning stating this; "Warning: A docBase /usr/local/apache-tomcat-5.5.17/webapps/jasperserver inside the host appBase has been specified, and will be ignored SEVERE: Error listenerStart PM org.apache.catallina.core.StandartContext start SEVERE: Context [/jasperserver] startup failed due to previous errors" I am not sure what I am doing wrong. Has anyone ever encountered this problem before if so how did you solve it? By: T Kavanagh - tkavanagh RE: problem installing jasper server 2006-07-26 13:12 It sounds like have done your install from the jasperintelligence-1.0.1-bin.zip (ie the "stand-alone war archive") and not the linux installer. There is an install guide for the war file, which it sounds like you are using to configure your installation. I find the most common problem is the database connection. Also, with a war file (due to the auto-deploy in tomcat) you can end up with two database configuration files. One is WEB-CONF/context.xml and the other gets created by tomcat in conf/Catalina/localhost/jasperserver.xml (or something similar). To be safe both of these should be checked to see that the database, dbuser, dbuserpasswd, etc are correct. Try using the same info in the db xml files to actually login using mysql's client tool (ie. similar to: mysql -u root -p -h localhost -D jasperserver) Also check all your other config files such as js.mail.properties. Also, hopefully you can find more log information... did you check tomcat/logs/catalina.out? The JasperIntelligence-WarFile-Install-Guide.pdf has been updated in both JasperForge.org and sourceforge take a look at some of the db and troubleshooting info. Lastly, the forums will be migrating to jasperforge.org.

Problem with download code from subversion

ktrinad posted a topic in Products

By: flavio - flavio_toledo Problem with download code from subversion 2006-07-17 18:21 I dont obtain the code from subersion. The program TortoiseSVN show this message: Error: PROPFIND request failed on '/svnroot/jasperintel%20jasperintel' Error: Could not open the requested SVN filesystem What's wrong? Tahnk you. By: T Kavanagh - tkavanagh RE: Problem with download code from subversio 2006-07-24 11:16 Flavio, the path on the error message looks correct. Do you have the svn command line tool available? You can get a command line binary here: http://subversion.tigris.org/ Then try this command line (from the jasperintel sourceforge subversion page): svn co https://svn.sourceforge.net/svnroot/jasperintel jasperintel By: T Kavanagh - tkavanagh RE: Problem with download code from subversio 2006-07-24 11:21 Also, I forgot to mention that the forums are moving over to our new http://www.jasperforge.org site.

Problem when using LDAP authentication

ktrinad posted a topic in Products

By: MagicRichie - magicrichie Problem when using LDAP authentication 2006-07-05 04:22 Hai If have configured Acegi Security to authenticate against an LDAP. Authentication works fine. After authentication the user is redirected to /flow.html?.... the filterChainProxy bean then does a authorization check and does NOT take in consideration the Roles the user has. Threfor the user is treated as ANONYMOUS_USER and redirected back to /login.html On a first logon however it is shown the user gets the roles he has been added to: UserAuthorityServiceImpl,http-8080-Processor23:536 - Updated user: pnlgb131. Roles are now: ROLE_SELFHELP_ENABLED ROLE_USER ROLE_ADMINISTRATOR .... But this is not taken into consideration during the logon. Anyone an idea how to solve this ? Sincerely Richard By: Sherman Wood - sgwood RE: Problem when using LDAP authentication 2006-07-05 06:14 The roles are not important for actually getting past the login screen. Could you set debug logging on for the package: com.jaspersoft.jasperserver.api.metadata.user.service.impl and show us what is happening? This will show how the login process changes the authentication from LDAP to our internal authentication. Sherman JasperSoft By: MagicRichie - magicrichie RE: Problem when using LDAP authentication 2006-07-05 07:01 Hai Sherman, This is logged: The first and last few lines are repeated so I cut them off. 16:07:19,187 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor23:127 - SecurityContextHolder was changed to a different JI internal metadata token: authentication was null 16:07:19,187 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor23:127 - SecurityContextHolder was changed to a different JI internal metadata token: authentication was null 16:07:19,187 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor23:139 - After chain, JI metadata token is: 'null' 16:07:19,187 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor23:139 - After chain, JI metadata token is: 'null' 16:07:23,140 WARN LoggerListener,http-8080-Processor22:55 - Authentication event AuthenticationSuccessEvent: pnlgb131; details: org.acegisecurity.ui.WebAuthenticationDetails@ffff10d0: RemoteIpAddress: 141.93.32.117; SessionId: 73D9A51C5F15CCF369430827AA3ED995 16:07:23,140 WARN LoggerListener,http-8080-Processor22:55 - Authentication event InteractiveAuthenticationSuccessEvent: pnlgb131; details: org.acegisecurity.ui.WebAuthenticationDetails@ffff10d0: RemoteIpAddress: 141.93.32.117; SessionId: 73D9A51C5F15CCF369430827AA3ED995 16:07:23,406 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor25:91 - Authentication token: 'org.acegisecurity.providers.UsernamePasswordAuthenticationToken@e6f095ce: Username: org.acegisecurity.userdetails.ldap.LdapUserDetailsImpl@1705316; Password: [PROTECTED]; Authenticated: true; Details: org.acegisecurity.ui.WebAuthenticationDetails@ffff10d0: RemoteIpAddress: 141.93.32.117; SessionId: 73D9A51C5F15CCF369430827AA3ED995; Granted Authorities: ROLE_SELFHELP_ENABLED, ROLE_CN=SELFHELP_ENABLED' 16:07:23,406 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor25:91 - Authentication token: 'org.acegisecurity.providers.UsernamePasswordAuthenticationToken@e6f095ce: Username: org.acegisecurity.userdetails.ldap.LdapUserDetailsImpl@1705316; Password: [PROTECTED]; Authenticated: true; Details: org.acegisecurity.ui.WebAuthenticationDetails@ffff10d0: RemoteIpAddress: 141.93.32.117; SessionId: 73D9A51C5F15CCF369430827AA3ED995; Granted Authorities: ROLE_SELFHELP_ENABLED, ROLE_CN=SELFHELP_ENABLED' 16:07:23,421 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:424 - External user: pnlgb131 16:07:23,421 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:424 - External user: pnlgb131 16:07:23,718 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:486 - Login of external User: pnlgb131 16:07:23,718 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:486 - Login of external User: pnlgb131 16:07:23,718 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:487 - Roles from authentication: ROLE_CN=SELFHELP_ENABLED ROLE_SELFHELP_ENABLED 16:07:23,718 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:487 - Roles from authentication: ROLE_CN=SELFHELP_ENABLED ROLE_SELFHELP_ENABLED 16:07:23,734 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:488 - Current roles from metadata: ROLE_SELFHELP_ENABLED ROLE_USER ROLE_ADMINISTRATOR ROLE_CN=SELFHELP_ENABLED 16:07:23,734 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:488 - Current roles from metadata: ROLE_SELFHELP_ENABLED ROLE_USER ROLE_ADMINISTRATOR ROLE_CN=SELFHELP_ENABLED 16:07:23,734 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:489 - Current external roles for user from metadata: pnlgb131 ROLE_SELFHELP_ENABLED ROLE_CN=SELFHELP_ENABLED 16:07:23,734 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:489 - Current external roles for user from metadata: pnlgb131 ROLE_SELFHELP_ENABLED ROLE_CN=SELFHELP_ENABLED 16:07:23,750 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:634 - Setting Authentication to: org.acegisecurity.providers.UsernamePasswordAuthenticationToken@cc58acb2: Username: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.client.MetadataUserDetails@10699ea; Password: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: ROLE_SELFHELP_ENABLED, ROLE_USER, ROLE_ADMINISTRATOR, ROLE_CN=SELFHELP_ENABLED 16:07:23,750 DEBUG UserAuthorityServiceImpl,http-8080-Processor25:634 - Setting Authentication to: org.acegisecurity.providers.UsernamePasswordAuthenticationToken@cc58acb2: Username: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.client.MetadataUserDetails@10699ea; Password: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: ROLE_SELFHELP_ENABLED, ROLE_USER, ROLE_ADMINISTRATOR, ROLE_CN=SELFHELP_ENABLED 16:07:23,750 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor25:108 - Populated SecurityContextHolder with JI metadata token: 'org.acegisecurity.providers.UsernamePasswordAuthenticationToken@cc58acb2: Username: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.client.MetadataUserDetails@10699ea; Password: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: ROLE_SELFHELP_ENABLED, ROLE_USER, ROLE_ADMINISTRATOR, ROLE_CN=SELFHELP_ENABLED' 16:07:23,750 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor25:108 - Populated SecurityContextHolder with JI metadata token: 'org.acegisecurity.providers.UsernamePasswordAuthenticationToken@cc58acb2: Username: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.client.MetadataUserDetails@10699ea; Password: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: ROLE_SELFHELP_ENABLED, ROLE_USER, ROLE_ADMINISTRATOR, ROLE_CN=SELFHELP_ENABLED' 16:07:23,750 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor25:139 - After chain, JI metadata token is: 'null' 16:07:23,750 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor25:139 - After chain, JI metadata token is: 'null' 16:07:24,375 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor24:89 - No authentication token 16:07:24,375 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor24:89 - No authentication token 16:07:24,375 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor24:127 - SecurityContextHolder was changed to a different JI internal metadata token: authentication was null 16:07:24,375 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor24:127 - SecurityContextHolder was changed to a different JI internal metadata token: authentication was null 16:07:24,390 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor24:139 - After chain, JI metadata token is: 'null' 16:07:24,390 DEBUG MetadataAuthenticationProcessingFilter,http-8080-Processor24:139 - After chain, JI metadata token is: 'null' Thanks. Richard By: Sherman Wood - sgwood RE: Problem when using LDAP authentication 2006-07-06 06:22 Thanks, Richard. I am able to recreate the problem in my environment. We have other customers using LDAP successfully, so I am confused. I will raise a bug about it and look into it. Sherman JasperSoft By: Manuel - cachete22 RE: Problem when using LDAP authentication 2006-07-21 14:20 I am also having the same problem. It appears that authentication against ldap does authenticate me, and gets my roles from ldap ROLE_USER and ROLE_ADMINISTRATOR however i get redirected back to the login page and not forwarded to the next page. 16:15:04,823 INFO [server] JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2 date=200505022023)] Started in 40s:8ms holodev# holodev# 16:15:54,762 WARN [LoggerListener] Authentication event AuthenticationSuccessEvent: mcqueen; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: 192.168.2.47; SessionId: E5D68D57F5B760FF9801F4CFEA9F2D18 16:15:54,763 WARN [LoggerListener] Authentication event InteractiveAuthenticationSuccessEvent: mcqueen; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: 192.168.2.47; SessionId: E5D68D57F5B760FF9801F4CFEA9F2D18 16:15:54,977 INFO [XmlBeanDefinitionReader] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 16:15:55,010 INFO [sqlErrorCodesFactory] SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase] 16:15:55,238 WARN [userAuthorityServiceImpl] Added following external roles to: mcqueen ROLE_ADMINISTRATOR ROLE_USER 16:15:55,244 WARN [userAuthorityServiceImpl] Updated user: mcqueen. Roles are now: ROLE_USER ROLE_ANONYMOUS ROLE_ADMINISTRATOR 16:15:55,275 WARN [userAuthorityServiceImpl] Updated user: mcqueen. Roles are now: ROLE_USER ROLE_ANONYMOUS ROLE_ADMINISTRATOR 2006-07-21 16:15:55,320 DEBUG [org.acegisecurity.intercept.AbstractSecurityInterceptor] Secure object: FilterInvocation: URL: /loginsuccess.html; ConfigAttributes: [ROLE_USER] 2006-07-21 16:15:55,320 DEBUG [org.acegisecurity.intercept.AbstractSecurityInterceptor] Previously Authenticated: org.acegisecurity.providers.anonymous.AnonymousAuthenticationToken@905571d8: Username: anonymousUser; Password: [PROTECTED]; Authenticated: true; Details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: 192.168.2.47; SessionId: E5D68D57F5B760FF9801F4CFEA9F2D18; Granted Authorities: ROLE_ANONYMOUS 2006-07-21 16:15:55,321 DEBUG [org.springframework.web.context.support.XmlWebApplicationContext] Publishing event in context [Root WebApplicationContext]: org.acegisecurity.event.authorization.AuthorizationFailureEvent[source=FilterInvocation: URL: /loginsuccess.html] 2006-07-21 16:15:55,321 DEBUG [org.acegisecurity.ui.ExceptionTranslationFilter] Access is denied (user is anonymous); redirecting to authentication entry point org.acegisecurity.AccessDeniedException: Access is denied at org.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:275) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:104) 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:136) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) 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 org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

JasperIntelligence is moving!

ktrinad posted a topic in Products

By: Sherman Wood - sgwood JasperIntelligence is moving! 2006-07-18 21:04 See the news at: http://sourceforge.net/forum/forum.php?forum_id=592538 Forum: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=showcat&catid=10 We will start referring JasperIntelligence SourceForge posters to the JasperForge forum, and will stop answering questions on the JasperIntelligence Sourceforge.net forums in the next week. We look forward to working with you in our new home! Sherman JasperSoft

Error starting jasperserver

ktrinad posted a topic in Products

By: Kishor - kishor_g Error starting jasperserver 2006-07-18 09:45 I installed the jasper server using the windows installer on an existing windows tomcat installation(5.0.28) and existing windows mysql server installation (5.0.22). I am getting the an error with the scheduler non transaction database settings. Following is the start up tomcat log. Any help is appreciated. 2006-07-18 10:32:39 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@ea85b4') 2006-07-18 10:32:39 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@efeff8') 2006-07-18 10:32:39 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@738a71') 2006-07-18 10:32:39 StandardContext[/servlets-examples]SessionListener: contextDestroyed() 2006-07-18 10:32:39 StandardContext[/servlets-examples]ContextListener: contextDestroyed() 2006-07-18 10:32:39 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@2e6c66') 2006-07-18 10:32:39 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@1ced821') 2006-07-18 10:32:39 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@cf68af') 2006-07-18 10:32:39 StandardContext[/jsp-examples]SessionListener: contextDestroyed() 2006-07-18 10:32:39 StandardContext[/jsp-examples]ContextListener: contextDestroyed() 2006-07-18 11:30:19 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]] 2006-07-18 11:30:21 StandardContext[/jasperserver]Loading Spring root WebApplicationContext 2006-07-18 11:30:26 StandardContext[/jasperserver]Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' [see nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null']] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:645) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:546) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:860) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:829) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:409) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:238) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:148) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:247) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:331) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:155) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:240) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277) at org.apache.catalina.core.StandardHost.install(StandardHost.java:832) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:701) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) at org.apache.catalina.core.StandardService.start(StandardService.java:480) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) at org.apache.catalina.startup.Catalina.start(Catalina.java:556) 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.catalina.startup.Bootstrap.start(Bootstrap.java:287) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) * Nested Exception (Underlying Cause) --------------- org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' [see nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'] at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1396) at org.quartz.impl.jdbcjobstore.JobStoreCMT.cleanVolatileTriggerAndJobs(JobStoreCMT.java:210) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:645) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:546) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:860) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:829) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:409) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:238) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:148) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:247) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:331) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:155) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:240) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277) at org.apache.catalina.core.StandardHost.install(StandardHost.java:832) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:701) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) at org.apache.catalina.core.StandardService.start(StandardService.java:480) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) at org.apache.catalina.startup.Catalina.start(Catalina.java:556) 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.catalina.startup.Bootstrap.start(Bootstrap.java:287) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) * Nested Exception (Underlying Cause) --------------- org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111) at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1381) at org.quartz.impl.jdbcjobstore.JobStoreCMT.cleanVolatileTriggerAndJobs(JobStoreCMT.java:210) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:645) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:546) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:860) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:829) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:409) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:238) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:148) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:247) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:331) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:155) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:240) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277) at org.apache.catalina.core.StandardHost.install(StandardHost.java:832) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:701) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) at org.apache.catalina.core.StandardService.start(StandardService.java:480) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) at org.apache.catalina.startup.Catalina.start(Catalina.java:556) 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.catalina.startup.Bootstrap.start(Bootstrap.java:287) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) Caused by: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:243) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773) ... 48 more 2006-07-18 11:30:26 StandardContext[/jasperserver]Set web app root system property: 'jasperserver.root' = [C:jakarta-tomcat-5.0.28webappsjasperserver] 2006-07-18 11:30:26 StandardContext[/jasperserver]Initializing Log4J from [C:jakarta-tomcat-5.0.28webappsjasperserverWEB-INFclasseslog4j.properties] 2006-07-18 11:30:26 StandardContext[/jasperserver]Shutting down Log4J 2006-07-18 11:30:26 StandardContext[/jasperserver]Closing Spring root WebApplicationContext 2006-07-18 11:30:32 StandardContext[/jsp-examples]ContextListener: contextInitialized() 2006-07-18 11:30:32 StandardContext[/jsp-examples]SessionListener: contextInitialized() 2006-07-18 11:30:33 StandardContext[/servlets-examples]ContextListener: contextInitialized() 2006-07-18 11:30:33 StandardContext[/servlets-examples]SessionListener: contextInitialized() Thanks Kishor By: Lucian Chirita - lucianc RE: Error starting jasperserver 2006-07-18 10:01 See this post https://sourceforge.net/forum/message.php?msg_id=3818868 JasperServer is distributed with a Tomcat 5.5 context file. You'll have to manually adapt it for Tomcat 5.0. You can change META-INF/context.xml inside the jasperserver war or directly $TOMCAT/conf/Catalina/$host/jasperserver.xml HTH, Lucian

How to choose a different compiler ?

ktrinad posted a topic in Products

By: Tide - lovetide How to choose a different compiler ? 2006-07-18 03:28 I designed a report by iReport 1.2.5, and the report refer to some JDK 1.5 features, so I choose Java compiler as default compiler in iReport 1.2.5. After I created report unit in JasperIntelligence, and run it, then JasperIntelligence throws an exception like the following: Errors were encountered when compiling report expressions class file: 1. The method format(String, Object[]) in the type String is not applicable for the arguments (String, Long) value = (java.lang.String)(String.format("%02d", ((java.lang.Long)field_Hour.getValue())) + ":" + (((java.lang.Long)field_HalfAnHour.getValue()).longValue()==0 ? "00" : "30")); ........... ........... 3 errors String.format () method is JDK 1.5 feature, so it failed compiling, so can I choose Java compiler as the default compiler ? Thanks ! By: Lucian Chirita - lucianc RE: How to choose a different compiler ? 2006-07-18 04:02 JasperReports uses by default the Eclipse JDT compiler. To make this compiler work with Java 1.5 code, create a file named jasperreports.properties, place it somewhere on the application classpath (e.g. under $TOMCAT/webapps/jasperserver/WEB-INF/classes) and include the following properties in the file: org.eclipse.jdt.core.compiler.source=1.5 org.eclipse.jdt.core.compiler.compliance=1.5 org.eclipse.jdt.core.compiler.codegen.TargetPlatform=1.5 If you want to use another compiler instead of the JDT one, you need to set this property (in the same file): net.sf.jasperreports.compiler.class=compiler_class HTH, Lucian

Problem:- jasperserver with oracle conne

ktrinad posted a topic in Products

By: mardaraj - mardaraj Problem:- jasperserver with oracle conne 2006-07-17 05:06 hi i want configure oracle 10g with jasperserver. almost i had did. i changed in context.xml for oracle 10g. and changed in hibernate.properties for oracle -metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect now i am able to login jasperserver 0.9.2 but when i am clicking the tab administrator->Repository then it is giving error- plz give me any solution for this. it's urgent--- the error is like this- org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14ff81a targetAction = com.jaspersoft.jasperserver.war.action.RepositoryAction@1497b1, attributes = map[[empty]]] in state 'initAction' of flow 'repositoryFlow';nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper:org.springframework.dao.InvalidDataAccessApiUsageException:Write operations are not allowed in read-only mode (FlushMode.NEVER)- turn your Session into FlushMode.AUTO or remove 'readOnly' marker from transaction definition[/code]thanks Mardaraj By: Javy Dreamer - javydreamercsw RE: Problem:- jasperserver with oracle conne 2006-07-17 08:04 The same happenend to me, still no solution. By: Sherman Wood - sgwood RE: Problem:- jasperserver with oracle conne 2006-07-17 09:34 Have you seen this patch? http://sourceforge.net/tracker/index.php?func=detail&aid=1520756&group_id=162962&atid=825863 Sherman JasperSoft By: mardaraj - mardaraj RE: Problem:- jasperserver with oracle conne 2006-07-17 23:35 Hi Sherman , thanks for your reply . i am using oracle.jdbc.driver.OracleDriver for my datasource. and one thing is that you had given one link of patch file but this is related to jasperintilligence. can u give any patch file for jasperserver 0.9.2 with oracle. or tell me what are the changes required for this configuration. with regards Mardaraj

problem with ireport plug-in to jasper

ktrinad posted a topic in Products

By: mardaraj - mardaraj problem with ireport plug-in to jasper 2006-07-17 23:06 Hi, i am not able to do plug-in with jasper server from ireport,While login to jasper from ireport plug-in pane ,Axis fault Read time out is getting. Please find the stack trace as follows, org.apache.axis2.AxisFault: Read timed out; nested exception is: java.net.SocketTimeoutException: Read timed out; nested exception is: org.apache.axis2.AxisFault: Read timed out; nested exception is: java.net.SocketTimeoutException: Read timed out at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:230) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:544) at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:331) at org.apache.axis2.description.OutInAxisOperationClient.execute(OutInAxisOperation.java:267) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.login(WSClient.java:84) at com.jaspersoft.jasperserver.irplugin.JServer.main(JServer.java:124) The tomcat console is displayed with, Repository: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl@13cba41 11:25:29,437 WARN ResourceBundleMessageSource,http-8080-Processor25:184 - ResourceBundle [jasperserver_messages] not found for MessageSource: Can't find bundle for base name jasperserver_messages, locale en_US Thanks and regards, Mardaraj

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by ktrinad

Products

Explore