Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: PDI 6.0 - dataservice ok in spoon, not visible as table with Carte

  1. #1

    Default PDI 6.0 - dataservice ok in spoon, not visible as table with Carte

    With pdi-ce-6.0.0.0-353 and Carte I can create and test dataservices succesfully.
    But they are not listed as tables when connected via JDBC.

    What does work:
    http://localhost:9080/kettle/status/ works fine, and my file based repository is shown
    I can start a transformation with
    http://localhost:9080/kettle/execute...sformatie1.ktr, this returns the JSON output

    I can start a job with
    http://localhost:9080/kettle/runJob/...testje%2FMJob1, this returns the 'job started' message in xml
    After this the transformation and job are listed in http://localhost:9080/kettle/status/

    What doesn't:
    I can create and test a dataservice in spoon from the above mentioned transformation but when connected via JDBC I can't explore the database, there are no tables visible. I'm using Squirrel-SQL as a client for testing.
    http://localhost:9080/kettle/listServices returns a blank page
    My .pentaho/metastore folder remains empty

    What's the next step in troubleshooting?

    Regards,

    Peter

    My carte config xml:

    --

    <slave_config>


    <slaveserver>
    <name>master1</name>
    <hostname>localhost</hostname>
    <port>9080</port>
    <!--<webAppName>pentaho-di</webAppName>-->
    <username>cluster</username>
    <password>cluster</password>
    <master>Y</master>
    </slaveserver>


    <repository>
    <name>testje</name>
    <username></username>
    <password></password>
    </repository>


    </slave_config>

    --

  2. #2

    Default

    Anyone?

  3. #3

    Default

    Found the metastore location where dataservices are listed: .meta\metastore\pentaho\Data Service Transformation
    within the filebased repository

    MyDataservice1.xml contains
    --
    <?xml version="1.0" encoding="UTF-8"?>
    <element>
    <id>MyDataservice1</id>
    <value></value>
    <type>String</type>
    <children>
    <child>
    <id>trans_references</id>
    <value>org.pentaho.di.trans.dataservice.serialization.ServiceTrans$Reference</value>
    <type>String</type>
    <children>
    <child>
    <id>0</id>
    <value></value>
    <type>String</type>
    <children>
    <child>
    <id>transformation_location</id>
    <value>/Transformatie1</value>
    <type>String</type>
    </child>
    <child>
    <id>transformation_storage_method</id>
    <value>REPO_PATH</value>
    <type>String</type>
    </child>
    </children>
    </child>
    </children>
    </child>
    </children>
    <name>MyDataservice1</name>
    <security>
    <owner/>
    <owner-permissions-list/>
    </security>
    </element>
    --

  4. #4
    Join Date
    Oct 2015
    Posts
    14

    Default

    Hi,

    I am facing a similar issue. Were you able to properly resolve this? If so, could you elaborate please?


    Regards,
    Lior

  5. #5

    Default

    Nope, still have my hopes on one of the gurus on this forum

  6. #6
    Join Date
    Jan 2011
    Posts
    10

    Default

    Same problem here, but i use database repository.

    Got record in r_trans_attribute but data service is not listed on Carte.

    Mark

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.