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  SQL0601N -601 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 for Me (Login required).

Search for additional results

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