Adding a numerical value to a validation_transform rule with quotes will cause the job to fail, removing the quotes and then running the job for a second time will work.
The exact opposite is also seen:
Adding a numerical value to a validation_transform rule without quotes will cause the job to fail, adding the quotes and then running the job for a second time will work.
RES-020109: |SESSION AA_REP_VALIDATION_TRANSFORM|DATAFLOW New_DataFlow11|STATEMENT <GUID::'c7a0c994-bbac-4b16-9b86-eff2ab37f761' TRANSFORM Validation OUTPUT(Validation_Pass, Validation_Fail, Validation_RuleViolation)> Identifier <2> is unrecognized. Check its spelling and usage. If it is a variable, it needs a preceding '$'; if a constant, it must be quoted; if a column, verify that such a column exists in a table.
The usage of quotes "" is inconsistent within the validation_transform
SAP Data Services 184.108.40.20621
XRN-130263 , , KBA , EIM-DS-EXE , Job Execution , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.