qlikview qvd error

[#1]

Dear all;

i have a trouble with qlikview. i am trying to create qvd file from tables but some tables get an error.

WH_ACTIVITY:

SQL SELECT *

FROM SEAMDB.WH_ACTIVITY;

STORE WH_ACTIVITY INTO WH_ACTIVITY.qvd(qvd);

DROP TABLE WH_ACTIVITY;

is working and qvd is created but

WH_ASSESSMENT:

SQL SELECT *

FROM SEAMDB.WH_ASSESSMENT;

STORE WH_ASSESSMENT INTO WH_ASSESSMENT.qvd(qvd);

DROP TABLE WH_ASSESSMENT;

is not created.

Did i do wrong sth?

Thanks for your replies.

yeşim

[lironbaram]

hei

the error is not in the creation of the qvd

the error is in the load data for the seconed table

read the error masege

[rajtechnocraft]

please check you path setting in qlikview script whether it is set to absolute or relative.

Otherwise there is no problem in your script.

[#4]

Hi hımm,

How can I solve it?

[kaushiknsolanki]

HI,

   Try to load it first and check if its loaded properly or not.

   Meaning comment the code for creating QVD.

   Like this.

WH_ASSESSMENT:

SQL SELECT *

FROM SEAMDB.WH_ASSESSMENT;

//STORE WH_ASSESSMENT INTO WH_ASSESSMENT.qvd(qvd);

//DROP TABLE WH_ASSESSMENT;

Regards,

Kaushik Solanki

[#6]

Hey

I tried but again the same error.

[kaushiknsolanki]

HI,

   Then its not a qlikview error, its an error from your database.

   Make sure that you are using the proper table name which is there in your database.

Regards,

Kaushik Solanki