3769884 - Open SQL schema procedure not visible in Task Chain due to unsupported parameter type

• An SQL procedure is created in an Open SQL Schema and the required privileges are granted to the space as described in the SAP Help documentation.
• The procedure does not appear when modelling a Task Chain.
• The following error message is displayed:

No procedures have been created or the EXECUTE privilege has not been granted to the Open SQL schema.

SAP Datasphere

Task Chain has restrictions on the parameter types supported for SQL script procedures. If a procedure contains unsupported input parameter types (e.g., NCLOB), the system silently it from the Task Chain procedure list.

1. Confirm that the EXECUTE privilege has been granted to the space as described in Allow the Space to Access the Open SQL Schema. If privileges are correctly configured and the procedure is still not visible, proceed to the next step.
2. Review the procedure definition and check whether any input parameters use types not supported by Task Chain. Refer to the supported types listed in Run Open SQL Procedures in a Task Chain. For example: NCLOB.
3. Modify the procedure definition and replace any unsupported parameter types with supported ones.

• SAP Help: Run Open SQL Procedures in a Task Chain
• SAP Help: Allow the Space to Access the Open SQL Schema

Task Chain, Open SQL Schema, procedure not visible, procedure not showing, EXECUTE privilege, privilege not granted, NCLOB, unsupported parameter type, SQL script procedure , KBA , DS-DI-SCH , Scheduling and Task Chains , Problem