Not enough memory for operation

[fairbro]

Am using CR 10, and CE 10. I get the error "Not enough memory for operation" on CE. I don't get it in CR. I had this problem 6 months ago, and the resolution then was in the correct set-up of CSV format. I am using the same settings but it isn't working now. Another possible clue is I am FTPing the file. Any help would be appreciated.

 

[synapsevampire]

Perhaps the service pack will help:

http://support.businessobjects.com/fix/hot/si75/default.asp#Crystal Enterprise Service Packs

CE 10 is definitely a memory hog, how much ram do you have on the box?

-k

 

[fairbro]

I figured it out! It was a null issue on a date field. I modified my Date (ToNumber) formula, to include this "If" part:
if {EMF.EM_BIRTH_DATE} <> "" then
DATE (ToNumber (Left({EMF.EM_BIRTH_DATE},4)),
ToNumber (Mid ({EMF.EM_BIRTH_DATE},5,2)),
ToNumber (Right ({EMF.EM_BIRTH_DATE},2)))
else date (0,0,0)

 

[synapsevampire]

That caused a memory error?

Bizarre...

-k

 

[fairbro]

Yes, very bizarre.

 

[synapsevampire]

Dates would never be a "" anyway, and your formula shows that it was never a date, rather a string field which contained a date.

Nothing indicating a formula field was involved in the first post anyway, glad you resolved it.

-k

 

[fairbro]

The "" is a null, and yes, we occassionally have employees who have no birthday.

The way I solved this problem is, I tried to export it as a CSV from CR, I got a String error, which pointed me to the birthday date formula. I put 2 and 2 together there.

All way that ends well. <smile>

 

[mdwyer]

Ya' gotta wonder about those employees with no birthday. It could play havoc with memory, I suppose.

 

[jraheja]

I have 2 folders that have reports. How do I know which one is being referenced in the repository? I forgot which one I had imported. Basically, I want to know the source report.