Symptom
SUM upgrade reports the following error
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 ============================================
Further analysis shows the following Db2 SQL errors reported in system log (transaction code SM21) and related developer traces (DIR_HOME)
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
Read more...
Environment
- Db2 z/OS any version
- SAP Netweaver ABAP any version
Product
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.