SAP Knowledge Base Article - Preview

1726964 - Error with rule using $parameter in SQL() function - Information Steward Data Insight

Symptom

  • Writing rule with parameter in SQL() function
  • Oracle ERROR: (E) (9331:970945616) RES-020107: |SESSION JOB_Rule_NP_25_1|DATAFLOW DF_Rule_NP_25_1|STATEMENT <GUID::... TRANSFORM Validation OUTPUT(Validation_Pass, Validation_Fail)>  Referencing undeclared variable <$parameter>. Declare the variable in the context it is being used in.
  • SQL ERROR: [SQL Server]Invalid pseudocolumn "$parameter0".>. (14.0) 05-31-12 14:36:00 (E) (9280:9256) RUN-050304: |Data flow DF_TEST_RULE_4|Transform Query2|Function TEST SQL PARAMETER_Local Function call <sql ( ICCDS_31, select customer.cust_alias_s  from dbo.customer where cust_status_s=<$parameter> ) > failed, due to error <70401>: <ODBC data source <ATLN00495832A\SQLEXPRESS> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid pseudocolumn "$parameter".>.>.


Read more...

Environment

Information Steward

Product

SAP Information Steward all versions

Keywords

IS, scripting language, variable , KBA , EIM-IS , Information Steward , 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.