SAP Knowledge Base Article - Preview

2839935 - Insufficient privileges error when replicating any tables - SLT

Symptom

  • Failed to create triggers for table <table name> with logging table <logging table name>
    RFC destination: <RFC connection name to source ABAP system>
    Database connection: R/3*
    ORA-01031: insufficient privileges
  • The source ABAP is installed on Oracle DB.
  • Dump in SM21 of source system:

*** ERROR => ORA-01031 occurred at SQL stmt (parse error offset=0) dbsloci.c 13576]
{root-id=0050568A58121ED9B4D87C555BA8A0FF}_{conn-id=CCC5D2E90ED4F15B80FF0050568A5812}_1
Dump statement cache (after SQL error):
sc_p=00000000094D6918,no=199,idc_p=0000000000000000,con=1,act=0,slen=94,smax=256,#vars=0,stmt=000000004E84A410,table=
CREATE SEQUENCE "sapsr3"."SEQ_/1CADMC/00002155" START WITH 1 INCREMENT BY 1 CACHE 1000 ORDER ;
statement (len=94) for table ' ':
CREATE SEQUENCE "sapsr3"."SEQ_/1CADMC/00002155" START WITH 1 INCREMENT BY 1 CACHE 1000 ORDER
exec_immediate() -> orc=1031, 99=DBSL_ERR_DB
head_p=00000000023F7840, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1011
*** ERROR => ^^ Ds_exec_imm() -> err=1=DS_SQLERR dbdsoci.c 1024]
{root-id=0050568A58121ED9B4D87C555BA8A0FF}_{conn-id=CCC5D2E90ED4F15B80FF0050568A5812}_1
***LOG BY2=> sql error 1031 performing EXE [dbds 578]
***LOG BY0=> ORA-01031: insufficient privileges [dbds 578]
***LOG BY1=> sql error 1031 [dbacds 1843]
dbcon[db_con_disconnect]: disconnecting from connection 1 ...


Read more...

Environment

SAP Landscape Transformation replication server

Product

SAP Landscape Transformation replication server all versions

Keywords

permission, authentication, authorization, ORA-01031: insufficient privileges , KBA , HAN-DP-LTR , Use CA-LT-SLT instead , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , CA-LTR-DB , Use CA-LT-SLT instead , 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.