stored procedure - table not found

[#1]

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

K

[#2]

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

[#3]

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

🙂

Kevin

[#4]

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

😞

Kevin

[GabrielAraya]

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

SQL ........;

Sleep 10000;

Store .....


GAG

[#6]

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

[#7]

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