Tuesday, February 19, 2019

Installing Pentaho pdi-ce-6.0.1.0-386 data integration - The system cannot find the path specified

Download the OLAP Pentaho platform: http://sourceforge.net/projects/pentaho/?source=directory

The installation file can be downloaded on SourceForge site - and once it is downloaded extract the file to your intended folder. Run the application by clicking on the spoon.bat file in the folder and the problem started where the command prompt briefly popped up and disappear right away. Then nothing happens.

If this is the case run the command prompt by click on Windows Start>>Run>> and type CMD and press enter. Go to the Pentaho folder by typing the command as follows



c:\ cd desktop\pdi-ce-6.0.1.0-36\data-integration <-- this command will change the directory to where the spoon.bat file is. The directory folder maybe different in different computer depending on where you extracted the file and in my case it's in the desktop.

on the data-integration folder type "spoon.bat" to run the file and the error data will show as below.

C:\Users\mypc\Desktop\pdi-ce-6.0.1.0-386\data-integration>spoon.bat
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=javaw.exe
The system cannot find the path specified.
The system cannot find the path specified.

C:\Users\mypc\Desktop\pdi-ce-6.0.1.0-386\data-integration>start "Spoon" "javaw.
exe"  "-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m" "-Dhttps.protocols=TLSv1,TL
Sv1.1,TLSv1.2" "-Djava.library.path=libswt\win32" "-DKETTLE_HOME=" "-DKETTLE_REP
OSITORY=" "-DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DK
ETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\pentaho-application-l
auncher-6.0.1.0-386.jar -lib ..\libswt\win32

C:\Users\mypc\Desktop\pdi-ce-6.0.1.0-386\data-integration>

Solution to the Problem

  1. Download Oracle Java jdk-8u71-windows-x64.exe (64 bit) or jdk-8u71-windows-i586.exe from Oracle Website http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Once it is download then installed it
  3. After installed open the Pentaho pdi-ce-6.0.1.0-386\data-integration folder and edit spoon.bat file using Notepad++
  4. In the spoon.bat file look for this section 
  5. REM Special console/debug options when called from SpoonConsole.bat or SpoonDebug.bat if "%SPOON_CONSOLE%"=="1" set PENTAHO_JAVA=java.exe if not "%SPOON_CONSOLE%"=="1" set PENTAHO_JAVA=javaw.exe set IS64BITJAVA=0 call "%~dp0set-pentaho-env.bat"
  6. Open the directory folder where the java is installed and find the java.exe and javaw.exe and copy its location address for example in my PC they are installed in these folder C:\Program Files\Java\jre1.8.0_71\bin\java.exe and C:\Program Files\Java\jre1.8.0_71\bin\javaw.exe
  7. Replace the PENTAHO_JAVA=java.exe so that it reads PENTAHO_JAVA=C:\Program Files\Java\jre1.8.0_71\bin\java.exe and PENTAHO_JAVA=javaw.exe with PENTAHO_JAVA=C:\Program Files\Java\jre1.8.0_71\bin\javaw.exe
  8. Save the file and run the spoon.bat again. It should work

4 comments:

  1. Awesome !!! Thank you so much for the clear steps !!! You saved hours of time for me !!! Bless you !!

    ReplyDelete
  2. Hi,

    In my case, I have next below path for both:

    C:\Program Files (x86)\Java\jre1.8.0_121\bin\java.exe
    C:\Program Files (x86)\Java\jre1.8.0_121\bin\javaw.exe

    But, this path contain white spaces and is not allowed when I execute the bacth file called "spoon.bat". I've added double quote mark in the path, but even like this doesn't work.

    Do you have any idea how do I need to specify it?

    ReplyDelete
  3. I think the white space should be use as _ (underscore) for example C:\Program_Files_(x86)......

    ReplyDelete