Symptom
After version upgrade to 16.1 sp05.07 from 16.0 SP11.x, noticed a high number of "View ... in database ... was invalidated due to DDL operations on one of its referenced objects" messages in *.srvlog and took long upgrade time. In addition to accessing a View which is 'invalid' status, following error message returns.
- Selecting an invalid view
> Select * from v1 ; <= In case of 'v1' invalid mode
Pop-Uped Error =>
Could not execute statement.
Cannot use view 'v1' because it is invalid
SQLCODE=-1040, ODBC 3 State="42000"
- First accessing an invalid View
When firstly accessing a View which is 'invalid' status after IQ server started, OR, after completed "Alter database upgrade", following error message returns in *.srvlog.
...
... Performance warning: View "v1" in database "TEST_IQ161SP05" was invalidated due to DDL operations on one of its referenced objects
- Upgrade from IQ16.0 to IQ16.1
While running 'Alter database upgrade' from IQ16.0 to IQ16.1, above 'Performance warning: View...' messages are logged to *.srvlog.
But between same IQ16.1, 'Alter database upgrade' doesn't take View validation check processing.
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
Keywords
View definition, recompile, invalid, "Invalid View", Validation View, Recompile, , KBA , BC-SYB-IQ , Sybase IQ , How To
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.