I have a client who is presenting a case when the execution of stored procedures is carried out in Qlik Sense Client Managed May 2023 patch 3.
They have SAP HANA as a source, when the data extraction is performed by SELECT queries there are no problems.
The execution of the stored procedure was tested, for this there are two cases of stored procedures: The first case, the stored procedure after performing data transformations returns a table as a result. This execution is successful in Qlik sense. An example is SQL CALL scheme.stored _procedure1('HVF-325') which returns import information by filtering by product HVF-325.
The second case, the storedprocedure creates temporary tables based on a second query, for example: In SAP HANA Studio they execute CALL scheme.stored _procedure2('20230601','20230630'); SELECT * FROM scheme.Table1; This results in a Table1 table filtered by date range. If only the stored procedure is executed in SAP HANA Studio, it indicates success, so a SELECT from another table must be placed to obtain the table with data as a result. In Qlik Sense when executing SQL CALL scheme.stored _procedure2('20230601','20230630'); SELECT * FROM scheme.Table1; It stays running indefinitely for more than 10 min.
How can this stored procedure be executed in Qlik Sense?
