Workprocess in Reconnect state

[Former Member]

Hi All,

Can someone please advice on the log of developer trace for the work process.

Wed Sep 16 08:59:57 2009

***LOG BV4=> reconnect state is set for the work process [dblink#5 @ 1958] [dblink 1958 ]

***LOG BYY=> work process left reconnect status [dblink#5 @ 1959] [dblink 1959 ]

System information.

Environment : MSCS cluster landscape

Version: Ecc 6.0

Kernel release 700

Compilation NT 5.2 3790 Servic

Sup.Pkg lvl. 179

ABAP Load 1563

CUA load 30

Mode opt

DB client lib. SQL_Server_8.00

DB releases MSSQL 7.00.699 or

DBSL version 700.08

DBSL Patch Level 180

Points would be rewarded.

Thanks and Regards

Abdul

[anindya_bose]

Network problem suspected...

Please check note https://service.sap.com/sap/support/notes/124562

[Former Member]

Hi ,

There are two methods of reconnect for a workprocess ::

1.Reconnect with restart of the work process

2.Reconnect without restart of the work process

In first case SAP internal reconnect mechanism is switched off using the profile parameter rsdb/reco_trials.

A work process running with an error condition is restarted. This includes a rollback of the SAP logical unit of work (LUW) and a reconnect to the database. If the restart fails, the process terminates. You then have the following options to restart the process:

If the application server is still running (that is, if the dispatcher, at least one dialog work process, and the SAP buffers are still available), you can use transaction sm51 to perform a u201Crestart after error.u201D

You can restart the application server. A restart of the application server means that all SAP buffers on the affected application server are lost.

In second case The reconnect is initiated if a request sent to the database by a work process returns one of the database errors included in the RECONNECT error group. The subsequent processing depends on the type of work process that sent the request.

Thanks..

Mohit