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.