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 220.127.116.1121
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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.