Not working with PDI 4.3.0

[GoogleCodeExporter]

Not working with PDI 4.3.0

Original issue reported on code.google.com by kleys...@gmail.com on 12 Nov 2012 at 1:14

[GoogleCodeExporter]

What do you mean "not working"? 

Does http://code.google.com/p/kettle-cookbook/issues/detail?id=42 solve it?

Original comment by roland.bouman on 12 Nov 2012 at 1:35

[GoogleCodeExporter]

Original comment by roland.bouman on 12 Nov 2012 at 1:35

• Changed state: NeedFeedback

[GoogleCodeExporter]

Sorry for the poor information.

I trying to run in the Windows with PDI 4.3.0 and kettle-cookbook r45.

I've checked issue 42 and I think is not the same problem.

Running cookbook inside Spoon I am getting the following errors:

(...)
2012/11/12 14:33:48 - transform_script, is_windows.0 - Set variable IS_WINDOWS 
to value [Y]
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Erro 
inesperado
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
org.pentaho.di.core.exception.KettleStepException: 
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Only 1 input 
row was expected to set the variables and at least 2 were received.
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
org.pentaho.di.trans.steps.setvariable.SetVariable.processRow(SetVariable.java:1
01)
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/11/12 14:33:48 - transform_script, is_windows.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
java.lang.Thread.run(Thread.java:619)
2012/11/12 14:33:48 - sort output.0 - Starting quickSort algorithm...
2012/11/12 14:33:48 - sort output.0 - QuickSort algorithm has finished.
2012/11/12 14:33:48 - sort input.0 - Starting quickSort algorithm...
2012/11/12 14:33:48 - sort input.0 - QuickSort algorithm has finished.
2012/11/12 14:33:48 - process-files - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) : Erros detectados!
2012/11/12 14:33:48 - process-files - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) : Erros detectados!
(...)
2012/11/12 14:33:48 - Output Files.0 - Finished processing (I=0, O=0, R=0, W=0, 
U=0, E=0)
2012/11/12 14:33:48 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) : Erro inesperado
2012/11/12 14:33:48 - Delete files.0 - Finished processing (I=0, O=0, R=0, W=0, 
U=0, E=0)
2012/11/12 14:33:48 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) : java.lang.NullPointerException
2012/11/12 14:33:48 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) :     at 
org.pentaho.di.trans.steps.xmljoin.XMLJoin.processRow(XMLJoin.java:103)
2012/11/12 14:33:48 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) :     at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/11/12 14:33:48 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) :     at 
java.lang.Thread.run(Thread.java:619)
2012/11/12 14:33:48 - <index>.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, 
E=0)
(...)

Original comment by kleys...@gmail.com on 12 Nov 2012 at 4:41

[GoogleCodeExporter]

I've found the attached message. And I changed in the process-files.ktr the 
regex expression to saxon?\.jar.

But now I am getting others errors:

(...)
2012/11/12 14:47:17 - match windows.0 - Signaling 'output done' to 1 output 
rowsets.
2012/11/12 14:47:17 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Erro 
inesperado
2012/11/12 14:47:17 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
java.lang.NullPointerException
2012/11/12 14:47:17 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
org.pentaho.di.trans.steps.getsubfolders.GetSubFolders.processRow(GetSubFolders.
java:93)
2012/11/12 14:47:17 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/11/12 14:47:17 - Get ${INPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
java.lang.Thread.run(Thread.java:619)
(...)
2012/11/12 14:47:17 - input foldername.0 - Signaling 'output done' to 1 output 
rowsets.
2012/11/12 14:47:17 - Get ${OUTPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
java.lang.NullPointerException
2012/11/12 14:47:17 - Get ${OUTPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
org.pentaho.di.trans.steps.getsubfolders.GetSubFolders.processRow(GetSubFolders.
java:93)
2012/11/12 14:47:17 - Get ${OUTPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/11/12 14:47:17 - Get ${OUTPUT_DIR} SubFolders.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :   at 
java.lang.Thread.run(Thread.java:619)
(...)
2012/11/12 14:47:17 - index / file.0 - Stopped looking for more rows.
2012/11/12 14:47:17 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) : Erro inesperado
2012/11/12 14:47:17 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) : java.lang.NullPointerException
2012/11/12 14:47:17 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) :     at 
org.pentaho.di.trans.steps.xmljoin.XMLJoin.processRow(XMLJoin.java:103)
2012/11/12 14:47:17 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) :     at 
org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/11/12 14:47:17 - index / file.0 - ERROR (version 4.3.0-stable, build 16786 
from 2012-04-24 14.11.32 by buildguy) :     at 
java.lang.Thread.run(Thread.java:619)
(...)

Original comment by kleys...@gmail.com on 12 Nov 2012 at 4:53

Attachments:

• cookbook-error.png

[GoogleCodeExporter]

Original comment by kleys...@gmail.com on 12 Nov 2012 at 4:55

Attachments:

• cookbook-params.png.jpg

[GoogleCodeExporter]

I have tryed this  in Windowns and Linux with PDI 4.4, 

got an error:
Only 1 input row was expected to set the variables and at least 2 were received.

Original comment by wangzhen...@gmail.com on 24 Dec 2012 at 1:42

[GoogleCodeExporter]

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

• Changed state: Duplicate

[GoogleCodeExporter]

I found de issue, i use the  version kettle 5.3.0.0-13 in windows 7

1. make sure the library \libext exist.
2. make sure that there is one file named saxon*.jar in my case i found 2 files 
: saxon-9.1.0.8.jar and saxon-dom-9.1.0.8.jar 

when i delete the file saxon-dom-9.1.0.8.jar the process finish succesfull.

Try. 

Original comment by uddavi...@gmail.com on 9 Apr 2015 at 7:16

[GoogleCodeExporter]

Kettle Cookbook has moved to github. 

https://github.com/rpbouman/kettle-cookbook

This issue was already solved - clone the project and run to see if that works 
for you.

Original comment by roland.bouman on 9 Apr 2015 at 7:30

• Changed state: Fixed