Search code examples
cachingpentahopdi

How do I clear the cache in Pentaho Data Integration


I am trying to run Pentaho Data Integration (ver. 8.3) in my Windows machine and it is not working. These are the steps I tried to make it work:

  • Tried rebooting the machine without success.
  • Also tried to run the Spoon.bat command directly from the directory where Pentaho is located, but it did not work.
  • Checked if my java installation changed since the last time it worked, it did not, what can be happening?

In a support chat I read someone was able to fix the problem by clearing the cache, but did not explain how to do it, how do I clean the cache?


Solution

  • These are the steps to clear the cache in a Windows environment:

    1. Go to C:\Users\youruser.kettle
    2. Look for the file db.cache-* (I have PDI version 8.3, my file is named db.cache-8.3.0.0-371) enter image description here
    3. Edit the file with any editor (i.e. Notepad) and erase all content

    It worked for me!