Pentaho

I am not sure this will be any help, but in some cases (such as in a PowerShell script), we've found it easier to run the Pentaho classes directly by calling java.exe rather than through the standard batch files. We just pulled the pieces out of the batch file that we needed and built the full command line. That turns the call into java.exe with the appropriate classes and parameters. I don't know if that will affect returning control to the JSP as you need to happen or not--may be worth a try because it bypasses the command shell.

Thanks for replying John, Can you give me an example of what exactly you did?

That might work for me because I can execute it as a Java command from inside our JSP and then once the command is done redirect to next page for download.

Sorry to be so slow getting back to you. I assume you've figured something out by now. But here's a fragment from a PowerShell script that we use as part of upgrading our ETL. The first part just builds the long set of arguments to run the launcher.jar which invokes org.pentaho.di.imp.Import (note that the launcher.jar must be used to run the Import class or you won't be able to connect to the repository. Only the last 2 lines contain parameters to the PDI Import class itself.

$BasicArgs =              "/k $PentahoDir\java\bin\java.exe "

$BasicArgs = $BasicArgs + '"-Dpentaho.installed.licenses.file=C:\Pentaho\.installedLicenses.xml" "-Xms4096m" "-Xmx8192m" "-Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2" '

$BasicArgs = $BasicArgs + '"-Djava.library.path=libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=Local" "-DKETTLE_USER=admin" "-DKETTLE_PASSWORD=password" "-DKETTLE_PLUGIN_PACKAGES=" '

$BasicArgs = $BasicArgs + '"-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" "-Dpentaho.installed.licenses.file=C:\Pentaho\.installedLicenses.xml" '

$BasicArgs = $BasicArgs + '-jar launcher\launcher.jar -lib ..\libswt\win64 -main org.pentaho.di.imp.Import '

$BasicArgs = $BasicArgs + '/rep:Local /user:admin /pass:password /dir:/ /norules:Y /replace:Y /comment:' + """$NewRelease"" "

$BasicArgs = $BasicArgs + '/filedir:' + """$ReleaseFolder\ETL"""

There's some additional logic to build a list of files to  load (saved in the variable $LoadFiles), then we run it like this:

# Append filenames to load to arguments

$BasicArgs = $BasicArgs + "$LoadFiles"

Start-Process -FilePath cmd.exe -ArgumentList $BasicArgs

(Presumably, you could skip running via Cmd.exe and just run java.exe as the process)

Hi John,

Sorry for the late reply, I got side tracked to a different project.

I have some more information, when I run the job from JSP, I get this extra line in log file:

18:28:09,390 ERROR [KarafLifecycleListener] The Kettle Karaf Lifecycle Listener failed to execute properly after waiting for 100 seconds. Releasing lifecycle hold, but some services may be unavailable.

If I execute the same command from command prompt, I do not.