Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andrespa
Specialist
Specialist

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
antoniotiman
Master III
Master III

Hi Andres,

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

Try Subfiled(Payment_terms,'D',1)

Regards,

Antonio

View solution in original post

6 Replies
Kushal_Chawda

what expression you are using in chart?

Kushal_Chawda

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
Specialist
Specialist
Author

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

crusader_
Partner - Specialist
Partner - Specialist

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

antoniotiman
Master III
Master III

Hi Andres,

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

Try Subfiled(Payment_terms,'D',1)

Regards,

Antonio

andrespa
Specialist
Specialist
Author

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