Internal Inconsistency

[spividori]

Hi.

I have a file .qvd. It contains 8.800.000 registers. To recharge my application I add the following:

Autonumber(C_ID&'-'&N_IT&'-'&V) as Key,

Autonumber(C_ID&'-'&N_IT) as Key1,

This generates the following error:

or the following:

Someone can help me solve it?

Regards.

[Gysbert_Wassenaar]

Looks like your machine ran out of memory. Look at the ram usage when reloading the document.

Try loading a smaller set of records to see if the document reloads then and also check for the existence of synthetic keys in your data model.

[spividori]

Hi Gysbert.

Thanks for responding.

Reloading a small set of records, the error does not appear.

No synthetic key exists.

Regards.

[Gysbert_Wassenaar]

Ok, then are you joining tables in the script?

Try monitoring ram usage during reload using the windows Task Manager. How much ram is used? How much is available in your system. Are you using the 32-bit version of Qlikview or the 64-bit version?

[spividori]

Hi Gysbert.

Only load the table is in the qvd file containing 8,800,000 records and 20 columns.

The pc that makes recharging has 4GB of memory and 32-bit windows. When the monitor memory usage windows task manager shows 1.8 gb memory used error appears.

Thank You.

Regards.

[Gysbert_Wassenaar]

Ok, on a 32-bit system the maximum amount of ram a process can use is 2GB. You could be hitting that limit. Try loading on a 64-bit machine with the 64-bit version of Qlikview. Have you tried loading the qvd file in a new Qlikview document too? Just to make sure that your Qlikview document itself is not corrupt.

[spividori]

Yes, I tried to reload a new document and in different pc too, but the error appears. I will try on a machine with 64-bit windows as you advise me. But my server is 32 bits.

[spividori]

Hi Gysbert. I made the recharge on a pc with windows 64 bit and no error occurred. The monitor memory usage windows task manager shows 2.8 gb memory used. Regards.

[Gysbert_Wassenaar · Accepted solution]

Great. Looks like you found the cause then and have a solution.

[spividori]

Yes, I'll have to change the windows to my server at 64 bits. I thought it might be another solution. Thank You. Regards.