Analyse This

1. Posted by Sean on Dec 23, 2010

   Great, thanks!

2. Posted by Abhinandan on Jan 7, 2011

   Hi Prashant,

   First of all thank you for this wonderful blog.
   I would like to add few more points while using oracle with Pentaho.
   1. \biserver-ce\tomcat\conf\Catalina\localhost\pentaho.xml entries need to be changed.
   2. There is a need to change the new changes that is added to 3.7 version in \biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml
   Remove this tag
   


   org.pentaho.platform.web.http.context.HsqldbStartupListener

   

   and
   


   hsqldb-databases
   sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz

   

   Hopefully it will help the others as well.

3. Posted by egonzalez on Jan 14, 2011

   HI Prashant Raju,

   First thing, thanks a lto for the guide ! I’ve folled successfully the guide for the bi-server 3.6.0 But

   I’ve followed the guide for Oracle and bi Server 3.7.0 and I’m stuck cause, just after the pentaho webapp start well ( bi server is ready), I have a SEVERE : Error listenerStart.

   Is there any way you can help. I’ve registered to the pentaho community foum but I can’t post noew thread b now.

   Thanks in advance.

   By the way, on the 3.6.0 oracle sql script pacl, on the 1st file, ; is missing at the end of each table creation table line !

4. Posted by Prashant Raju on Jan 22, 2011

   Thanks Abhinandan!

   The guide has been updated to include this.

   Prashant

5. Posted by Jeroen on Jan 25, 2011

   Hello,

   Anybody succes with this guide on Windows7 32bits with SQL server 2008 R2? I have followed the guide several times but it fails every time. Also the install tomcat5 is not working because there is no service.bat in the tomcat/bin directory.

   I saw the changes to the file this morning and tried it once more but still fails. I have disaabled the HSQL database in the WEB.XML and start the tomcat service by the regular start-pentaho.bat because of the installation as a service is not working.

   I would like to hear that somebody got it working with the aboven mentioned configuration … to give me hope

   Jeroen

6. Posted by Prashant Raju on Jan 25, 2011

   Hi Jeroen

   Simply saying that “it fails every time” isn’t helpful with identifying the problem.

   What is catalina.out telling you?

   Please use pastie.org to paste your log output.

   Prashant

7. Posted by Jeroen on Jan 26, 2011

   Hello Prashant,

   Thanks for your response. I did a clean install again. All steps executed. Because I have no service.bat on my computer I started the included TOMCAT using the startup.bat in the pentaho/bi-server/tomcat/bin directory.

   Then the BI server is not running. Only the cataline.log is filled. See also http://pastie.org/1497082 for the log files.

   On row 13 I have a fatal error. Looks like pentaho.xml is the problem. I opened the pentaho.xml in ../pentaho-solutions/system but I can not find anything wrong with it. To be sure here is the file http://pastie.org/1497118

   Is it normal that http://localhost:8080 is not working with the included TOMCAT?

   I will try more but that is it for now.

   Greetings,
   Jeroen

8. Posted by Jeroen on Jan 26, 2011

   Hello,

   I have got it working now. I had made an error (of course) in the web.xml. Where to comment out the row that start the hsqldb I had a comment opening tag <!– but no closing tag.

   I looked like the error was in pentaho.xml but it was in fact in web.xml.

   Beside that I found another pentaho.xml file. It is in D:\pentaho\biserver-ce\tomcat\conf\Catalina\localhost directory and it contained still old JDBC connection information (using HSQL instead of MSSQL). I had it changed before I found the error so I do not know if it is anything important.

   Kind regards and thanks for your guide.

   Jeroen

9. Posted by Jeroen on Feb 1, 2011

   After installing it on localhost I now have it installed on our server. I had to edit the file in ..\tomcat 6.0\conf\catalina\localhost\pentaho.xml to make it work.

   Mayby it is because I partially copied it from my local instance but I could not get it working on localhost as on the server without editing that file. Mayby something to add to your guide …:-)

   Kind regards,
   Jeroen

10. Posted by sunny on Feb 18, 2011

    thanks a lot for the tutorial.. worked without a hitch… but i’m facing one problem… when i click on analysis view only the sample schemas are available .. how to change it to a custom database… plz help me..

11. Posted by alex on Feb 20, 2011

    Hello Prashant,
    first of all thanks for the useful guide! I’ve migrated to mysql but I’ve notified a “strange” behaviour of the server: it opens 2 mysql connections for every datasource defined even if no one is using it, is this normal?

    Regards,

    alex

