topic 'Table Not Found' error while executing SP in qlikview in QlikView

'Table Not Found' error while executing SP in qlikview

rsdhavle — Thu, 05 Jun 2014 09:18:56 GMT

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?

Re: 'Table Not Found' error while executing SP in qlikview

simospa — Thu, 05 Jun 2014 09:44:43 GMT

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.

Re: 'Table Not Found' error while executing SP in qlikview

simospa — Thu, 05 Jun 2014 09:52:51 GMT

"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)

Re: 'Table Not Found' error while executing SP in qlikview

rsdhavle — Thu, 05 Jun 2014 10:14:21 GMT

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

Re: 'Table Not Found' error while executing SP in qlikview

rsdhavle — Thu, 05 Jun 2014 11:52:30 GMT

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

Re: 'Table Not Found' error while executing SP in qlikview

Wed, 15 Oct 2014 14:52:19 GMT

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

Re: 'Table Not Found' error while executing SP in qlikview

rsdhavle — Thu, 16 Oct 2014 12:34:08 GMT

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

It solved the problem for me