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
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.