Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Kettle is not fetching updated database field, in "Database Lookup" Step !!

  1. #1
    Join Date
    Nov 2013
    Posts
    6

    Default Kettle is not fetching updated database field, in "Database Lookup" Step !!

    Hello Smarties,
    I updated my Database & added 1 field(column) in 1 of my table.
    When I opened that kettle-"Database Lookup" Step....
    That updated field isn't coming, for that Lookup Table.

    I restarted my PC & the Kettle itself, a lot of times.
    But the issue isn't solved.
    Tell me the solution please.

    Thank you.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You must clear the Kettle DB Cache after such changes.
    You can use main menu action Tools -> Database -> Clear Cache
    Or you can use action "Clear DB Cache of ..." from the context menu of a specific database connection.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2013
    Posts
    6

    Default

    Quote Originally Posted by marabu View Post
    You must clear the Kettle DB Cache after such changes.
    You can use main menu action Tools -> Database -> Clear Cache
    Or you can use action "Clear DB Cache of ..." from the context menu of a specific database connection.
    Thank you....Marabu sir
    It worked....

    Thanks Again, you smart guy.

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.