Consultor Eletrônico



Kbase P111653: The _sqlsrv2 process crashes during a query from C#.NET application
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   7/5/2006
Status: Unverified

FACT(s) (Environment):

IBM AIX POWER 5.3
OpenEdge 10.0B 64-bit

SYMPTOM(s):

The _sqlsrv2 process crashes during a query from C#.NET application

ODBC SQL92 driver 4.20.00.057

The C#.NET application is making 2 concurrent connections

When the application uses single connection the problem doesn't occur

SQL92 server crashes with error 49 after some time of processing the query

SYSTEM ERROR: Memory violation. (49)

Stack trace from _sqlsrv2 reads:
append__6slist2FP6slink2
ssm_setcursor__FP9rds_env_tPCcP12sql_stmuid_tUcT2P5sqldaP5sqlcaT2
sql_fn
process_request__14cursor_reply_tFv

The ODBC driver gets disconnected because of the SQL92 server crash

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Server did not respond - PGPRO1019.DLL

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Transmit Error - PGPRO1019.DLL

CAUSE:

This is a known issue being investigated by Development

FIX:

At the moment, the only possible workaround to avoid this problem is to eliminate concurrent ODBC connections to Progress database from C#.NET application.