SAP Knowledge Base Article - Preview

3308725 - CURRCONV object can't be validated - SQL20482N

Symptom

You're upgrading Db2 and observe invalid objects in the shadow schema SAP<sid>SHD.
  
db2 "SELECT SUBSTR(OBJECTSCHEMA,1,20) as OBJECTSCHEMA, SUBSTR(OBJECTNAME,1,20) as OBJECTNAME, SUBSTR(ROUTINENAME,1,30) as ROUTINENAME, OBJECTTYPE, SUBSTR(ERRORMESSAGE,1,40) as ERRORMESSAGE  FROM SYSCAT.INVALIDOBJECTS"

OBJECTSCHEMA       OBJECTNAME                ROUTINENAME                               OBJECTTYPE   ERRORMESSAGE
SAPSIDSHD            SQL220630000135242   CURRENCY_CONVERSION               F                   SQL0204n "SAPSIDSHD.TCURX" is an undefined name.
SAPSIDSHD            SQL220630000135543   CURRENCY_CONVERSION_INLINE   F                   SQL0204n "SAPSIDSHD.TCURX" is an undefined name.


Any attempt to revalidate these objects fails with:

db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(NULL, NULL, NULL)" 
SQL20482N  Revalidation failed for all objects that were specified to be 
revalidated. One object, "SAPSIDSHD.CURRCONV.SQL220630000135242", could not be 
revalidated because it references object "SAPSIDSHD.TCURX".  SQLSTATE=429C4


Read more...

Environment

  • IBM DB2 LUW (DB6) any release

Product

SAP NetWeaver Application Server all versions

Keywords

SQL20482N , SQL0361W , validate , upgrade , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-UPG , Upgrade SAP System , 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.