Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL error 3113 . Work processes in reconnect status

In my BW 3.5 system I am seeing lot of ORA-3113 errors in syslog.There is no network problems .

Attaching the logs herewith.Any help is appriciated

SM21:

dm04n_BWP_00 DIA 006 100 RTNT BYM SQL error 3113 . Work processes in reconnect status

dm04n_BWP_00 DIA 006 100 RTNT R68 Perform rollback

dm04n_BWP_00 DIA 006 100 RTNT BYY Work process has left reconnect status

dm04n_BWP_00 DIA 006 100 RTNT AB0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

dm04n_BWP_00 DIA 009 100 RTNT BYM SQL error 3113 . Work processes in reconnect status

dm04n_BWP_00 DIA 009 100 RTNT R68 Perform rollback

dm04n_BWP_00 DIA 009 100 RTNT BYY Work process has left reconnect status

dm04n_BWP_00 DIA 009 100 RTNT AB0 Run-time error "DBIF_RTAB_SQL_ERROR" occurred

dm04n_BWP_00 DIA 009 100 RTNT AB1 > Short dump "060420 055829 nb12rk06 RTNT" generated

dm04n_BWP_00 DIA 001 100 RTNT R68 Perform rollback

dm04n_BWP_00 DIA 006 100 RTNT AB1 > Short dump "060420 055828 nb12rk06 RTNT" generated

dm04n_BWP_00 DIA 001 100 RTNT AB0 Run-time error "UNCAUGHT_EXCEPTION" occurred

dm04n_BWP_00 DIA 001 100 RTNT AB1 > Short dump "060420 055830 nb12rk06 RTNT" generated

dm04n_BWP_00 DP Q0G Request (type NOWP) cannot be processed

dm04n_BWP_00 DIA 000 100 RTNT R68 Perform rollback

dm04n_BWP_00 DIA 000 100 RTNT AB0 Run-time error "CALL_FUNCTION_SEND_ERROR" occurred

dm04n_BWP_00 DIA 000 100 RTNT AB1 > Short dump "060420 060238 nb12rk06 RTNT" generated

Workprocess Trace

C *** ERROR => ORA-3113 occurred when executing SQL statement (parse error offset=0)

[dbsloci.c 11440]

C sc_p=104a25358,no=153,idc_p=0,con=0,act=1,slen=1800,smax=2560,#vars=0,stmt=105ba10b0,table=/BIC/FZC3FWPI95

C SELECT /*+ STAR_TRANSFORMATION FACT( T_00 ) */ T_04 . "SID_0FISCPER" "S____029" , T_05 . "SID_ZFWIN\

C PID" "S____379" , T_06 . "SID_0CURRENCY" "S____023" , T_07 . "SID_ZFWCOCODE" "S____378" , T_02 . "S_\

C ZFWCATGP" "S___450" , COUNT(*) "1ROWCOUNT" , SUM( T_00 . "/BIC/XFWPAADAC" ) "XFWPAADAC" , SUM( T_0\

B ***LOG BYM=> severe DB error 3113 ; work process in reconnect status [dbsh#2 @ 1119] [dbsh 1119 ]

B ***LOG BY4=> sql error 3113 performing FET on table /BIC/FZC3F [dbtran#3 @ 7275] [dbtran 7275 ]

B ***LOG BY0=> ORA-03113: end-of-file on communication channel [dbtran#3 @ 7275] [dbtran 7275 ]

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'

C *** ERROR => Failed to register application info: orc=3114

[dboci.c 2869]

C *** ERROR => ORA-3114 occurred when executing SQL statement (parse error offset=652)

[dbsloci.c 11440]

Thanks

Jose

Not what you were looking for? View more on this topic or Ask a question