Skip to main content
Solved

Mapping Expression as Parameter yields Model is not valid when executed from Workflow


Forum|alt.badge.img
  • Universe Traveller
  • 2 replies

If I create a component with a step that maps an expression as a parameter, and call that component from a workflow, I get a “Model is not valid” exception. The attached provides a minimal example of this behavior. The component, param_test.comp, uses a random record generator with a single column, the expression of which is mapped to a parameter named “param.” The parameter value is set to “param_value.” The workflow, param_test.ewf, calls the component, passing the parameter, “param,” with value “param_value.”

If the component is executed in isolation, execution completes successfully. If the component is executed from the workflow, the below error message is printed and execution halts. Is this a supported scenario? If not, how can I map a parameter value to a column within a component that is called from a workflow?

25.03.2024 01:20:25 [INFO]     Processor started
25.03.2024 01:20:26 [INFO]     Task 'Run DQC' : IN_QUEUE
25.03.2024 01:20:26 [INFO]     Task 'Run DQC' : RUNNING
25.03.2024 01:20:26 [INFO]     Task 'Run DQC' : failed with exception: Model is not valid.
com.ataccama.adt.internal.core.runtime.EwfRuntimeException: Model is not valid.
	at com.ataccama.adt.task.exec.EwfDqcTask$EwfDqcTaskExecutableInstance.run(EwfDqcTask.java:196)
	at com.ataccama.adt.internal.core.runtime.EwfTaskProcessor$ThreadSlot.run(EwfTaskProcessor.java:371)
25.03.2024 01:20:26 [INFO]     --- Stop initiated ---
25.03.2024 01:20:26 [INFO]     --- Stop done : processor stopped with status : FINISHED_FAILURE---

 

Best answer by AKislyakov

Hi @jbrant 

 

Try putting it like “’param_value’”
The catch here is that Expression in the workflow step should evaluate to a valid expression in DQC plan.

When you put it like ‘param_value’, workflow evaluates it and pass the result (param_value) to the plan.
Then, the plan tries to start with expression param_value, which obviously is not valid, as there no such column or function.
 

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+2
  • Ataccamer
  • 158 replies
  • Answer
  • March 25, 2024

Hi @jbrant 

 

Try putting it like “’param_value’”
The catch here is that Expression in the workflow step should evaluate to a valid expression in DQC plan.

When you put it like ‘param_value’, workflow evaluates it and pass the result (param_value) to the plan.
Then, the plan tries to start with expression param_value, which obviously is not valid, as there no such column or function.
 

 


Forum|alt.badge.img
  • Author
  • Universe Traveller
  • 2 replies
  • March 25, 2024

Thank you, that fixed the problem I was having.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings