SAP Knowledge Base Article - Preview

2420341 - Dump when table DDLOG exceeds max value

Symptom

You face one of the following dumps:

Category ABAP Programming Error
Runtime Errors UNCAUGHT_EXCEPTION
Exept. CX_KMETH_ERR
ABAP Program CL_BUFFER_SYNC================CP
Application Component BC-DB-DBI

And in the relevant developer, trace you can found the following:

B dbsync[db_syexe]: wait=1, call_no=11022, current_ts=20170124182041, last_counter=-2147483648
C e: OCIStmtExecute() failed with -1=OCI_ERROR, SQL error 1455:
C *** ERROR => Error 1455 in stmt_fetch() from oci_execute_stmt(), orpc=0
[dbsloci.c 19528]
C {root-id=18A90542625C1EE6B8CC3A0575F43789}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => ORA-01455 occurred at SQL stmt (parse error offset=0)
[dbsloci.c 19538]
C Dump statement cache (after SQL error):
C sc_p=7fbd6544c8f8,no=123,idc_p=7fbd65468520,con=0,act=1,slen=98,smax=256,#vars=1,stmt=a23e850,table=DDLOG
C stmtid = <1//bas/745_REL/src/krn/dbi/dbs/dbsynseq /413/20170106204103>
C SELECT SEQNUMBER, SYSTEMID, NBLENGTH, NOTEBOOK FROM DDLOG WHERE SEQNUMBER > :A0 ORDER BY SEQNUMBER;
C statement for table 'DDLOG':
C SELECT SEQNUMBER, SYSTEMID, NBLENGTH, NOTEBOOK FROM DDLOG WHERE SEQNUMBER > :A0 ORDER BY SEQNUMBER
C stmt_fetch() -> orc=1455, 99=DBSL_ERR_DB
C Dump statement cache (rc=99=DBSL_ERR_DB):

OR

Category ABAP Programming Error
Runtime Errors DBIF_DSQL2_DEFAULT_CR_ERROR
Except. CX_SY_NATIVE_SQL_ERROR
ABAP Program SAPLSYDB
Application Component BC-DB-DBI

And in the relevant developer trace or "Database Interface Information" session in the dump you can found the following:

|Database Interface Information |
----------------------------------------------------------------------------------------------------
|B|1|table logging switched on for all clients [dbprt.c#1379]
|C|1| OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4424]
|C|1| SQL error 8004: [dboci.c#4425]
|C|E|Error 8004 in stmt_execute() from oci_execute_stmt(), orpc=0 [dbsloci.c#18307]
|C|E|ORA-08004 occurred at SQL stmt (parse error offset=0) [dbsloci.c#18308]
|C|1|Dump statement cache (after SQL error): [dbsloci.c#18308]
|C|1|sc_p=0000000009E688D8,no=35,idc_p=0000000009E831F0,con=0,act=1,slen=117,smax=256,#vars=4,stmt=
|C|1|INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES (DDLOG_SEQ.NEXTV
|C|1|0, :A1, :A2, :A3); [dbsc.c#2318] 
|C|1| statement for table 'DDLOG ': [dbsloci.c#18325] 
|C|1| INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES (DDLOG_SE
|C|1| stmt_execute() -> orc=8004 (orc1=8004), rc=99=DBSL_ERR_DB [dbsloci.c#18333] |
|C|1|Dump statement cache (rc=99=DBSL_ERR_DB): [dbsloci.c#12736]
|C|1|sc_p=0000000009E688D8,no=35,idc_p=0000000009E831F0,con=0,act=1,slen=117,smax=256,#vars=4,stmt=
|C|1|Dumping stmt. cache (DBSL private attributes): [dbsloci.c#17744]
|C|1|sch=09E688D8, scp=09E73060, ups_sch=0000NULL, stp=4C756E58, r_c=0 [dbsloci.c#17746]
|C|1|prep=0, dbds=0, lit_cnt=0, lob_cnt=0, fae_cnt=0, xop=1, dbcount=0 [dbsloci.c#17752]
|C|1|IN : col_cnt=4, row_max=1, row_xcnt=1, row_pcnt=0, row_i=0, row_total=1, [dbsloci.c#17762]
|C|1| row_upto=4294967295, row_size=32078, vda_max=32, bound=1, itp=09EFFD70, vda_arr=4C746D80
|C|1| lob_anz=0, lob_max=0, lob_pw=0, lobarr=0000NULL, rows_ret=0 [dbsloci.c#17776]
|C|1|OUT: col_cnt=0, row_max=0, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0, [dbsloci.c#17762]
|C|1| row_upto=0, row_size=0, vda_max=0, bound=0, itp=0000NULL, vda_arr=0000NULL [dbsloci.c#177
|C|1| lob_anz=0, lob_max=0, lob_pw=0, lobarr=0000NULL, rows_ret=0 [dbsloci.c#17776]
|C|1|INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES (DDLOG_SEQ.NEXTV
|C|1|0, :A1, :A2, :A3); [dbsc.c#2318]
|B|E|***LOG BY4=> sql error 8004 performing INS on table DDLOG [dbsynseq#590]
|B|E|***LOG BY0=> ORA-08004: sequence DDLOG_SEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated
|B|E|***LOG BZY=> unexpected return code 2 calling ins_ddlog [dbsync#1396]
|B|1|db_syflush (TRUE) failed [dblink.c#1498]
|B|1|db_con_commit received error 1024 in before-commit action, returning 8 [dbcon.c#1602]


Read more...

Environment

SAP NetWeaver release independent.

Product

SAP NetWeaver all versions

Keywords

error, SM21, DB, commit, , KBA , BC-DB-DBI , DB Independent Database Interface , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.