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 ...



Environment

SAP Landscape Transformation replication server

Product

SAP Landscape Transformation replication server all versions

Keywords

permission, authentication, authorization , KBA , HAN-DP-LTR , Landscape Transformation Replication Server , CA-LT-SLT , SAP Landscape Transformation Replication Server , CA-LTR-DB , LT Replication Server DB connection , 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.