topic stored procedure - table not found in QlikView

stored procedure - table not found

Wed, 11 Nov 2009 23:37:50 GMT

sales:
SQL Execute QLIKVIEW_SALES_DATA;
store sales into h:\clickview\sales.qvd;

After I make a database connection and execute the above code I get a table sales not found error

Table not found

store sales into h:\clickview\sales.qvd;

the user has execute access on the sproc and I have checked the Open databases read and write mode

If I use the code from the sproc in a select then it loads the data into the qvd with no problems

What am I missing

stored procedure - table not found

Wed, 11 Nov 2009 23:55:05 GMT

Maybe like this

sales:

load a,b,c ;
SQL Execute QLIKVIEW_SALES_DATA;
store sales into h:\clickview\sales.qvd;

where a,b,c are the fields on the table or store proc

Talha

stored procedure - table not found

Thu, 12 Nov 2009 01:30:02 GMT

The script says that the load cannot find the field <SoldTo#> eventhough I did a copy / paste from the store procedure

🙂

Kevin

stored procedure - table not found

Thu, 12 Nov 2009 01:58:49 GMT

As previous reply I have tried uppercase, lowercase letters for the fields or aliases

😞

Kevin

stored procedure - table not found

GabrielAraya — Thu, 12 Nov 2009 02:04:55 GMT

Hi ... I don't know if you test writing a Sleep statement between the SQL and Store instractions ...

SQL ........;

Sleep 10000;

Store .....

GAG

stored procedure - table not found

Thu, 12 Nov 2009 03:24:28 GMT

I am not sure, but if you execute the stored proc in your dbms editor, is it working ?

IF yes, maybe the error is coming because when you connect on your server in qlikview you are not connected to the correct database (or owner, or schema, depending on the dabase ?) ?

Maybe you should have the correct default database or owner connection in your stored procedure or in the user specified for qlikview connection ?

What I can say is that stored procedures work fine, i already tested them.

Rgds,

Sébastien

stored procedure - table not found

Thu, 12 Nov 2009 03:50:20 GMT

I can connect to stored procedure correctly and I can retreive data if I store result set in a staging table. However I would prefer to load a,b,c ; fields into a qvd file.

also I always get error that cannot field when loading from qvd file

thanks

Kevin