3032039 - Identifier <> is unrecognized. Check its spelling and usage. If it is a variable, it needs a preceding '$' - SAP Data Services 14.2.13.2621

Symptom

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

Environment

SAP Data Services 14.2.13.2621

Product

SAP Data Services 4.2

Keywords

XRN-130263 , , KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This 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.