Currently in production using pentaho 18.104.22.168. Among other things we use it as a quick way to download data for our users. We have select queries to get this data and generate a CSV file.
To launch these queries we have JSP pages. Using JSP pages users can give input data. then we use
Process proc = Runtime.getRuntime().exec(etlCommand);
statement to execute a batch file. This batch file internally calls pan.bat/kitchen.bat to execute a PDI transformation/job
Once PDI job/transformation is done executing it generates a file at a given location. Once the batch file is done it returns the control back to JSP which provides a link for users to download the file.
I am currently in the process to upgrade to PDI 22.214.171.124. Now when we execute the batch file from within JSP, it generates the data file but even after batch file is done executing it does not returns the control back to the JSP. Because of which JSP eventually times out and does not provides a link to download.
When I execute the batch file directly from command prompt it shows me a bunch of info statements but eventually it finishes.
Can someone help me with I control is not returning? Let me know if any other information is required.