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.
SAP Knowledge Base Article - Preview