Pentaho

 View Only
  • 1.  Pentaho 9.3 Archive installation to AWS EC2

    Posted 01-11-2023 02:31

    Hi,

    I have installed a 9.3 to an EC2 instance (2019 server) and its db is in another EC2  instance as  well (SQL Server). is there a special requirement i need to consider when installing to an EC2 instance? i ask because i am seeing below erros from tomcat logs after starting the pentaho server.

    org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Context] failed to set property [docbase] to [webapps/pentaho/]

    org.apache.karaf.main.Main$1.log Unable to delete archive directory - D:\Pentaho\Server\pentaho-server\pentaho-solutions\system\karaf\caches\default\data-1\cache\bundle1

    Invocation of init method failed; nested exception is javax.jcr.RepositoryException: File system initialization failure.
    org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Context] failed to set property [docbase] to [webapps/pentaho/]


    I have installed Java Version 19.0.1 2022-10-18.

    Many thanks
    Lee,



    ------------------------------
    Lee de guzman
    IT Support Manager
    Deltek Danmark A/S
    ------------------------------


  • 2.  RE: Pentaho 9.3 Archive installation to AWS EC2

    Posted 01-11-2023 04:25
    Hello Lee,

    A couple of things to consider:
    • Looks like you are using an unsupported version of Java (1.19) You have to use either Java 8 or 11. Help site reference
    • Is important that user responsible to start Pentaho service is the owner of the path and full permissions in the path

    Regards,

    Andrés Pérez
    Lead Enterprise Architect
    Customer Success at Hitachi Vantara

    ------------------------------
    Andres Perez Confortti
    Application Architecture Engineering - Specialist
    Hitachi Vantara
    ------------------------------



  • 3.  RE: Pentaho 9.3 Archive installation to AWS EC2

    Posted 01-11-2023 04:40
    Many thanks Andrés!

    Yep! saw that and used Java 11 now. Thank you!

    Tried to start Pentaho Server but its currently stuck in initializing for 20mins:

    2023-01-11 09:21:36,448 INFO [org.pentaho.di] 2023/01/11 09:21:36 - General - Logging plugin type found with ID: CheckpointLogTable
    2023-01-11 09:21:36,868 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

    Is it normal that it is taking this long to initialize?

    Thank you!

     


    ------------------------------
    Lee de guzman
    IT Support Manager
    Deltek Danmark A/S
    ------------------------------



  • 4.  RE: Pentaho 9.3 Archive installation to AWS EC2

    Posted 01-11-2023 05:02
    Could be. On that point it could be fetching the Pentaho Repository and synchronizing with the database (jackrabbit). Is it a SQLServer previously used for another Pentaho installation or is it a fresh install on both sides?

    Check for the rest of the logs generated at tomcat/logs in case there is any symptom of connectivity errors.

    Regards,

    ------------------------------
    Andres Perez Confortti
    Application Architecture Engineering - Specialist
    Hitachi Vantara
    ------------------------------



  • 5.  RE: Pentaho 9.3 Archive installation to AWS EC2

    Posted 01-12-2023 02:16
    Connect to your instance using SSH. (Optional) Ensure your instance has the latest Ubuntu AMI. Install the Instance Connect package on your instance. (Optional) Verify that Instance Connect was successfully installed on your instance.
    eHub Allied Universal Login
    ------------------------------
    Effie Rogers
    Director of Marketing
    Rogers ltd.
    ------------------------------