Pentaho

 View Only
  • 1.  Pentaho Community Edition - can not run

    Posted 10-19-2023 02:57

    Dear Community members!

    I downloaded, I believe last PDI (pdi-ce-9.4.0.0-343) and can not initiate Spoon.bat file.

    For additional information: I tried all possible ways provided on internet (creating environment variables, copying Java to PDI folder and so on) and of no success.

    A few of my colleagues from IT backend also did not succeed, only saying that workarounds worked in the beginning of the year.

    But in principle, why is this so messy for open-source edition?

    Regards,



    ------------------------------
    Arvins
    ------------------------------



  • 2.  RE: Pentaho Community Edition - can not run

    Posted 10-19-2023 05:14

    I have a similar issue (pentaho-server-ce-9.4.0.0-343) on Linux (Ubuntu). I am not able to locate ./spoon.sh anywhere in the installed folder (/usr/local/pentaho-server/).  What I am able to locate is start-pentaho.sh however when I try to run it, it doesn't start. I get start-pentaho.sh: command not found ... I am lost



    ------------------------------
    Jeff Bamba
    Chief Executive Officer
    INFOVIEW DATA SOLUTIONS
    ------------------------------



  • 3.  RE: Pentaho Community Edition - can not run

    Posted 10-19-2023 05:29

    yes, but why there is no documentation/ guidance from Pentaho how to install/run/troubleshoot Community Edition? Only workaround videos which possibly worked for someone, but is not procedure provided by Pentaho?



    ------------------------------
    Arvins Zandars
    Business Development Manager
    Private
    ------------------------------



  • 4.  RE: Pentaho Community Edition - can not run

    Posted 10-19-2023 14:07

    pentaho-server-ce.zip is another distribution of app. It's BA server. Download and unpack pdi-ce.zip file.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------



  • 5.  RE: Pentaho Community Edition - can not run

    Posted 10-19-2023 16:44

    Thanks @Petr Prochazka
    I have installed PDI now. I have scanned the web for different sources to resolve multiple roadblocks so far. However, I am at a standstill now. When I run the $ sudo  ./spoon.sh I am getting the error below. I have done everything I can find online about this error without success.

    ubuntu@ip-#########:/opt/data-integration$ sudo ./spoon.sh
    Authorization required, but no authorization protocol specified
    org.eclipse.swt.SWTError: No more handles [gtk_init_check() failed]
        at org.eclipse.swt.SWT.error(SWT.java:4621)
        at org.eclipse.swt.widgets.Display.createDisplay(Display.java:1038)
        at org.eclipse.swt.widgets.Display.create(Display.java:1025)
        at org.eclipse.swt.graphics.Device.<init>(Device.java:179)
        at org.eclipse.swt.widgets.Display.<init>(Display.java:590)
        at org.eclipse.swt.widgets.Display.<init>(Display.java:581)
        at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:679)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

    I found a possible solution https://stackoverflow.com/questions/42800117/error-org-eclipse-swt-swterror-no-more-handles-gtk-init-check-failed-on-cen and followed the step, however, I am still getting the error message above.

    I need help.



    ------------------------------
    Jeff Bamba
    Chief Executive Officer
    INFOVIEW DATA SOLUTIONS
    ------------------------------



  • 6.  RE: Pentaho Community Edition - can not run

    Posted 10-20-2023 05:02

    IMHO problem is call via sudo. Root may not have access to X server. Run spoon.sh under standard user ubuntu.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------



  • 7.  RE: Pentaho Community Edition - can not run

    Posted 10-22-2023 07:34

    Hello @Petr Prochazka
    I tried that as well. Here is the error I am getting.

    ubuntu@ip-###-##-$$-98:/opt/data-integration$ ./spoon.sh
    ./spoon.sh: 278: /usr/lib/jvm/default-java/bin/java: not found

    What is are my option or what should I do next



    ------------------------------
    Jeff Bamba
    ------------------------------



  • 8.  RE: Pentaho Community Edition - can not run

    Posted 10-23-2023 11:17

    Agree with each response from @Petr Prochazka (server versus, client tools, root versus ubuntu).  The path above is likley inherited from JAVA_HOME, but you can override with PENTAHO_JAVA_HOME to make sure it find the right version.  You likely tried this in prior debugging under root and not ubuntu, or installed Java under root and not all users have access.

    Linux is a nested set of synbolic links to allow easier version updates.  Check your environment for JAVA_HOME and PENTAHO_JAVA_HOME, the latter is only needed if the two versions are not the same or you want to skip past all the links.  Make sure all the links are valid and available to ubuntu.
    Double check that java is really there with 'java -version'.   



    ------------------------------
    Stephen Donovan
    Digital Solutions Architect
    Hitachi Vantara
    ------------------------------