Error QV 9.0 SR2 Out of Virtual and/or Logical Memory, allocating 128 MB

[#1]

Hi Forum.

I am trying to load data from the progress database. but i couldn't load it completely. I work with QV 9.0 SR2. I obtain this message:

The server has 32.0 GB of RAM and 4092 of virtual memory.

What can i do ?

Thanks a lot !!

[#2]

We have the same configuration on our server and get this error fairly often, but not on the load. It could be that you have too many complex expressions in the load script. We have changed most of the load script so that the database server does the hard work in SQL. so that it only loads raw data iinto Qlikview.

Hope this helps!

Don Saluga

ServiceLink

[#3]

Hi Forum

I found a post. This recomends to use ActiveDocument.ClearCache.

But How can i use this api in the script?

This is a part of the sript. I obtain the memory message in "Planilla_Cosecha": // HERE
LOAD [Codigo Sucursal], after Drop Table "Planilla_Cosecha_Tmp"; sentence.

Planilla_Cosecha_Tmp: //OK
LOAD
[Codigo Sucursal],
[Codigo Planilla],
[Numero Planilla],
[Consecutivo Planilla],
[Codigo Estado Planilla],
[Fecha Elaboracion Planilla],
ContadorEmpleados,
[Codigo Proveedor],
[Descripcion Proveedor],
[Numero Contrato],
[Codigo Estructura],
Fecha,
[Peso Neto],
[Precio Unitario],
[Codigo Labor],
[Codigo Clase Servicio],
[Numero Mallas],
[Novedad Mallas],
[Estado Estructura],
[Cantidad Racimos],
[Cantidad Timbos],
[Peso Bruto],
[Peso Tara],
[Hora Alce Cosecha],
[Puesto Recepcion],
[Nombre Labor],
[Codigo Empleado],
[Nombre Empleado],
[Cantidad Jornales]
FROM $(Qvds_Capas)Planilla_Cosecha_Aux.qvd (qvd) Where Year(Fecha)>='2007';

JOIN

LOAD

[Consecutivo Planilla],
count(ContadorEmpleados) as TotalEmpleados,
count([Cantidad Jornales]) as [Jornales Cosecha]
FROM $(Qvds_Capas)Planilla_Cosecha_Aux.qvd (qvd)
group by [Consecutivo Planilla];
Store "Planilla_Cosecha_Tmp" into $(Qvds_Capas)Planilla_Cosecha_Tmp.qvd;
Drop Table "Planilla_Cosecha_Tmp";

"Planilla_Cosecha": // HERE
LOAD
[Codigo Sucursal],
[Codigo Planilla],
[Consecutivo Planilla],
[Numero Planilla],
[Codigo Estado Planilla],
[Fecha Elaboracion Planilla],
[Codigo Proveedor],
[Descripcion Proveedor],
text([Numero Contrato]) as [Numero Contrato],
[Codigo Estructura],
Fecha,
[Codigo Labor],
[Codigo Clase Servicio],
[Codigo Empleado],
[Nombre Empleado],
[Numero Mallas],
[Novedad Mallas],
[Estado Estructura],
[Nombre Labor],
sum([Cantidad Racimos]) as [Cantidad Racimos],
sum([Cantidad Timbos]) as [Cantidad Timbos],
sum([Peso Bruto]) as [Peso Bruto],
sum([Peso Tara]) as [Peso Tara],
[Hora Alce Cosecha],
[Puesto Recepcion],
sum(ContadorEmpleados) as ContadorEmpleados,
count([Jornales Cosecha]) as [Jornales Cosecha],
sum([Precio Unitario]) as [Precio Unitario],
sum([Peso Neto]/TotalEmpleados) as [Cantidad Ejecutada],
sum([Peso Neto]/TotalEmpleados)*sum([Precio Unitario]) as [Valor Ejecutado]
FROM $(Qvds_Capas)Planilla_Cosecha_Tmp.qvd (qvd) WHERE Year(Fecha)>=2007
group by [Codigo Sucursal],[Codigo Planilla],[Consecutivo Planilla],[Numero Planilla],[Codigo Estado Planilla],
[Fecha Elaboracion Planilla],[Codigo Proveedor],[Descripcion Proveedor],
[Numero Contrato],[Codigo Estructura],[Estado Estructura],Fecha,[Codigo Labor],[Nombre Labor],[Codigo Clase Servicio],
[Codigo Empleado],[Nombre Empleado],[Numero Mallas],[Novedad Mallas],[Hora Alce Cosecha],[Puesto Recepcion];
Store "Planilla_Cosecha" into $(Qvds_Capas)Planilla_Cosecha.qvd;
Drop Table "Planilla_Cosecha";

Thanks a lot.

[#4]

Hi, first remember that`s not necesary uses group by in the sentence, QlikView works on memory and all these calculates could work in the expression like sum(total <[Codigo Sucursal]> [Peso Neto])/sum(total <[Codigo Sucursal]> TotalEmpleados) ).

Regards.

[#5]

Hi,

I would suggest check the below statement.

sum([Peso Neto]/TotalEmpleados)*sum([Precio Unitario]) as [Valor Ejecutado]

should it be like this:

sum( ([Peso Neto]/TotalEmpleados) * [Precio Unitario]) as [Valor Ejecutado]

Please try to change this code or comment it out to see if it makes any difference.

Thanks

Amit

[#6]

Thanks for your replys

i change the code

sum([Peso Neto]/TotalEmpleados)*sum([Precio Unitario]) as [Valor Ejecutado]

By

sum( ([Peso Neto]/TotalEmpleados) * [Precio Unitario]) as [Valor Ejecutado]

Also i comment it. and i obtain the same error.

If i try with QV 8.5. The script runs ok. but QV 9.0 doesn´t work (Out of Virtual and/or Logical Memory, allocating 128 ).

What can i do?

[#7]

Thanks for you reply. I use Expressions. But it doesn't work.

i have this script instead of having sentence:

"Planilla_Cosecha": //OK
LOAD [Codigo Sucursal],
sum(total <[Codigo Sucursal]> [Peso Neto])
FROM $(Qvds_Capas)Planilla_Cosecha_Tmp.qvd (qvd) WHERE Year(Fecha)>=2007
Store "Planilla_Cosecha" into $(QvdTemporal)Planilla_Cosecha.qvd;
Drop Table "Planilla_Cosecha";

what can i do ?

Thanks.

[#8]

Hi Forum

I have tried the script. the group by sentence works ok with QV 8.5. But QV 9.0 doesn´t work. What sentence can i use ?

I appreciate very much your suggestions ¡¡

LOAD
[Codigo Sucursal],
[Codigo Planilla],
[Consecutivo Planilla],
[Numero Planilla],
[Codigo Estado Planilla],
[Fecha Elaboracion Planilla],
[Codigo Proveedor],
[Descripcion Proveedor],
text([Numero Contrato]) as [Numero Contrato],
[Codigo Estructura],
Fecha,
[Codigo Labor],
[Codigo Clase Servicio],
[Codigo Empleado],
[Nombre Empleado],
[Numero Mallas],
[Novedad Mallas],
[Estado Estructura],
[Nombre Labor],
sum([Cantidad Racimos]) as [Cantidad Racimos],
sum([Cantidad Timbos]) as [Cantidad Timbos],
sum([Peso Bruto]) as [Peso Bruto],
sum([Peso Tara]) as [Peso Tara],
[Hora Alce Cosecha],
[Puesto Recepcion],
sum(ContadorEmpleados) as ContadorEmpleados,
count([Jornales Cosecha]) as [Jornales Cosecha],
sum([Precio Unitario]) as [Precio Unitario],
sum([Peso Neto]/TotalEmpleados) as [Cantidad Ejecutada],
sum([Peso Neto]/TotalEmpleados)*sum([Precio Unitario]) as [Valor Ejecutado]
FROM $(Qvds_Capas)Planilla_Cosecha_Tmp.qvd (qvd) WHERE Year(Fecha)>=2007
group by [Codigo Sucursal],[Codigo Planilla],[Consecutivo Planilla],[Numero Planilla],[Codigo Estado Planilla],
[Fecha Elaboracion Planilla],[Codigo Proveedor],[Descripcion Proveedor],
[Numero Contrato],[Codigo Estructura],[Estado Estructura],Fecha,[Codigo Labor],[Nombre Labor],[Codigo Clase Servicio],
[Codigo Empleado],[Nombre Empleado],[Numero Mallas],[Novedad Mallas],[Hora Alce Cosecha],[Puesto Recepcion];
Store "Planilla_Cosecha" into $(Qvds_Capas)Planilla_Cosecha.qvd;
Drop Table "Planilla_Cosecha";