Profile

saket Maheshwary

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 13 of 13 total

Unable to access network folder using UNC

Posted By saket Maheshwary 11-26-2018 13:35
Found In Community: Pentaho \ view thread
I am using PDI 8.1 CE in Windows environment. I am trying to access some network folders using UNC but getting below error: File is there but PDI is not able to see it. One thing that I have observed is that where we get error java.io.FileNotFoundException instead of accessing the location with \\ at ...

RE: Unable to execute pan.bat from JSP

Posted By saket Maheshwary 11-02-2018 12:27
Found In Community: Pentaho \ view thread
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 ...

Unable to call PDI JOB from a JSP page

Posted By saket Maheshwary 11-01-2018 14:52
Found In Community: Pentaho \ view thread
We have an application where we get some input arguments in a JSP and then call a pentaho Job from with JSP using command: Runtime.getRuntime().exec(etlCommand); Basically what we do is we, call a batch file from JSP. We pass all the arguments into batch file which in turn calls kettle.bat to invoke ...

Unable to call PDI JOB from a JSP page

Posted By saket Maheshwary 11-01-2018 14:52
Found In Library: Pentaho

RE: Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 10-01-2018 20:13
Found In Community: Pentaho \ view thread
This content was either too long or contained formatting that did not work with our migration. A PDF document is attached that contains the original representation   //***********I am setting up the variables for logfile and output file and job specific **************//  else if (job.equalsIgnoreCas ...

RE: Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 10-01-2018 14:12
Found In Community: Pentaho \ view thread
even after commenting the call to redirect output and invoking pan using call results are still the same. I commented all the echo statements. During all three tests behavior remains the same.

RE: Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 09-28-2018 18:42
Found In Community: Pentaho \ view thread
Didnt realize I can not attach files on this forum. I believe first and third worked fine one worked. Not sure in second point what to you mean by without redirecting the output into a file.? Please elaborate. Again appreciate you taking time out of your busy schedule.

RE: Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 09-28-2018 15:23
Found In Community: Pentaho \ view thread
I tried with call but same behavior. I have been using these same batch files on older servers without any issue for quite sometime. I believe problem is that launcher command does not return the control back after successful execution. Not sure why though.

RE: Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 09-28-2018 13:20
Found In Community: Pentaho \ view thread
Thanks for the reply Joao Figueiredo. I really appreciate it. From my JSP I call following command: >\ExecuteETLTransformation.bat >\data-integration-8.1.0.0 PDI_RepoName PDI_TransformationName PDI_username PDI_Pwd >\LogFileaName.log -param:v_month=JAN -param:v_year=2018 Contents of Execute ETLTransformation.bat ...

Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 09-25-2018 19:12
Found In Community: Pentaho \ view thread
Hello, I am working on a project to upgrade PDI to version 8.1.0.0. We have some add-hoc PDI jobs/transformations which users can execute at will. We have stood up some simple JSP pages running on Tomcat server. In JSP pages we take input arguments and call a batch file (and pass the arguments). In the ...

Pan.bat hangs after completing the transformation

Posted By saket Maheshwary 09-25-2018 19:12
Found In Library: Pentaho

RE: Unable to execute pan.bat from JSP

Posted By saket Maheshwary 08-09-2018 19:22
Found In Community: Pentaho \ view thread
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.

Unable to execute pan.bat from JSP

Posted By saket Maheshwary 08-06-2018 17:52
Found In Community: Pentaho \ view thread
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 = ...