Error Message

State: Upgrade Failed
Customer's tasks: Stopped
Info: All queries combined using a UNION, INTERSECT, or EXCEPT operator must have an equal number of expressions in their target lists.

The upgrade failure and information message are caused by the presence of custom SQL objects in the Customer database that are not supplied as part of the normal installation and that are not correctly formatted. Such SQL objects can include views or stored procedures designed to provide data as needed by specific business needs, such as reporting on data that is not available using the built-in reporting functionality, or obtaining data to be presented in a monitoring dashboard. These SQL objects are usually added post-installation by a third party.

The error itself is caused by one or more of the custom SQL object using one or more of the UNION, INTERSECT, or EXCEPT SQL operators in a query that is incorrectly formatted. The sub-queries separated by the operators do not have an equal number of columns and/or expressions listed in the SELECT statement. Parsing such miss-matched queries conjoined with these operators will not show any errors. However, executing such miss-matched queries conjoined with these operators will show the error above.

SQL objects that are added to Accelerator databases by a third party and that are not part of a normal installation are not supported by Veritas and must be removed in order to allow an upgrade to complete successfully. Steps to remove such third party objects are outside the scope of this article and must be referred back to the third party creating the objects. Visually reviewing the database may indicate the third party objects; however, it is recommended the third party adding the objects be consulted. Once the third party objects have been removed without any modifications to the existing database schema, the upgrade can be re-tried.