Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

_msssrv.exe hangs when creating a new record

Dataserver process uses 100% of the CPU time

DataServer log in debug mode indicates that the dataserver engine hangss after sending an INSERT INTO query to the database

Hang can only be reproduced within the application, provided the same steps.

FACT(s) (Environment):

Creating a new record in a MS SQL Server database
Using SQL Client ODBC 2000.86.3959
Windows
OpenEdge 10.2B
MS SQL DataServer 2005


CAUSE:

Bug# OE00200547

CAUSE:

Normal 0 false false false EN-US X-NONE X-NONE ing"/> lse" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> Name="Medium List 2 Accent 4"/> :LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} The issue is specific to the condition where the number of statements on the free chain reaches the maximum limit of 20, and tries to de-allocate the "least recently used" statement, and add a new statement to be executed. In this scenario, suppose, if the last used statement is still being in "EXCLUSIVE-LOCK" state, the application is getting blocked, until it gets released by the server. .

FIX:

The issue is fixed in upcoming releases OpenEdge 10.2B04 and OpenEdge 11.0.0

FIX:

As a workaround use the use the SQL Native Client (2005.x.x) to provide connectivity between the MS SQL Server 2005 database and the 10.2B Dataserver