Kbase P129094: The 10.1B 64-bit process _mprosrv process which handles remotely connected clients is using excessiv
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/09/2009 |
|
Status: Verified
SYMPTOM(s):
The 10.1B 64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
The 10.1A64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
The 10.0B 64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
The 10.0A 64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
The 9.1E 64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
The 9.1D 64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
The 9.1C 64-bit process _mprosrv process which handles remotely connected clients is using excessive CPU.
Query submitted by client is extremely large.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1C 64-bit
Progress 9.1D 64-bit
Progress 9.1E 64-bit
OpenEdge 10.0A 64-bit
OpenEdge 10.0B 64-bit
OpenEdge 10.1A 64-bit
OpenEdge 10.1B 64-bit
CAUSE:
Bug# OE00164234
FIX:
Upgrade to 10.1C01 or later.
This is a problem only for 64-bit versions of Progress / OpenEdge database server and has existed from 9.1E to 10.1C but is fixed in 10.1C01 or later.
If upgrade is not possible the following workarounds are known:
1) Use a 32-bit version of Progress / OpenEdge database server.
2) Use self service client connections to the database.
3) The behavior is linked to the size of the query. If possible, remodel the query to reduce the total number of characters used by the query.