Invalid View Definition

Error Description

There is an invalid view or a view is missing in the database.

Reason

Some of the related data source tables or views are not available. Therefore, the view is invalid. The message that appears when this error occurs is:

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ’<datasetname>'. (rsErrorExecutingCommand) Invalid object name 'vw<viewname>'.

Resolution

Reconfigure the MES BI Gateway Reports component in the post-install Configurator to redeploy the latest report files. Specifically, ensure that the settings in the BI Gateway Database Node section of the component are correct. Check for errors in the Configurator Configuration Messages box. For more information about deploying MES BI Gateway Reports, see the MES Installation Guide or online help.