Pentaho

 View Only
Expand all | Collapse all

Error while trying to import table in Pentaho Metadata Editor - 9.3 on Openjdk 11

This thread has been viewed 20 times
  • 1.  Error while trying to import table in Pentaho Metadata Editor - 9.3 on Openjdk 11

    Posted 05-05-2023 09:29
      |   view attached

    Hello Experts - I am looking for some help around Pentaho Metadata Editor - 9.3.0.0-428 community edition running on openjdk 11. While trying to import tables, I am encountering an error 'org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "System_Schema"."Activity"]. java.net.UnknownHostException, at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2573)'.

    The same when run is working fine on Pentaho Metadata Editor 7.x version on JDK 8. Both the 9.3.x and 7.1.x are run on standalone mode.
    The connection type used is "Generic Database" and the configuration used is same for both the versions of Pentaho.

    Any help will be really great.



    ------------------------------
    Subhashish Mitra
    Systems Engineer
    BMC
    ------------------------------

    Attachment(s)



  • 2.  RE: Error while trying to import table in Pentaho Metadata Editor - 9.3 on Openjdk 11

    Posted 05-11-2023 06:08

    Hi,
    exception looks like problem with network. Can not translate  platform-sr-ext to IP and connect to server.
    Check if you can resolve this name and connect to server.



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



  • 3.  RE: Error while trying to import table in Pentaho Metadata Editor - 9.3 on Openjdk 11

    Posted 06-02-2023 08:26

    Thanks Petr for your help. Yes, it seems that there was intermittent network issues that I could figure with network guys.



    ------------------------------
    Subhashish Mitra
    Systems Engineer
    BMC
    ------------------------------