2420341 - Dump when table DDLOG exceeds max value | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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