SAP Knowledge Base Article - Preview

2955478 - SUM upgrade reports SQLCODE = -478 and -454 in phase MAIN_TRANSEXEC/RUN_RUTCNVFUNCCRE_TRANS

Symptom

SUM upgrade reports the following error

LINE.jpg
4 EPU202X====MARK ANALYZED SECTION==== END OF RUN_RUTCNVFUNCCRE ======= BEGIN OF RUN_RUTCNVFUNCCRE =========
3 EAD525 Start of XPRA program: "RUTCNVFUNCCRE1" time stamp "20200804" "103041"
A1EEDDVIDB 071'"CURRENCY_CONVERSION" statement for function "DROP" cannot be executed
A1EEDDVIDB 071'"CURRENCY_CONVERSION" statement for function "CREATE" cannot be executed
3 EAD527XEnd of XPRA program "RUTDELCDSVIEW" "20200804" "103042"
3 EAD528 XPRA program ends with return code "8"
4 EPU202XEND OF SECTION BEING ANALYZED END OF RUN_RUTCNVFUNCCRE ============================================
LINE.jpg

Further analysis shows the following Db2 SQL errors reported in system log (transaction code SM21) and related developer traces (DIR_HOME)

LINE.jpg
dev_w0.log:


C Mon Aug 3 18:02:00:465 2020
C *** ERROR => DB2 Call 'SQLExecDirectW' Error: conHdl = 00 SQLCODE = -478 : [IBM][CLI Driver][DB2] ALTER, DROP, OR REVOKE AFFECTING OBJECT TYPE FUNCTION CANNOT BE PROCESSED BECAUSE OBJECT SAPR3.SEPMRA_PPOIWD1 OF TYPE VIEW IS DEPENDENT ON IT
[dbdb2cli.c 6610]
C {root-id=0200020000201EEAB5BB3E9D0C8D239A}_{conn-id=00000000000000000000000000000000}_0
C DB2Trc:
C DROP SPECIFIC FUNCTION
C "CURRENCY_CONVERSION"
C ;
B ***LOG BY2=> sql error -478 performing EXE [dbds 684]
B ***LOG BY0=> [IBM][CLI Driver][DB2] ALTER, DROP, OR REVOKE AFFECTING OBJECT TYPE FUNCTION CANNOT BE PROCESSED BECAUSE OBJECT SAPR3.SEPMRA_PPOIWD1 OF TYPE VIEW IS DEPENDENT ON IT [dbds 684]
C
C Mon Aug 3 18:02:03:479 2020
C *** ERROR => DB2 Call 'SQLExecDirectW' Error: conHdl = 00 SQLCODE = -454 : [IBM][CLI Driver][DB2] THE SIGNATURE PROVIDED IN THE CREATE FUNCTION STATEMENT FOR SAPR3.CURRENCY_CONVERSION MATCHES THE SIGNATURE OF SOME OTHER FUNCTION ALREADY EXISTING IN THE SCHEMA
LINE.jpg


Read more...

Environment

  • Db2 z/OS any version
  • SAP Netweaver ABAP any version

Product

SAP NetWeaver all versions

Keywords

SQL0454N SQLCODE454N SQL0478N SQLCODE478N CDS SPAM SAINT SLTOOLSET , KBA , BC-DB-DB2 , DB2 for z/OS , BC-DB-DB2-UPG , DB2 for z/OS - Upgrade , 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.