SAP Knowledge Base Article - Preview

3301319 - "View .. was .. invalidated due to DDL ..." after "alter database upgrade" -- SAP IQ

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

SAP IQ 16.0

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.