topic Re: Reload not completed in QlikView

Reload not completed

krishna20 — Tue, 16 Jun 2015 11:48:56 GMT

Hi Folks,

I'm facing a strange problem. I'm connecting to database 'XXXXX' with ODBC string.

Selecting table and stores into QVD. When i'm reloading the app reload not getting finished.But i can see the QVD at my folder.

I checked with generating a log file. No issues i have seen here. Please anyone can tell what may be the problem is?

Regards

Krishna

Re: Reload not completed

avinashelite — Tue, 16 Jun 2015 11:54:44 GMT

Hi Krishna,

I think once the data is fetched it is trying to associate the data,if you have more table and if you a have columns with common names and then surely that will be the issue. In Qlikview we should have one-to-one key relation with the tables.

If your just using to create QVD's then as an when you store it has qvd , please delete the respective table so that un-necessary association will be avoided or have unique name for all the columns

Re: Reload not completed

krishna20 — Tue, 16 Jun 2015 11:58:04 GMT

Hi Avinash,

Thank you for your quick reply.

If i'm taking only two tables also reload not completing.

Re: Reload not completed

avinashelite — Tue, 16 Jun 2015 12:00:29 GMT

how much data you have ??

Please share the script

Re: Reload not completed

krishna20 — Tue, 16 Jun 2015 12:05:33 GMT

Hi Avinash,

Here is the script.

ALL_PEOPLE_D:

LOAD *;

SQL SELECT *

FROM APPS."PER_ALL_PEOPLE_D";

STORE ALL_PEOPLE_D INTO $(vPath)PER_ALL_PEOPLE_D.qvd(qvd);

ALL_PEOPLE_F_DFV:

LOAD *;

SQL SELECT *

FROM APPS."PER_ALL_PEOPLE_F_DFV";

STORE ALL_PEOPLE_F_DFV INTO $(vPath)PER_ALL_PEOPLE_F_DFV.qvd(qvd);

Regards

Krishna

Re: Reload not completed

giakoum — Tue, 16 Jun 2015 12:06:28 GMT

Does the log file indicate "execution finished" ?

Must be one of the last lines in the log.

If yes, then maybe the distribution is failing, not the reload. Is it on a server or desktop?

Do you get the "Load old data" prompt? What makes you believe it fails? Error message?

Re: Reload not completed

krishna20 — Tue, 16 Jun 2015 12:15:32 GMT

Hi giakoum

No Error Message in log file..

Re: Reload not completed

giakoum — Tue, 16 Jun 2015 12:16:16 GMT

then what makes you think it fails? Please attach the reload log if possible and please answer my questions above.

Re: Reload not completed

krishna20 — Tue, 16 Jun 2015 12:17:46 GMT

Reload Executing window is not closing.

Re: Reload not completed

avinashelite — Tue, 16 Jun 2015 12:20:24 GMT

Its the common column names issue, instead of LOAD * please try to have the columns names so that it will be help full for you to know where the columns have getting linked.

If your using this load only to generate QVD's then try like this

ALL_PEOPLE_D:

LOAD *;

SQL SELECT *

FROM APPS."PER_ALL_PEOPLE_D";

STORE ALL_PEOPLE_D INTO $(vPath)PER_ALL_PEOPLE_D.qvd(qvd);

Drop table ALL_PEOPLE_D;

ALL_PEOPLE_F_DFV:

LOAD *;

SQL SELECT *

FROM APPS."PER_ALL_PEOPLE_F_DFV";

STORE ALL_PEOPLE_F_DFV INTO $(vPath)PER_ALL_PEOPLE_F_DFV.qvd(qvd);

Drop table ALL_PEOPLE_F_DFV;

this solve the issue

Re: Reload not completed

giakoum — Tue, 16 Jun 2015 12:20:29 GMT

then most likely it is your data model.

You are using select * and my guess is that the 2 queries have common field names which create huge synthetic keys. Try dropping the tables after storing to qvd to avoid synthetic keys.

Re: Reload not completed

awhitfield — Tue, 16 Jun 2015 12:51:55 GMT

This may be a daft question and a Red Herring, but have you got this:

Unchecked in users preferences General?

Andy