SAP Knowledge Base Article - Public

3608210 - "OUTPUT is not bound" error in open SQL Procedures in a Datasphere Task Chain

Symptom

In Datasphere, running open SQL Procedure in a Task Chain fails with following error:

wrong number or types of parameters in call: "xxxxxx"."xxxx": line xxx col x (at pos xxxx): OUTPUT is not bound: line x col x (at pos x) 

If running the same open SQL Procedure manually in HANA Cloud DB, then it can be run successfully without error.

Environment

  • SAP Datasphere

Reproducing the Issue

  1. Run a Task Chain that contains the open SQL Procedure.
  2. Check the log, confirm the execution fails with error:
    wrong number or types of parameters in call: "xxxxxx"."xxxx": line xxx col x (at pos xxxx): OUTPUT is not bound: line x col x (at pos x) 

Cause

The open SQL Procedure has a OUTPUT parameter, manual execution in HANA Cloud DB is allowed. However in the Task Chain, only the INPUT parameters can be manually set, the OUTPUT parameters cannot be configured. The execution of open SQL procedures with OUTPUT parameters in Task Chain is currently not supported. 

Resolution

Replace the open SQL Procedures with the one that does not contain OUTPUT parameters, and then use it in Task Chain. 

See Also

Run Open SQL Procedures in a Task Chain

Keywords

DS; SQL script , KBA , DS-DI-SCH , Scheduling and Task Chains , Problem

Product

SAP Datasphere all versions