SAP Knowledge Base Article - Preview

2320465 - ORA-01917 in SLT system when oracle is source database

Symptom

SLT reports following error:

"Failed to create triggers for table <table owner>.<table name> with logging table <logging table name>
Database connection: <database connection name>
ORA-01917: user or role does not exist"

In relevant work process trace, you can find the SQL command which triggers this error. This is an example below:

CREATE SEQUENCE "slthanaora"."SEQ_/1CADMC/V0000263" START WITH 1 INCREMENT BY 1 CACHE   100 ORDER;
C     statement (len=98) for table '                              ':
C         CREATE SEQUENCE "slthanaora"."SEQ_/1CADMC/V0000263" START WITH 1 INCREMENT BY 1 CACHE   100 ORDER
C     exec_immediate() -> orc=1917, rc=99=DBSL_ERR_DB
C  head_p=7fff264b4c00, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1011
C  *** ERROR => ^^ Ds_exec_imm() -> err=1=DS_SQLERR
 [dbdsoci.c    1024]
B  ***LOG BY2=> sql error 1917 performing EXE [dbds         670]


Read more...

Environment

SLT system
Oracle database

Keywords

SLT
ORA-01917
create triggers
create sequence , 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.