PDA

View Full Version : Data Integration 4 kitchen param



dramis
06-25-2010, 10:12 AM
Hello,

I made a simple job getting a parameter write it to log and quit.

It's working fine with data integration but when i run the job in command line with kitchen, the parmeter is not set.

I got this issus with osx and linux.


Thanks for your help.

MattCasters
06-25-2010, 01:59 PM
Well, you have to specify the parameter value as a kitchen parameter (-param:PARAMETER=VALUE)

khelms
06-25-2010, 02:20 PM
I am having the same issue:

Created a job with a parameter ZipFileName, default NONE. Added a write to log step with:
ZipFileName=${ZipFileName}

5696

Run it:
/opt/pentaho/design-tools/pdi-ee-4.0.0-GA/kitchen.sh -norep -file=TestFile.kjb -level=Detailed -param:ZipFileName=ker.zip

Output: ZipFileName=NONE

khelms
06-25-2010, 02:43 PM
Quoting the parameter had no impact:
/opt/pentaho/design-tools/pdi-ee-4.0.0-GA/kitchen.sh -file=/var/pdi-assets/bnsfldw/Cargowise/TestFile.kjb "-param:ZipFileName=ker.zip"

No benefits from making the parameter name all upper-case (it is linux after all) or removing the extra options from the comman line.

khelms
06-25-2010, 02:51 PM
Ok, this is REALLY odd. Adding "-listparam" to the end of the command shows that the parameter is being picked up:

/opt/pentaho/design-tools/pdi-ee-4.0.0-GA/kitchen.sh -norep -file=TestFile.kjb -level=Detailed -param:ZipFileName=ker.zip -listparam

INFO 25-06 13:44:55,154 - Using "/tmp/vfs_cache" as temporary files store.
INFO 25-06 13:44:55,500 - Kitchen - Kitchen
Parameter: ZipFileName=ker.zip, default=NONE : Full path name and file name of zip archive

The exact same command line without the "-listparam" still returns that it has no value in the variable.

Are we accessing the parameter value within the job in the wrong way?

khelms
06-25-2010, 04:10 PM
Filing a support case for this one. Will post any resolution. (Case 00011014)

dramis
06-26-2010, 09:09 AM
The parameter on command line work in KEttle version 3.2.3.

dgraselli
06-27-2010, 01:13 AM
Check if you have this:

1) Append
"-param:PARAM_NAME_1=PARAM_VALUE_1 -param:PARAM_NAME_2=PARAM_VALUE_2"
at end of kitchen command ?

2) That params are included in the job properties with right click + properties on the job canvas.

dramis
06-28-2010, 08:15 AM
Dont work with

"-param:start_date=20100606"

khelms
06-28-2010, 10:13 AM
Posted as case 4219:

http://jira.pentaho.com/browse/PDI-4219

gutlez
06-28-2010, 11:34 AM
Could you post your sample? (and attach to your JIRA)

khelms
06-28-2010, 12:14 PM
Everything is posted in jira PDI-4219 (http://jira.pentaho.com/browse/PDI-4219)

MattCasters
06-28-2010, 01:24 PM
Ready for test in 4.0.1 and trunk (4.1.0-M1)

dramis
06-28-2010, 02:21 PM
revision 13464 fix the problem.

khelms
06-29-2010, 04:39 PM
Is this fix available as part of an enterprise edition release?

Edit: The question as originally posed was premature. Sorry.