Symptom
One of the following dumps occur in the system:
| 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 the following can be seen:
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 the following can be seen:
|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
Keywords
error, SM21, DB, commit, SAPLSYDB, DBIF_DSQL2_DEFAULT_CR_ERROR, DDLOG , 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.
SAP Knowledge Base Article - Preview