SQL error 10054 occurred when accessing program

[Former Member]

Hi All,

I am getting frequent dumps on one of app server with runtime error as DBIF_REPO_SQL_ERROR

in the error we see

===========

Database error text........: "[10054] TCP Provider: An existing connection was

forcibly closed by the remote host.#[10054] Communication link failure"

Triggering SQL statement...: "CX_SY_OPEN_SQL_DB=============CP "

Internal call code.........: "[REPO/*/43/LOAD/CX_SY_OPEN_SQL_DB=============CP

]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_REPO_SQL_ERROR" " "

"SAPMSSY2" or "RSBTCTRC"

"GET_CNTL_VALUES"

============

can someone provide help?

[Former Member]

Hi Vijay

As mentioned in the previoud reply, this problem is predominantly due to network error.

Refer SAP note 392892, 413330 and 37939. These noted should clear your doubts about the same. I would suggest checking up network status between the APP server and the DB server.

Hope this would help.

Regards

Rahul

[Former Member]

I got the soultuion, I found there is a change in the TCPIPWindowSize paramenter which got changed under HKLM\system\currentcontrolset\services\tcpip\parameters.

After fine turing the parameters this issue got fixed.

Thanks

Vijay

[Former Member]

Hi Vijay,

I am getting same problem. Can u pls explain how to fix this problem. How to set parameter.

Thank & regards,

Pramod

[former_member185031]

As per my understanding the connection between database server and application server has been terminated and it triggers a dump. Please check the log in SM21 and analyze the network connection also, more details can be found on developer trace files.

Regards,

Subhash