Symptom
R3trans -d -t4 fails, and trans.log shows:
4 ETW000 [ dev trc,00000] stmt=SELECT VERSION FROM SVERS
4 ETW000 [ dev trc,00000] STID=NULL
4 ETW000 [ dev trc,00000] sql> [RE]OPEN_CURSOR
4 ETW000 &R/3&SVERS&0&51&/0&25&SELECT VERSION FROM SVERS&0&
4 ETW000 [ dev trc,00000] sql> LEAVE_SQL_STMT {rows=0}
4 ETW000 &R/3&0&+0&
4 ETW000 [ dev trc,00000] bind_type_and_length(): 0 IN values, 0 host variables
4 ETW000 [ dev trc,00000] bind_type_and_length(): 1 OUT values, 1 col
4 ETW000 [ dev trc,00000] my_malloc: size=2064, mem_dbsl=224134
4 ETW000 [ dev trc,00000] -->alloc_io(con=0, buf_size=130000, array_buf_size=130000, row_np=890)
4 ETW000 [ dev trc,00000] alloc_io(row_size=144, ind_cnt=1, rcode_cnt=0,rlen_cnt=0)
4 ETW000 [ dev trc,00000] my_malloc: size=64, mem_dbsl=224198
4 ETW000 [ dev trc,00000] my_malloc: size=130016, mem_dbsl=354214
4 ETW000 [ dev trc,00000] bind_ind_and_values(OUT: con=0,arr=890,col=1,Iv_cnt=1,map_cnt=0, rc=0,rl=0,flt=0,int=0,int8=0,uc=72)
4 ETW000 [ dev trc,00000] - oci_define ( 0: SQLT_CHR , l=144, con=0, stp=3801f78, pv=3858e94, in=38587a0,rl=NULL,rc=NULL)
4 ETW000 [ dev trc,00000] c: OCIDefineByPos(OCI_DEFAULT) con=0 returned 0=OCI_SUCCESS
4 ETW000 [ dev trc,00000] bind_ind_and_values(con=0) -> DBSL_ERR_OK
4 ETW000 [ dev trc,00000] -->exec_fetch(con=0, bulk=0, sch=3725460, dap=7ffcf81863f0, DBSL_DIR_READ)
4 ETW000 [ dev trc,00000] -->stmt_fetch(con=0, sch=3725460, odp=372eb90, DBSL_DIR_READ)
4 ETW000 [ dev trc,00000] sql> FETCH_CURSOR {rows=1}
4 ETW000 &R/3&SVERS&1&0&
4 ETW000 [ dev trc,00000] time 2023-05-29 14:50:25, con=0 connected, new transaction
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#12: con=0,stp=3801f78,itr=1,off=0,bat=0)
4 ETW000 [ dev trc,00000] -->OCIStmtExecute(con=0, svc=37e5398, err=37e2b40): [dur. 0,000s]
4 ETW000 [ dev trc,00000] e: OCIStmtExecute() con=0 completed, rc=100=OCI_NO_DATA, no further data
4 ETW000 [ dev trc,00000] -> rc=1403=OCI_ERR_NOT_FOUND
4 ETW000 [ dev trc,00000] c: OCIAttrGet(OCI_ATTR_UB8_ROW_COUNT) con=0 returned 0=OCI_SUCCESS
4 ETW000 [ dev trc,00000] OCIStmtExecute(rpc=0): [dur. 0,000s]
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(orc=1403, rows processed 0, iters-errors = 1-0) [dur. 0,000s]
4 ETW000 [ dev trc,00000] sql> LEAVE_SQL_STMT {rows=0}
4 ETW000 &R/3&0&+1403&
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1403)
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 1403; buflen=25
4 ETW000 [ dev trc,00000] OCIErrorGet(): error text ->
4 ETW000 [ dev trc,00000] ORA-01403: no data found
4 ETW000 [ dev trc,00000] ocica() -> SQL code 1403,1403
4 ETW000 [ dev trc,00000] stmt_fetch() -> orc=1403, 24=DBSL_ERR_NOT_FOUND
4 ETW000 [ dev trc,00000] exec_fetch(): rc=24=DBSL_ERR_NOT_FOUND, suppl=999, ft=1, cp=0, bulk=0, xcnt=1, da_p->xcnt=0, dbcount=0
4 ETW000 [ dev trc,00000] row_i=0, row_pcnt=0, row_upto=4294967295, row_xcnt=1, row_max=1
4 ETW000 [ dev trc,00000] sccb_stmt_deactivate(sch=3725460)
4 ETW000 [ dev trc,00000] DbSlRead() --> 24=DBSL_ERR_NOT_FOUND
4 ETW000 [ dblink ,00000] ***LOG BZA=>table SVERS does not exist on database
SELECT VERSION FROM <SAPSCHEMA>.SVERS (for example: SELECT VERSION FROM SAPSR3.SVERS) has no data.
Read more...
Environment
SAP on Oracle
Product
Keywords
SVERS, table SVERS does not exist on database , KBA , BC-DB-ORA-SYS , Database Interface / DBMS , 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