12. Posted by Will on Mar 11, 2011

    Thanks for the doc. Very very nice. It saves big big headache.

    I have no java background at all and only know Linux little bit. The document is very clear and easy to follow. Definitely recommend for new users.

    Thanks again. Good job.

    Will

13. Posted by Will on Mar 13, 2011

    I agree with Jeroen./opt/pentaho/biserver-ce/tomcat/conf/Catalina/localhost/pentaho.xml does need to be updated in version 3.7. Once I update it, Pentaho BI Platform works to me. I can have it work for version 3.5 without edit this xml.

    Will

14. Posted by Allyson on Mar 16, 2011

    Thanks pras!

    i have to confess, it was (to me) a little more difficult than the older versions, rs.

    Great job. Keep the good work.

15. Posted by Luis Benavides on Mar 29, 2011

    Hello Prashant,

    After update all of file that you mention in your guide, my startup biserver doesn’t work. I had to change the pentaho.xml located in
    ..\biserver-ce\tomcat\conf\Catalina\localhost.
    An seting with all of parameter of MySQL.

    In this way my biserver-ce 3.8 work well.

    Thanks for you guide,
    Luis Benavides.

16. Posted by Ranu on Apr 13, 2011

    Hi.

    The document is of great help. But will this work with Mysql 4.1 ? I tried it but its giving a lot of errors.

    When i log into pentaho it says

    The following errors were detected
    One or more system listeners failed. These are set in the systemListeners.xml.
    PentahoSystem.ERROR_0014 – Error while trying to execute startup sequence for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener

    What is the problem?

    Thanks

17. Posted by Ranu on Apr 15, 2011

    Hi,

    I installed MySql 5.1 on my computer and made all changes to various files of biserver-ce.

    Pentaho Admin console opens up fine.
    When I add a new datasource, it says
    “connection not valid”. And also when I write a valid sql query it says “query validation failed”.

    Can you tell me where am I going wrong?

    Thanks

18. Posted by Tobias on Apr 17, 2011

    Like Jereon and Will, I also had to update the file “biserver-ce/tomcat/conf/Catalina/localhost/pentaho.xml”. Maybe it is because I am running Tomcat as a service?

19. Posted by Andy on Apr 20, 2011

    Hi Prashant. We’ve implemented Pentaho 3.7 CE on a Windows box using Oracle 10G as the repository. We followed the guide, the server starts and everything works just fine for a couple of hours, but at some point the connection between Pentaho and the hibernate database goes nuts. Repository doesn’t refresh, we can’t save a new analysis view, and we can’t open some views. Others work just fine.

    In the log we’re getting lines like these ones:
    10:42:50,160 ERROR [JDBCTransaction] JDBC commit failed
    java.sql.SQLException: Io exception: Connection reset
    10:42:50,176 ERROR [HibernateUtil] HIBUTIL.ERROR_0008 – commitTransaction() failed.
    org.hibernate.TransactionException: JDBC commit failed

    Any thoughts?

    Best regards

20. Posted by Ashish on Apr 24, 2011

    Hi Prashant,

    Thanks for this guide! But I am unable to download the SQL scripts pack from the provided link in the guide:
    https://docs.google.com/leaf?id=0B9Jmocc0fj_EN2MyZjc4ZjEtNzFkNC00NzIzLTljZTctZjIzZWQ1NjU3MzJk&sort=name&layout=list&num=50

    Please help.

    Regards,
    Ashish

21. Posted by Ashish on Apr 25, 2011

    Hi Prashant,

    Thanks for this guide! Really it is very helpful.But I am unable to download the SQL pack and receiving error. Can you please re-upload them for MySQL 5.

    Thanks,
    Ashish

22. Posted by Ashish on May 8, 2011

    Hi Prashant,

    Please upload the SQL packs once again.

    Thanks!

23. Posted by andtorg on May 11, 2011

    Hi Prashant,

    first of all many thanks for the documents you share. They are invaluable.

    May I suggest to insert into the guide the tips from this forum post, comment #17 by twarfield, (http://bit.ly/lSA4At)?

    It’s about downloading the tomcat6 missing files in 3.7 GA for installing pentaho as a windows service.

    BR

    andrea

