topic Re: SP not giving data in QlikView

SP not giving data

Fri, 26 Sep 2014 14:06:45 GMT

Hi All,

I am getting data from SQL using store procedure, and it is not giving any data to my table T. But when I execute in SQL it has values. Any Idea?

Thanks.

T:
LOAD *;
SQL execute DBANME.dbo.sp_name;

Re: SP not giving data

Fri, 26 Sep 2014 14:58:27 GMT

You need a semicolon at the end of the A,B,C line, and SQL line

Costs:

Load A, B, C ;

sql exec ABC_CostQlikView ;

You also need to enable "Open database in read write mode" in the connection settings if using stored procedures.

Re: SP not giving data

fkeuroglian — Fri, 26 Sep 2014 15:18:17 GMT

Hi, connect ok? no give any data?

pherhaps some grant permission to your use

1) Use Sql Exec dbo.sp_RUNScoreEncountersINPATIENT instead of sql execute

2)try this

GRANT EXEC ON dbo.xxxxxxx TO<UserName> ?

see this links

How to Call stored procedure in Qlikview

Executing a stored procedure

SQL Stored Procedure into QlikView

Re: SP not giving data

Fri, 26 Sep 2014 15:56:51 GMT

Hi Fernando,

Able to connect database.

Tired with EXEC instead EXECUTE, no error message and no data getting back.

My DB connection user id has admin privileges, I hope there is no security issue.

And my SP contains complex logic. But I can execute in SQL side and it is retuning data in SQL database.

Any idea?

Thanks.

Re: SP not giving data

Fri, 26 Sep 2014 16:39:34 GMT

Hi Shravan,

Yes, I tried with that as well.

Re: SP not giving data

Fri, 26 Sep 2014 16:45:39 GMT

I have another simple SP that is giving me the data to QV. But complex one not giving any data...

Re: SP not giving data

Fri, 26 Sep 2014 16:47:39 GMT

Hi,

Did you able to load normal SQL table data directly irrespective of stored procedure?

Re: SP not giving data

Mon, 29 Sep 2014 08:18:48 GMT

Hi Kuruthi,

Yes, I am able to load normal table, even I am able to load simple SP.

This scenario my SP contains very complecated logic. Not sure why it is not bringing data to QV.

Any idea?

Thanks.

Re: SP not giving data

Thu, 02 Jun 2016 13:50:13 GMT

Hi Kumar,

Thanks for your post!!.

I am facing same issue but that too for a simple table.

I am getting Oracle stored procedure data into QlikView. I have posted the issue in forum at QlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracle table

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary