Out of object memory script load

[andrespa]

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

[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]

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_]

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 · Accepted solution]

Hi Andres,

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

Try Subfiled(Payment_terms,'D',1)

Regards,

Antonio

[andrespa]

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