24. Posted by Rob on Aug 19, 2011

    A couple of Mac install questions. 10.5.8 Fully updated and javadeveloper_for_mac_os_x_10.5__9m3425.dmg installed.

    First I used the Java Preferences app in the Utilities folder to choose the version of java. It is a bit of an odd app but I drug “Java SE 6″ to the top of the list and “unselected” J2SE 5.0 32 and 64 bit.

    And:
    RobsMacAir-2:~ rob$ java -version
    java version “1.6.0_26″
    Java(TM) SE Runtime Environment (build 1.6.0_26-b03-384-9M3425)
    Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02-384, mixed mode)

    So far so good. But…

    RobsMacAir-2:~ rob$ echo $JAVA_HOME
    /Library/Java/Home

    Hmm what Java is that?

    RobsMacAir-2:~ rob$ ls -li $JAVA_HOME
    39730668 lrwxr-xr-x 1 root admin 48 Aug 18 00:16 /Library/Java/Home -> /System/Library/Frameworks/JavaVM.framework/Home

    Not much help. Let’s track this down.

    RobsMacAir-2:Home rob$ ls -li /System/Library/Frameworks/JavaVM.framework
    39730711 lrwxr-xr-x 1 root wheel 24 Aug 18 00:17 Home -> Versions/CurrentJDK/Home

    RobsMacAir-2:Home rob$ cd /System/Library/Frameworks/JavaVM.framework
    RobsMacAir-2:JavaVM.framework rob$ pwd
    /System/Library/Frameworks/JavaVM.framework

    RobsMacAir-2:Home rob$ ls -li /System/Library/Frameworks/JavaVM.framework
    total 72
    39730709 lrwxr-xr-x 1 root wheel 27 Aug 18 00:17 Classes -> Versions/CurrentJDK/Classes
    39736741 lrwxr-xr-x 1 root wheel 24 Aug 18 00:18 CodeResources -> Versions/A/CodeResources
    39730710 lrwxr-xr-x 1 root wheel 28 Aug 18 00:17 Commands -> Versions/CurrentJDK/Commands
    39736742 lrwxr-xr-x 1 root wheel 27 Aug 18 00:18 Frameworks -> Versions/Current/Frameworks
    39736743 lrwxr-xr-x 1 root wheel 24 Aug 18 00:18 Headers -> Versions/Current/Headers
    39730711 lrwxr-xr-x 1 root wheel 24 Aug 18 00:17 Home -> Versions/CurrentJDK/Home
    39736744 lrwxr-xr-x 1 root wheel 23 Aug 18 00:18 JavaVM -> Versions/Current/JavaVM
    39730712 lrwxr-xr-x 1 root wheel 29 Aug 18 00:17 Libraries -> Versions/CurrentJDK/Libraries
    39736745 lrwxr-xr-x 1 root wheel 26 Aug 18 00:18 Resources -> Versions/Current/Resources
    166952 drwxr-xr-x 14 root wheel 476 Aug 18 00:18 Versions

    RobsMacAir-2:JavaVM.framework rob$ cd Versions
    RobsMacAir-2:Versions rob$ ls -li
    total 64
    39730713 lrwxr-xr-x 1 root wheel 5 Aug 18 00:17 1.3 -> 1.3.1
    167191 drwxr-xr-x 3 root wheel 102 Jan 14 2008 1.3.1
    18877862 lrwxr-xr-x 1 root wheel 5 Dec 16 2009 1.4 -> 1.4.2
    388609 lrwxr-xr-x 1 root wheel 3 Jun 24 2008 1.4.1 -> 1.4
    166953 drwxr-xr-x 8 root wheel 272 Jun 23 2008 1.4.2
    39731271 lrwxr-xr-x 1 root wheel 5 Aug 18 00:17 1.5 -> 1.5.0
    166970 drwxr-xr-x 8 root wheel 272 Jun 23 2008 1.5.0
    39730715 lrwxr-xr-x 1 root wheel 5 Aug 18 00:17 1.6 -> 1.6.0
    39730716 lrwxr-xr-x 1 root wheel 59 Aug 18 00:17 1.6.0 -> /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents
    167195 drwxr-xr-x 10 root wheel 340 Aug 18 00:18 A
    39736808 lrwxr-xr-x 1 root wheel 1 Aug 18 00:18 Current -> A
    39730775 lrwxr-xr-x 1 root wheel 3 Aug 18 00:17 CurrentJDK -> 1.5

    So it looks like CurrentJDK is pointing to 1.5.
    Current is pointing to A not sure what that is.

    Any idea if this is a problem or how to fix it. Seems very complex.

    –
    The other question is:
    “also add the following line to the bottom of the /etc/
    environment file:
    CATALINA_OPTS=”-Xms256m -Xmx768m -XX:MaxPermSize=256m -
    Dsun.rmi.dgc.client.gcInterval=3600000 -
    Dsun.rmi.dgc.server.gcInterval=3600000″”

    There is no /etc/environment on Mac? Where should this go.

Post a Comment