Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Regarding error message while loading stored procedures into Qlik Sense

Hi Team,

I am unable to load stored procedures into Qlik Sense.

I am using the following code.

LIB CONNECT TO 'Server name';

load *;

sql  exec [Procedure_Name]  ;


When I execute this code, I am receiving the following error saying that the metadata column could not be determined as the SQL Statement uses a temp table.


ERROR [HY000] [Qlik][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The metadata could not be determined

Any help will be much appreciated.

Thanks and regards,

Ashwin

2 Replies
phaneendra_kunc
Valued Contributor III

Re: Regarding error message while loading stored procedures into Qlik Sense

did you open database in read & write mode? I know this is qlikview, but i want you to try creating connection string as stated in below link and use that string in Qlik sense and see.

Stored Procedure Connection In QlikView Application

Not applicable

Re: Regarding error message while loading stored procedures into Qlik Sense

Hi Phaneendra,

I am able to connect now. I was using Qlik ODBC connector package. When I changed this to an OLEDB connection,it rectified the error. However the stored procedure does not return any rows nor does it prompt me for any parameters

This is the code that I am using.

LIB CONNECT TO 'Server_name';

  load *;

    sql  exec [Procedure_Name] '$(@ParameterName1)','$(@ParameterName2) ';

Please help me regarding this.

Regards,

Ashwin