Parse parameter to "kettle over kettleTransFromFile" datasource

[blijblijblij]

Hi all,

I've been searching the intertubus, but so far have not come up with a solution to a very nagging problem.

My goal: cde table component > filled by a kettle transformation > while using a cde defined parameter

I've used the samples file for using kettle with CDA, but I keep running into trouble.

My transformation:

Screenshot from 2012-08-01 14:23:15.jpg

The cde datasource:

Screenshot from 2012-08-01 14:24:49.jpg

The error message:

INFO  01-08 14:12:16,964 - Table input - Finished reading query, closing connection.
INFO  01-08 14:12:16,970 - Table input - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
INFO  01-08 14:12:17,040 - fields - fields
INFO  01-08 14:12:17,040 - fields - fields
INFO  01-08 14:25:04,357 - fields - Dispatching started for transformation [fields]
ERROR 01-08 14:25:04,367 - Get Variables - Unexpected error
ERROR 01-08 14:25:04,371 - Get Variables - org.pentaho.di.core.exception.KettleValueException: 
Unexpected conversion error while converting value [cid String(6)] to an Integer

cid String(6) : couldn't convert String to Integer
Unparseable number: "${cid}"


        at org.pentaho.di.core.row.ValueMeta.getInteger(ValueMeta.java:1523)
        at org.pentaho.di.core.row.ValueMeta.convertData(ValueMeta.java:3070)
        at org.pentaho.di.trans.steps.getvariable.GetVariable.processRow(GetVariable.java:114)
        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
        at java.lang.Thread.run(Thread.java:722)
Caused by: org.pentaho.di.core.exception.KettleValueException: 
cid String(6) : couldn't convert String to Integer
Unparseable number: "${cid}"


        at org.pentaho.di.core.row.ValueMeta.convertStringToInteger(ValueMeta.java:912)
        at org.pentaho.di.core.row.ValueMeta.getInteger(ValueMeta.java:1476)
        ... 4 more
Caused by: java.text.ParseException: Unparseable number: "${cid}"
        at java.text.NumberFormat.parse(NumberFormat.java:350)
        at org.pentaho.di.core.row.ValueMeta.convertStringToInteger(ValueMeta.java:908)
        ... 5 more

INFO  01-08 14:25:04,371 - Get Variables - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
INFO  01-08 14:25:04,372 - fields - fields
INFO  01-08 14:25:04,372 - fields - fields
ERROR 01-08 14:25:04,417 - Table input - Unexpected error
ERROR 01-08 14:25:04,418 - Table input - org.pentaho.di.core.exception.KettleException: 
Expected to read parameters from step [Get Variables] but none were found.

        at org.pentaho.di.trans.steps.tableinput.TableInput.readStartDate(TableInput.java:85)
        at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:122)
        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
        at java.lang.Thread.run(Thread.java:722)

INFO  01-08 14:25:04,418 - Table input - Finished reading query, closing connection.
INFO  01-08 14:25:04,423 - Table input - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
INFO  01-08 14:25:04,493 - fields - fields
INFO  01-08 14:25:04,493 - fields - fields

cid String(6) : couldn't convert String to Integer
Unparseable number: "${cid}"

seems to be the problem, but erhm , it really is a Integer.

Any help is much appreciated.

With kind regards, Rogier