topic Re: error while creating QVD in QlikView

error while creating QVD

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Hope all are doing great.

Need one information regarding QVD creation. Actually i am creating a QVD with huge data like 20 million rows.

i am able to load the table into the application but not able to convert that into QVD and getting below error.

The syntax and the table name are correct.

Can somebody guide me why i am getting this error.

PS: My Dev server got 64 GB Ram

Thanks,

Nani

Re: error while creating QVD

ramasaisaksoft — Wed, 15 Mar 2017 11:48:15 GMT

Hi Nani,

Just do like below

Sales:

Load a,

from xyz.xls;

store Sales into D:\Folder Name\Sales.qvd(qvd);

so u did syntax error u r not mentioned address where it need to save

if u feel u got solution for your query ,please close the thread by clicking "Correct Answer".

Re: error while creating QVD

Anil_Babu_Samineni — Wed, 15 Mar 2017 11:48:24 GMT

20 Million Rows is not a matter. We can store upto 128 Million Rows at a time(Confirmed from stevedark‌)

So, Might you are doing wrong while storing

Script is simple like below

CMI:

Load * from <Data-Source>;

Store CMI Into ;

Check whether the path going is straight way or wrong way.

Re: error while creating QVD

adamdavi3s — Wed, 15 Mar 2017 11:50:13 GMT

Lack of disk space maybe?

Is the QVD being accessed while its also being saved?

Re: error while creating QVD

neha_shirsath — Wed, 15 Mar 2017 11:54:26 GMT

Hi,

Comment your store statement and reload your data and check if its loading all data correctly.

If yes, then check with your store statement syntax.

Thanks,

Neha

Re: error while creating QVD

Wed, 15 Mar 2017 11:58:29 GMT

Hi Anil,

Thanks for the reply.

I think the issue is with the disk space as suggested by Adam, because i have used the same script to store 5 tables before.

Thanks,

Nani

Re: error while creating QVD

adamdavi3s — Wed, 15 Mar 2017 11:59:26 GMT

This is the usual cause for this particular error!

Saving QVDs does require a lot of temp disk space

Re: error while creating QVD

Wed, 15 Mar 2017 11:59:36 GMT

Thanks Adam. I haven't had a thought about it. i now noticed that i don't have disk space available to store QVD.

Regards,

Nani