Doesn't work in PDI 4.2-RC1

[GoogleCodeExporter]

Something has changed because nothing is generated in PDI 4.2-RC1

Original issue reported on code.google.com by tom.bar...@meteorite.bi on 22 Jul 2011 at 7:47

[GoogleCodeExporter]

Hi,
first of all, thanks for this amazing tool. Very useful. Being a first-time 
user, I came across two different issues and came up with two brutish 
workaround, hopefully waiting for your more elegant solution.

1) in process-files.ktr we have two input rows for the set variables step 
(transform_script,is_windows). This triggers an error. So, after the calculator 
step I inserted two additional steps: select values to retrieve only the two 
relevant columns and a group by to reduce the stream to one row.

2) Make executable job entry fails on my Ubuntu 10.04. So I ran Spoon as root 
and then fired a chown -R from shell to give ownership of output folder to my 
user (maybe here I could spend some more time, but I was in a hurry to try the 
stuff).

HTH
Best regards
Andrea   

Original comment by andt...@gmail.com on 17 Aug 2011 at 4:57

[GoogleCodeExporter]

Update.

1) The issue is in "Get Saxon Jar" step: the wildcard matches two saxon 
libraries in /libext. This also duplicated the entries in index.xml. I tried 
and fixed the regexp and it seems working fine now. So, forget the workaround 
mentioned above. 

Original comment by andt...@gmail.com on 17 Aug 2011 at 5:47

[GoogleCodeExporter]

Hi!

thanks for the input. Just for my information - does the regex fix the entire 
issue for you? Maybe I should use your regexp instead of mine? 

Please let me know, I will gladly make the change at my end...

Original comment by roland.bouman on 17 Aug 2011 at 7:38

• Changed state: Accepted

[GoogleCodeExporter]

Hi!

thanks for the input. Just for my information - does the regex fix the entire 
issue for you? Maybe I should use your regexp instead of mine? 

Please let me know, I will gladly make the change at my end...

Original comment by roland.bouman on 17 Aug 2011 at 7:38

[GoogleCodeExporter]

Hi Roland,
saxon\d+\.jar

This regex works fine at the moment. Probably we'll need to change it if saxon 
version number become more complicated.  

I still have a problem with chmod in Make executable step, but I don't give in 
:)

Cheers

Original comment by andt...@gmail.com on 17 Aug 2011 at 8:16

[GoogleCodeExporter]

Hi All,

I ran Kettle-cookbook job with PDI 4.2.1 but I got below error.

Can anyone help me out here.

2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected 
error
2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 
org.pentaho.di.core.exception.KettleStepException: 
2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Only 1 input 
row was expected to set the variables and at least 2 were received.
2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 
2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :   at 
org.pentaho.di.trans.steps.setvariable.SetVariable.processRow(SetVariable.java:9
0)
2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :   at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2011/12/09 20:25:53 - transform_script, is_windows.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :   at 
java.lang.Thread.run(Thread.java:619)

Thanks,
Anand

Original comment by anand.sa...@gmail.com on 9 Dec 2011 at 2:59

[GoogleCodeExporter]

Anand,
did you check out comments 2 and 5? Problem should be fixed that way 

Original comment by andt...@gmail.com on 9 Dec 2011 at 3:43

[GoogleCodeExporter]

Thanks for the details..We have fixed the issue. ..
Steps:
1. Open process-files.ktr transformation
2. edit Get Saxon Jar
3. Under wildcard(RegExp) put saxon?\.jar

Reason: In PDI 4.1 we have only saxon8.jar but in PDI 4.2 there are 2 file 
names with saxon jars so there will be ambiguity. To overcome this issue we 
have mentioned saxon?\.jar which will take only one character after saxon word. 

Still some issue is there with Java version in my system. I got the below error 
in PDI 4.2

2011/12/15 23:32:36 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected 
error
2011/12/15 23:32:36 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 
java.lang.NullPointerException
2011/12/15 23:32:36 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :   at 
org.pentaho.di.trans.steps.getsubfolders.GetSubFolders.processRow(GetSubFolders.
java:82)
2011/12/15 23:32:36 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :   at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2011/12/15 23:32:36 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :   at 
java.lang.Thread.run(Thread.java:619)

Thanks,
Anand P.S

Original comment by anand.sa...@gmail.com on 15 Dec 2011 at 6:36

[GoogleCodeExporter]

This issue has been resolved. Kettle-cookbook should be placed under the PDI 
4.2 then everything will be set. 

Original comment by anand.sa...@gmail.com on 19 Jan 2012 at 7:45

[GoogleCodeExporter]

"This issue has been resolved. Kettle-cookbook should be placed under the PDI 
4.2 then everything will be set."
Please be more specific. Questions: Where "under" PDI? The server or spoon?

Original comment by HelmetCa...@gmail.com on 20 Jan 2012 at 11:35

[GoogleCodeExporter]

Hi All, 

I think this issue has actually been resolved a while ago by setting the saxon 
jar as a parameter. This was needed anyway in order to allow cookbook to be run 
from another directory than the PDI home directory. 

please checkout the latest revision (76) and see if this is satisfactory. 
please let me know if that solution poses any problems to you. 

Original comment by roland.bouman on 21 Jan 2012 at 9:38

[GoogleCodeExporter]

Original comment by roland.bouman on 16 Apr 2014 at 2:03

• Changed state: Done

[GoogleCodeExporter]

Original comment by roland.bouman on 16 Apr 2014 at 2:06

• Changed state: Fixed

[GoogleCodeExporter]

Issue 50 has been merged into this issue.

Original comment by roland.bouman on 16 Apr 2014 at 2:06