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.