SYSTEM ERROR: strent request for more than 64K. (9874)

M

mattk

Member
Hi there,

This error appeared in our Progress log on our server the other day. Our vendor indicates that this is as a result of too many queries open at the same time - or left open within temp tables. Our platform is an OpenEdge 10.0B database on a Windows Server 2003 clustered environment.

Can you advise if this is an accurate explanation and if as they advise, the databases should be stopped / started to clear this? Or could this be as a result of bad programming?

Any help you could give would be much appreciated.


Thanks and regards,
 
Hi,

We had similar issue about 1 year ago. Same error, big consequences.
Issue was not cleaning up handles inside a big loop. Lets say that loop executed 10000 times leaving tons of handles open.

In our case it was rather easy to locate since it crashed mostly during night when certain exports were triggered.

Basically all i can advise is try to replicate the issue, hunt it down and review the code for missing delete objects and things like that.

Jan
 
The strent request error is one of those low level things that may occur for a number of reasons.

eg.
Configuration bug.
Progress bug.
Application bug (eg. garbage collection issues).

Your vendor's explanation would indicate the third issue, but it may mean 'imperfect' rather than 'bad' programming, unless it is occurring on a regular basis and causing disruption.

I can't comment technically on their advice, not knowing what the actual cause is. From a customer's point of view I suppose I would follow their advice, and pursue a more permanent solution from them.
 
You must log in or register to reply here.
Back
Top