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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.