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.
SAP Knowledge Base Article - Preview