SP not giving data

[#1]

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;

[#2]

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.

[fkeuroglian]

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

or

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

[#4]

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.

[#5]

Hi Shravan,

Yes, I tried with that as well.

[#6]

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

[#7]

Hi,

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

[#8]

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.

[#9]

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 oracl...

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

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary