stuck with data load 750M rows with mem768G

[Anonymous]

Now I have a data 780 Million rows with 15columns.  It stucks when load until 750M rows.

It has a limitation for loading with a huge data or solution to fix the issue.

[oknotsen]

Qlik doesn't have this limitation.

Maybe your source does not allow for a connection to be open this long or has a maximum rows defined?

[neha_shirsath]

Hi Akira,

Qlikview does not have any such limitation,unless and until you have good ram and space in your qv server.

Thanks,

Neha

[Anonymous]

Time out is set up 6 hrs. But it stuck when load 750M to 3 hours and not loading until time out.

(ram 768G)

[neha_shirsath]

Set below-

Set TimeOutBatch=216000;

Set TimeOutFetch=217000;

set your respective time.

[Anil_Babu_Samineni]

1) Are you storing this into qvd?

2) May be you don't have space on your machine environment of that Folder.

Can you check those and reply ASAP

[Anonymous]

Hi Akira,

Could you please tell us what kind of a load are you performing or better yet could you post a sample script.

[sasiparupudi1]

please attach your script log to understand better if it has encountered any error

[Anonymous]

1) I load from qvd file separte by month. I want to load data for 2years and 1quarter.

2) I have space about 150GB

[Anonymous]

1) I load from qvd file separte by month. I want to load data for 2years and 1quarter.

2) I have space about 150GB