...
Files Changed:
metadata\core\ontology\templates\eagle_wrhs_warehouseposition_reinitbatch.oracle
SDP-86196
...
A new object called getvariable has been implemented to support dynamic expression calculation for variables.
Dynamic expression calculation means the presence of two execution steps, as opposed to the traditional single execution step seen with a *variable*, where the expression can be only static.
For example:
[
"getvariable",
"extUSER_CHAR",
"iif(stringlength(get_instruction_param('USER_CHAR', :GVAR_RTR: )>0,get_instruction_param('USER_CHAR', :GVAR_RTR: ,'')"
],
In this case there will be two executions (calculations):
# The first Execution will calculate the expression (iif(stringlength(get_instruction_param('USER_CHAR', :GVAR_RTR: )>0,get_instruction_param('USER_CHAR', :GVAR_RTR: ,'')). In our example, the result of this expression is *|57|;*
# The second Execution will use the result of the 1st execution in the expression for the second execution. In this scenario, the value will be taken from column 57 of the incoming CSV file.
This variable then can be used in the mapping as typical variable:
[
":extUSER_CHAR:",
"",
false,
null,
"",
"accountingTrade/userChar5"
],
In the resulting file, the expectation is to find the value from column 57 in the element {{accountingTrade/userChar5}}.
It works the same way if the variable is defined with *static* expression:
[
"variable",
"extUSER_CHAR",
"|57|"
],
...
Information in data load error is not sufficient to triage issue
Logic for reporting error messages to the end users was improved to inherit global parameter for length, also this value can be adjusted via RTR parameter: procstatusmsgsize. The Default size is set to 300.
For troubleshooting purposes you can increase value to get more details via error message, but please be aware that too long error messages can cause unexpected behavior.
If the error has a line number, then the error message will have text from this line for troubleshooting purposes.
Files changed:
common-core/descriptor/dbdescriptor.py
common-core/processing-env/proc_log_stru.py
common-core/processing-env/processing_context.py
common-core/processing-env/processing_log.py
common-core/processing-env/proc_log_policy.py
SDP-85755 Cloud workflow eagle_wrf_cloud_extract was updated
...