SQL error in the database when accessing a table.

shaileshrajram_yadav — Wed, 12 Jan 2011 06:24:41 GMT

Hi,

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

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 02.01.2011 15:55:06

Short text

SQL error in the database when accessing a table.

How to correct the error

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

forcibly closed by the remote host.

[10054] Communication link failure"

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

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_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

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

| "ADD_INSTANCE"

Information on where terminated

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

in "ADD_INSTANCE".

The main program was "SAPMSSY1 ".

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

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

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

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

declared

in the RAISING clause of its signature.

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

code begins in line

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

Source Code Extract

Line

SourceCde

1	METHOD add_instance .

3	data: ls_id type swfcntbuf.

5	check buffer method - store in local buffer if necessary

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

8	CHECK m_buffer_method EQ mc_buffer_shared.

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

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

13	ls_id-mandt = sy-mandt.

14	ls_id-id = ibf_por.

>>>>>

INSERT swfcntbuf CONNECTION r/3*wfcontainer

17	FROM ls_id.

19	IF sy-subrc EQ 0.

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

21	database locks

22	COMMIT CONNECTION r/3*wfcontainer.

ENDIF.

25	ENDMETHOD.

Re: SQL error in the database when accessing a table.

matt — Wed, 12 Jan 2011 08:59:44 GMT

duplicate here

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

topic Re: SQL error in the database when accessing a table. in Application Development and Automation Discussions

SQL error in the database when accessing a table.

Re: SQL error in the database when accessing a table.