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
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.
SAP Knowledge Base Article - Preview