topic Re: qlikview qvd error in QlikView

qlikview qvd error

Thu, 28 Jul 2011 06:47:30 GMT

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

qlikview qvd error

lironbaram — Thu, 28 Jul 2011 06:50:07 GMT

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

qlikview qvd error

rajtechnocraft — Thu, 28 Jul 2011 06:52:00 GMT

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

Otherwise there is no problem in your script.

Re: qlikview qvd error

Thu, 28 Jul 2011 06:56:08 GMT

Hi hımm,

How can I solve it?

Re: qlikview qvd error

kaushiknsolanki — Thu, 28 Jul 2011 07:06:07 GMT

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

Re: qlikview qvd error

Thu, 28 Jul 2011 07:14:10 GMT

Hey

I tried but again the same error.

Re: qlikview qvd error

kaushiknsolanki — Thu, 28 Jul 2011 07:15:57 GMT

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