Pentaho

 View Only

 Parameters are not passed to sub tranformation in pentaho 9.3

Jump to Best Answer
Lex van Rossum's profile image
Lex van Rossum posted 02-06-2023 04:32

Hello,

Within one job I use a parameter with a static input value that is passed to sub tranformation. The parameter is set to 1 for transformation number 1 and 2 for 2, until 5 for number 5. In the ktr I use the parameter in the where clause of a query.

This works good in pentaho 9.1. Now I want to switch to pentaho 9.3 (Long time support) but the tranformations fail sometimes (feels like the lottery).

Anybody an idea? any pointers?

Thanks in advanced!
Lex

Attachment  View in library
pentaho_parameter.png 81 KB
Stephen Donovan's profile image
Stephen Donovan posted 02-07-2023 13:20 Best Answer

If you are running in parrallel, you may have hit a caching issue with the parameter.

"MetaFileLoaderCache causes Incorrect Behavior/Results with Parallel Execution"

This is fixed in 9.4 (EE and CE) and in 9.3.0.1+ (EE).

Related Content