'Table Not Found' error while executing SP in qlikview

[rsdhavle]

I am trying to get data from SP into QVD. When i execute SP and give command to store data into qvd, i keep on getting error 'Table not found'. Is it because we have temp tables in SP? What is the reason? Are there any limitations of using Stored Procedures into Qlikview?

[simospa]

In which point o your script do you get the error?

Use exit script to understand it.

It's important to know if the error is in STORE instruction or in SP call.

S.

[simospa]

"Table not found" happens when you try to store an entity (table) into a .qvd

For example

Customer:

select * from tab_customers;

store Customers into c.qvd;

In this case you get "Table not found" because the QV table is named "Customer" not "Customers".

If the table tab_customers doesn't exist, you get another type of error like "object name tab_customers is not valid" (I've Italian version, maybe lightly different)

S.

[rsdhavle]

Yes to check this i simply ran SQL SP to check if fields are appearing. This time the SQP got executed but it dint return any data in Qlikview however when i run this SP in SQL it is giving data.

Thats why i wanted to know if temp tables used in SQL are causing this issue or there is some other reason for this error

[rsdhavle]

After executing SP in QVW it does not return any data however its does return data when we run it in database

[#6]

Rohan, Did you solved this problem? If so can you please post the solution

[rsdhavle]

Hi Srinivas, Just add SET NOCOUNT ON in your SP.

It solved the problem for me