Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: table input doesnt run sometimes

  1. #1
    Join Date
    Jun 2015
    Posts
    3

    Default table input doesnt run sometimes

    Hi. In my kettle job, there is a transform that contains a postgres table input which creates a stream to 3 different switch case components in the same transform. The job runs nightly and every so often (maybe 1 out of 20 times) this transform appears to start but do nothing and pentaho thinks the transform ran fine. When I have to fix it, I re run just the transform and the situation gets corrected. The telltale sign in the log is the obvious nonappearance of the familiar switch / case components being reported as having finished processing after the statement "Table input - Finished reading query, closing connection". But the statement "Table input - Finished reading query, closing connection" shows even on what i'm calling "failure". The query looks complex but nothing in the various where clauses suggests to me that in any of the situations I've described zero rows would be returned. Where does someone start to resolve this kind of thing?

  2. #2
    Join Date
    Jun 2015
    Posts
    3

    Default

    I started poking around to see if this component sets and then tries to use vars which is identified in one link as a hit and miss situation. I don't know how to be sure if it is or isn't but don't see anything like that when opening the component. Will keep looking on the internet for other relevant information.

  3. #3
    Join Date
    Jun 2015
    Posts
    3

    Default

    I looked to see if this component sets and tries to use vars which is identified in one link as a hit and miss situation. I don't see anything like that happending but cant be sure I looked in the right places. I'll keep searching the web for other posts on the same issue.

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.