topic Re: SP doesn't return data in QlikView

SP doesn't return data

rsdhavle — Thu, 05 Jun 2014 12:52:44 GMT

We are calling one SP which contains below steps:

Creates a table
Loads data into the table
Selects all records from the same table

When i am trying to get data from this SP into Qlikview document it doesn't return any rows however SP executes successfully in database. I am using SQL server

Qlikview does not show a single field after execution is completed.

Re: SP doesn't return data

alexandros17 — Thu, 05 Jun 2014 12:53:21 GMT

Check the syntax

Re: SP doesn't return data

rsdhavle — Thu, 05 Jun 2014 12:54:39 GMT

Syntax is correct. When i run other SP only with Select statement Qlikview is showing data

Re: SP doesn't return data

its_anandrjs — Thu, 05 Jun 2014 12:58:19 GMT

What syntax you use can you publish to check and once check it may be in some line there is error in the syntax.

Re: SP doesn't return data

Anonymous — Thu, 05 Jun 2014 13:39:31 GMT

I am doing the same thing for loading access of users :

Visibilite:

LOAD

IDSALARIE, keyVisibilite;

SQL execute QVW_get_salaries_vcc $(vIdClient);

Re: SP doesn't return data

jaimeaguilar — Thu, 05 Jun 2014 15:16:08 GMT

Hi,

have you checked that the format of what it's in vIdClient is the same in QlikView and in your Database?

regards

Re: SP doesn't return data

Anonymous — Mon, 02 Feb 2015 09:58:32 GMT

Hi,
I also tried executing Stored procedures containing Link to other SQL server and it dint work, but I found solution for this problem, We have to create 2 Stored procedures to make this thing work and below are the steps
1. Create Table in in Actual DB to hold values from Linked server.
2. Create first Stored procedures to insert data from Linked server to actual DB
3. Create Stored procedures to fetch data from Table of Actual DB
Then execute both the stored procedures sequentially in QlikView to get the result.
Since QliKView can't read data from Stored procedures having Link to other server, This might work.

Re: SP doesn't return data

Anonymous — Tue, 03 Mar 2015 05:43:56 GMT

Hi,

Since you are using creating table in SP and processing data from that, you should use ODBC connection in QliK View script and open the conneciton in Write mode as below.

ex.:ODBC CONNECT TO [DB](Mode is write)