SQL error in the database when accessing a table.

[shaileshrajram_yadav]

Hi,

I got below error at production server. Please suggest how to reslove this error.

<br>

<br>

<br>

Runtime Errors DBIF_RSQL_SQL_ERROR

<br>

Exception CX_SY_OPEN_SQL_DB

<br>

Date and Time 02.01.2011 15:55:06

<br>

-

---

<br>

<br>

-

---

<br>

<br>

Short text

<br>

SQL error in the database when accessing a table.

<br>

-

---

<br>

<br>

How to correct the error

<br>

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

<br>

forcibly closed by the remote host.

<br>

[10054] Communication link failure"

<br>

Internal call code.........: "[RSQL/INSR/SWFCNTBUF ]"

<br>

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

<br>

<br>

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

<br>

find an interim solution in an SAP Note.

<br>

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

<br>

keywords:

<br>

<br>

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

<br>

"CL_SWF_CNT_FACTORY_SHMEM======CP" or "CL_SWF_CNT_FACTORY_SHMEM======CM001"

<br>

| "ADD_INSTANCE"

<br>

<br>

-

---

<br>

Information on where terminated

<br>

Termination occurred in the ABAP program "CL_SWF_CNT_FACTORY_SHMEM======CP" -

<br>

in "ADD_INSTANCE".

<br>

The main program was "SAPMSSY1 ".

<br>

<br>

In the source code you have the termination point in line 16

<br>

of the (Include) program "CL_SWF_CNT_FACTORY_SHMEM======CM001".

<br>

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

<br>

procedure "ADD_INSTANCE" "(METHOD)", but it was neither handled locally nor

<br>

declared

<br>

in the RAISING clause of its signature.

<br>

<br>

The procedure is in program "CL_SWF_CNT_FACTORY_SHMEM======CP "; its source

<br>

code begins in line

<br>

1 of the (Include program "CL_SWF_CNT_FACTORY_SHMEM======CM001 ".

<br>

-

---

<br>

-

---

<br>

<br>

Source Code Extract

<br>

-

---

<br>

Line

SourceCde

<br>

-

---

<br>

1	METHOD add_instance .

<br>

2

<br>

3	data: ls_id type swfcntbuf.

<br>

4

<br>

5	check buffer method - store in local buffer if necessary

<br>

6	retcode = cl_swf_cnt_factory=>add_instance( ibf_por = ibf_por instance = instance ).

<br>

7

<br>

8	CHECK m_buffer_method EQ mc_buffer_shared.

<br>

9

<br>

10	append key to list of tasks to add stored in database table SWFCNTBUF

<br>

11	will be evaluated by build process for shared memory area (UPDATE_BUFFER method)

<br>

12

<br>

13	ls_id-mandt = sy-mandt.

<br>

14	ls_id-id = ibf_por.

<br>

15

<br>

>>>>>

INSERT swfcntbuf CONNECTION r/3*wfcontainer

<br>

17	FROM ls_id.

<br>

18

<br>

19	IF sy-subrc EQ 0.

<br>

20	Commit seems to be necessary always, even if INSERT has failed, to get rid of

<br>

21	database locks

<br>

22	COMMIT CONNECTION r/3*wfcontainer.

<br>

23

ENDIF.

<br>

24

<br>

25	ENDMETHOD.

<br>

-

---

[matt]

duplicate here

Do not post the same question in more than on forum.