error while creating QVD

[#1]

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

[ramasaisaksoft]

Hi Nani,

Just do like below

Sales:

Load a,

b,

c

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".

[Anil_Babu_Samineni]

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.

[adamdavi3s · Accepted solution]

Lack of disk space maybe?

Is the QVD being accessed while its also being saved?

[neha_shirsath]

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

[#6]

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

[adamdavi3s]

This is the usual cause for this particular error!

Saving QVDs does require a lot of temp disk space

[#8]

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