topic Re: Reload process not completing in QlikView

Reload process not completing

Thu, 13 Nov 2014 12:09:43 GMT

Could anybody help me with as to why my load is not ending. There's no error but at the end of the load, the script execution progress window doesn't close and the 'close' button is frozen.

However, when I debug it, it reloads just fine.

I faced similar issue earlier but that was due to synthetic keys, this time I checked.. there are none. Any clue, what could be going wrong?

Re: Reload process not completing

Thu, 13 Nov 2014 12:11:52 GMT

has controlado que no se generen referencias circulares con la última modificación en el script?

Re: Reload process not completing

vardhancse — Thu, 13 Nov 2014 12:15:51 GMT

it might be because of low memory on the system and large amount of data loading in the dashboard.

Re: Reload process not completing

agomes1971 — Thu, 13 Nov 2014 12:21:01 GMT

Hi,

i think really, memory is the issue...

how many rows are trying to upload?

Regards

André Gomes

Re: Reload process not completing

Thu, 13 Nov 2014 12:26:08 GMT

is there a way to confirm this?

Re: Reload process not completing

agomes1971 — Thu, 13 Nov 2014 12:39:26 GMT

Hi,

the data is from sql?

Then do a select coun(*) from yourtable

with your where clauses..

If it is excel

go to last row

Hope it helps

André Gomes

Re: Reload process not completing

sujeetsingh — Thu, 13 Nov 2014 12:41:28 GMT

Chech for circular loop, or lot of syn keys getting generated.

Some times a lot of data and less hardware configuration too results in such issues.

Re: Reload process not completing

Thu, 13 Nov 2014 13:13:11 GMT

memory was the issue. data was being added to my qvd file which went unnoticed. the file size had become around 230 GB!