CODEWITHSUNDEEP
pentahokettlepentaho-spoon
Julien
Julien

Reputation: 2756

Any idea about this weird type error in Pentaho Data Integration?

I have this :

Insertion des données dans table some_table.0 - SOME_AUTO_GENERATED_DB_KEY Integer : There was a data type error: the data type of java.lang.Boolean object [true] does not correspond to value meta [Integer]

What boolean??? Where do you see a boolean? I have added a trace writing to the step just before this failing inserting step, and I see a perfectly fine integer as value of SOME_AUTO_GENERATED_DB_KEY .

How can this be possible? I am very new to Kettle, if you have any idea or tips it would be awesome.

Here a screenshot of the transformation :

Transformation

Upvotes: 1

Views: 3369

Answers (1)

Ken Clubok
Ken Clubok

Reputation: 1238

Just before the failed insert, you have a filter that splits the stream. On one half of the stream, it looks like you have an Add Constant step. If I'm reading this right, then the two inputs to the Insert step don't have the same fields in the same order. A few steps earlier, there is a similar splitting of the paths that goes off to the right, which could have the same effect.

Whenever you remerge streams like this without being very careful, strange errors like this can pop up. Pentaho usually tries to warn you when you create the hop to remerge the streams, but there are ways to miss that warning.

Suggestion: For each time the stream remerges, right-click on each of the two previous steps, and have it show you the output fields. Compare the two lists side-by-side to verify they are the same. If not, then you will have to add or remove fields as appropriate to make them the same on both sides.

Upvotes: 3

Related Questions