Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

andrespa
Valued Contributor

Out of object memory script load

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

1 Solution

Accepted Solutions
Highlighted
antoniotiman
Honored Contributor III

Re: Out of object memory script load

Hi Andres,

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

Try Subfiled(Payment_terms,'D',1)

Regards,

Antonio

6 Replies

Re: Out of object memory script load

what expression you are using in chart?

Re: Out of object memory script load

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

andrespa
Valued Contributor

Re: Out of object memory script load

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

Partner
Partner

Re: Out of object memory script load

Hi

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

Highlighted
antoniotiman
Honored Contributor III

Re: Out of object memory script load

Hi Andres,

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

Try Subfiled(Payment_terms,'D',1)

Regards,

Antonio

andrespa
Valued Contributor

Re: Out of object memory script load

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