2965049 - ORA-00904/ORA-904: IOV, RTRIM2 or CONCAT3 - SAP NetWeaver

Following error occurs or during upgrade (for example phase: MAIN_SHDIMP/SUBMOD_SHD2_RUN/XPRA):

Database error text: "SQL message: ORA-00904: "RTRIM2": invalid identifier"

In dev_w* trace, we can see following message when establishing database connection:

C  CREATE OR REPLACE FUNCTION CONCAT3 /*VERS1*/ (P1 IN VARCHAR2,P2 IN VARCHAR2,P3 IN NUMBER) RETURN VARCHAR2 IS $IF DBMS_DB_VERSIO
C  N.VERSION>11 $THEN PRAGMA UDF; $END BEGIN IF P1 IS NULL OR P2 IS NULL THEN RETURN NULL; END IF; IF P3=0 THEN RETURN CONCAT(RTRI
C  M(P1),RTRIM2(P2)); END IF; IF P3=1 THEN RETURN CONCAT(RTRIM(P1),P2); END IF; IF P3=2 THEN RETURN CONCAT(P1,RTRIM(P2)); END IF;
C  IF P3=3 THEN RETURN CONCAT(P1,P2); END IF; RETURN NULL; END;
C  e: OCIStmtExecute() failed with -1=OCI_ERROR, SQL error 1031:
C     ORA-01031: insufficient privileges
C     Creating function CONCAT3 failed with SQL error 1031
C  ORA-01031: insufficient privileges

Read more...

• Oracle
• as of SAP Kernel 7.40 

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

IOV, RTRIM2, CONCAT3, ORA-00904, 904, SAPCONN, MAIN_SHDIMP/SUBMOD_SHD2_RUN/XPRA , KBA , BC-DB-ORA-SYS , Database Interface / DBMS , BC-DB-ORA , Oracle , Problem