SAP datasphere task chain: sql procedure not visible

[severilar]

I've created an SQL procedure in my Open SQL Schema of SPACE  "SAP_ADMIN.

I'd like to run this procedure in a Task Chain in SAP DSP, in the SPACE_ID = SAP_ADMIN. I'm following this: Run Open SQL Procedures in a Task Chain | SAP Help Portal 

However, even after assigning the privileges to the space as described here: Allow the Space to Access the Open SQL Schema | SAP Help Portal , I'm not able to see the SQL procedure in during Task Chain modelling.

The error showed is: No procedures have been created or the EXECUTE privilege has not been granted to the Open SQL schema. 

Could you please investigate?

[Charls]

Hello Severilar,

If you want to add some procedure in Task Chain,  Please ensure that there are no parameters in the procedure or that the following parameter types are used：

• "NCHAR", "STRING", "NVARCHAR", "ALPHANUM", "SHORTTEXT", "INT", "TINYINT", "BIGINT", "CHAR", "DECIMAL", "SMALLDECIMAL", "INTEGER", "SMALLINT", "REAL", "DOUBLE", "FLOAT", "VARCHAR", "BOOLEAN", "DATE", "TIME", "SECONDDATE", "TIMESTAMP"

[Shuuka]

There are some points can be check.

1. Re-check the privilege assignment

2. Create a minimal test procedure to narrow down the scope

To determine whether this is a privilege issue or something specific to the procedure definition, can have a quick test:

• Create a very simple test procedure in the same Open SQL schema (for example, without referencing other tables or objects).
• Check whether this test procedure becomes visible during Task Chain modeling.

If the test procedure is visible, this usually indicates that the space-to-schema access and EXECUTE privilege are generally working, and the issue may be related to the original procedure’s definition or its dependent objects.

If the test procedure is not visible, this strongly points to a remaining authorization or execution-identity issue.

[severilar]

Thanks Shuuka for your answer. As Charles clearly explained above, you can execute in TC SQL Procedure with specific Input Paramters type o none. In my case, I was trying to use as IP a CLOB type but I was able to create and execute the procedure in the Open SQL Schema. But, I was not able to see it in DSP TC without any error message.