SAP Knowledge Base Article - Preview

2900425 - SLT replication from Oracle fails with ORA-01031: insufficient privileges - SAP Landscape Transformation Replication Server

Symptom

SLT replication of Oracle table fails.

LTRC > Application Logs shows the error:

Failed to create logging table /1CADMC/00000XXX for table NODE
Database connection: DBCONNNAME
SQL code: 1.031
SQL message: con=4(IPADDRESS:1521/DATABASE): ORA-01031: insufficient privileges

SM21 search for ORA-01031:

CREATE OR REPLACE FUNCTION IOV /*VERS1*/ (L IN NUMBER,V IN NUMBER) RETURN NUMBER IS $IF DBMS_DB_VERSION.VERSION>11 $THEN
...
e: OCIStmtExecute() failed with -1=OCI_ERROR, SQL error 1031:
ORA-01031: insufficient privileges
Creating function IOV failed with SQL error 1031
ORA-01031: insufficient privileges
SQL function RTRIM2 does not exist (orc=1403).
SQL function CONCAT3 does not exist (orc=1403).


Read more...

Environment

  • SAP Landscape Transformation Replication Server
  • Oracle

Product

SAP Landscape Transformation replication server 2.0 ; SAP Landscape Transformation replication server 3.0 ; SAP NetWeaver 7.4

Keywords

KBA , HAN-DP-LTR , Landscape Transformation Replication Server , 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.