Reload not completed

[krishna20]

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

[avinashelite · Accepted solution]

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

[krishna20]

Hi Avinash,

Thank you for your quick reply.

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

[avinashelite]

how much data you have ??

Please share the script

[krishna20]

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

[giakoum]

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?

[krishna20]

Hi giakoum

No Error Message in log file..

[giakoum]

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

[krishna20]

Reload Executing window is not closing.

[avinashelite]

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