topic Re: Execute a Stored Procedure in Qlik Sense in Connectivity & Data Prep

Execute a Stored Procedure in Qlik Sense

joaopaulo_delco — Tue, 30 Apr 2019 18:18:43 GMT

Hello

After I update Qlik Sense to Feb/2019 version, a problema began to occur in my script that execute a oracle stored procedure.

My Script is:

LIB CONNECT TO 'Oracle MDLog (qliksense_administrador)';

SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"}; // the follow erros appears here

QVX_UNEXPECTED_END_OF_DATA: Unable to get column information for the fields that are used in the query: Referência de objeto não definida para uma instância de um objeto.: SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"}

Can someone help me?

On nov/2018 version was working well.

Re: Execute a Stored Procedure in Qlik Sense

dplr-rn — Tue, 30 Apr 2019 18:50:48 GMT

Did you enable legacy mode?

check below

If you want to use Execute the following conditions need to be met:
You must run in legacy mode (applicable for Qlik Sense and Qlik Sense Desktop).
You need to set OverrideScriptSecurity to 1 in Settings.ini (applicable for Qlik Sense).
Settings.ini is located in C:\ProgramData\Qlik\Sense\Engine\ and is generally an empty file.

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Execute.htm

Re: Execute a Stored Procedure in Qlik Sense

joaopaulo_delco — Tue, 30 Apr 2019 20:25:52 GMT

I enable to legacy mode and set de Settings.ini to OverrideScriptSecurity. Also restart de Qlik Sense Engine Service but not solve the problem. The same error occurs.

This is the content of my Settings.ini file:

[Settings 7]
OverrideScriptSecurity=1

Re: Execute a Stored Procedure in Qlik Sense

joaopaulo_delco — Thu, 02 May 2019 12:09:43 GMT

I was using a direct Oracle connection.

I changed the connection to OLE DB and the problem was solved.