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
- Run a Task Chain that contains the open SQL Procedure.
- 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
Keywords
DS; SQL script , KBA , DS-DI-SCH , Scheduling and Task Chains , Problem