SAP Knowledge Base Article - Preview

3599330 - STMS_IMPORT fails with DBIF_RSQL_SQL_ERROR due ORA-01007

Symptom

After migration to Azure, STMS_IMPORT is not working, it dumps with DBIF_RSQL_SQL_ERROR :

C1check2: OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4460]
C1        SQL error 1007: [dboci.c#4461]
C1   ORA-01007: variable not in select list
CEError 1007 in stmt_fetch() from oci_execute_stmt(), orpc=0 [dbsloci.c#17902]
CEORA-01007 occurred at SQL stmt (parse error offset=0) [dbsloci.c#17905]
C1Dump statement cache (after SQL error): [dbsloci.c#17905]
C1sc_p=44195780,no=170,idc_p=(nil),con=0,act=1,slen=61,smax=256,#vars=2,stmt=4470f910,table=TMSBUFFER
C1SELECT * FROM "TMSBUFFER" WHERE "DOMNAM"=:A0 AND "SYSNAM"=:A1; [dbsc.c#2318]
C1   statement for table 'TMSBUFFER                     ': [dbsloci.c#17924]
C1       SELECT * FROM "TMSBUFFER" WHERE "DOMNAM"=:A0 AND "SYSNAM"=:A1
C1   stmt_fetch() -> orc=1007, 99=DBSL_ERR_DB [dbsloci.c#17931]
C1Dump statement cache (rc=99=DBSL_ERR_DB): [dbsloci.c#12506]
C1sc_p=44195780,no=170,idc_p=(nil),con=0,act=1,slen=61,smax=256,#vars=2,stmt=4470f910,table=TMSBUFFER
C1Dumping stmt. cache (DBSL private attributes): [dbsloci.c#17117]


Read more...

Environment

  • Oracle DB any version
  • Any Netweaver ABAP
  • Not restricted to any OS

Product

SAP NetWeaver all versions

Keywords

KBA , 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.