SAP Knowledge Base Article - Preview

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


Read more...

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.