topic Out of object memory script load in QlikView

Out of object memory script load

andrespa — Tue, 07 Jun 2016 08:03:52 GMT

Hi, I have an issue that I have no idea why is happening. If someone had experience some similar situation please help me.

I'm calculating one simple expression on the script like this:

If(left(Payment_Terms,2)>=0, Date(Payment_Date+left(Payment_Terms,2)),Payment_Date+60)

AS New_Payment_Date

This one is working fine, but now I have to change it due to new requeriments for the below expression:

If(SubField(Payment_Terms,'D')>=0, Date(Payment_Date+SubField(Payment_Terms,'D')),Payment_Date+60)

AS New_Payment_Date

And that new expression give me the below error:

"Out of object memory"

I've tried everything I could but so far I'm not be able to solve this issue.

Best regards,

Andrés

Re: Out of object memory script load

Kushal_Chawda — Tue, 07 Jun 2016 08:10:16 GMT

what expression you are using in chart?

Re: Out of object memory script load

Kushal_Chawda — Tue, 07 Jun 2016 08:11:51 GMT

or can you give example with sample data, that what you are trying to do by this logic so that we can suggest some better way as well to do it

Re: Out of object memory script load

andrespa — Tue, 07 Jun 2016 08:24:12 GMT

The error is not in the chart, is when I'm loading the script. I know that sometimes in charts you can face this "out of memory" error but never saw it before on the load script.

Can't share any data, too huge and complex

Re: Out of object memory script load

crusader_ — Tue, 07 Jun 2016 08:33:04 GMT

Let's start from obvious things... Do you have enough RAM? Try to open task manager and check how your app consumes memory while reloading.

Also try left(Field, mid(Field,'D')-1) instead of SubField() function... try to identify what causes the crash.

HTH

Andrei

Re: Out of object memory script load

antoniotiman — Tue, 07 Jun 2016 08:33:38 GMT

Hi Andres,

Subfield(Payment_terms,'D') in LOAD generates n records.

Try Subfiled(Payment_terms,'D',1)

Regards,

Antonio

Re: Out of object memory script load

andrespa — Tue, 07 Jun 2016 08:45:47 GMT

Hi Antonio, so simple and still didn't see it! Thanks a lot that solves the issue!