Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kettle Job with SQL entry doesn't RUN

  1. #1
    Join Date
    Nov 2014
    Posts
    2

    Default Kettle Job with SQL entry doesn't RUN

    Hello,

    I am using the Kettle GAR 5.2.0.0 Release and I am trying to run a simple kjb Job which inserts an new entry into a Sybase Table using the Native JDBC Connection. The Job consists of a START, SQL and DUMMY entry, wherein the SQL script looks like:
    INSERT INTO test_link (quest_id, quest_no) VALUES ('A', 'ALPHA');

    The Job doesn't execute the aforementioned SQL command (or any other SQL), although finishing correctly, and the Detailed Logging doesn't provide any further information. Please note that a similar ktr Transformation which includes an "Execute SQL script" entry runs smoothly without any issue.

    Any advice would be welcome,

  2. #2
    Join Date
    Nov 2014
    Posts
    2

    Default

    Hello,

    the issue has been resolved. The Hop between the Start and SQL entry had been disabled!

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.