AnsweredAssumed Answered

Unable to execute pan.bat from JSP

Question asked by saket Maheshwary on Aug 6, 2018
Latest reply on Aug 9, 2018 by saket Maheshwary

Currently in production using pentaho 6.1.0.1. 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 8.1.0.0. 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.

 

Thanks

Outcomes