SAP Knowledge Base Article - Preview

2902161 - Db2 sqlcode -478 reported in tcode SM21 during SUM upgrade downtime phase MAIN_NEWBAS/RUN_RUTCNVFUNCCRE

Symptom

The following error is reported during the SUM Execution Phase MAIN_NEWBAS/RUN_RUTCNVFUNCCRE

___________________________________________________________________________________
Checks after phase MAIN_NEWBAS/RUN_RUTCNVFUNCCRE were negative!

Last error code set:
Single errors (code <= 8) found in logfile 'RUTCNVFUNCCRE.ELG'

ERROR:
Batchjob RUTCNVFUNCCRE1 failed.
The following errors were detected in the log files:

# U:\SUM\abap\log\RUTCNVFUNCCRE.AMA:
3 EAD525 Start of XPRQA program: "RUTCNVFUNCCRE1" time stamp "20200210" "083248"
A1EEDDVIDB 002 Action "CREAT": statements for session variables cannot be executed
____________________________________________________________________________________


You also observe the following Db2 SQLCODE -478 error reported in transaction code SM21
___________________________________________________________________________________
Database error -478 at EXE
> [IBM][CLI Driver][DB2] ALTER, DROP, OR REVOKE AFFECTING
> OBJECT TYPE VARIABLE CANNOT BE PROCESSED BECAUSE OBJECT
>SAPSID.SDRAFT_ADMIN_CDS OF TYPE VIEW IS DEPENDENT ON IT
___________________________________________________________________________________


The developer traces report the error as follows
___________________________________________________________________________________

sql:
DROP VARIABLE "$SAP_CLIENT"
SQL error -478: [IBM][CLI Driver][DB2] ALTER, DROP, OR REVOKE AFFECTING OBJECT T
YPE VARIABLE CANNOT BE PROCESSED BECAUSE OBJECT SAPSID.SDRAFT_ADMIN_CDS OF TYPE
VIEW IS DEPENDENT ON IT
DDL time(___1): ........16 milliseconds
.... SESSION_VARS was already removed

sql:
DROP VARIABLE "$SAP_USER"
SQL error -478: [IBM][CLI Driver][DB2] ALTER, DROP, OR REVOKE AFFECTING OBJECT T
YPE VARIABLE CANNOT BE PROCESSED BECAUSE OBJECT SAPSID.SDRAFT_ADMIN_CDS OF TYPE
VIEW IS DEPENDENT ON IT
DDL time(___1): ........16 milliseconds
.... SESSION_VARS was already removed

sql:
DROP VARIABLE "$SAP_LANGUAGE"
SQL error -478: [IBM][CLI Driver][DB2] ALTER, DROP, OR REVOKE AFFECTING OBJECT T
YPE VARIABLE CANNOT BE PROCESSED BECAUSE OBJECT SAPSID.SDRAFT_ADMIN_CDS OF TYPE
VIEW IS DEPENDENT ON IT
DDL time(___1): .........9 milliseconds
.... SESSION_VARS was already removed
___________________________________________________________________________________


Read more...

Environment

  • SAP Netweaver versions 7.x
  • Db2 z/OS any version

Product

SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

SQL0478N  46003 4600C 42893 dependency global , KBA , BC-DB-DB2 , DB2 for z/OS , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.