SAP Knowledge Base Article - Preview

3195053 - Db2 LUW: Views missing post upgrade

Symptom

After an upgrade you find that several application views are missing or inaccessible from the system.

The db2diag.log shows errors containing the SQL0344N (-344) error code as below:

FUNCTION: DB2 UDB, database application extension for utilities, admin_revalidate_db_objects_new, probe:655
DATA #1 : String, 75 bytes
Unexpected error during revalidation.See object name, type and SQLCA below.
DATA #2 : String, 22 bytes
SAPSID.VIEWNAME
DATA #3 : ASCII Char, 1 bytes
V
DATA #4 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -344   sqlerrml: 43
 sqlerrmc: SAPSID.VIEWNAME PURCHASEORDERDRAFTUUID
 sqlerrp : SQLNQ10F
 sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0xFFFFFCCD      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
 sqlstate: 42825
DATA #5 : signed integer, 8 bytes
-819


Read more...

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.