Error Messages Associated with SQLSTATE 42V17

This topic lists the errors associated with the SQLSTATE 42V17.

SQLSTATE 42V17 Description

ERRCODE_INVALID_OBJECT_DEFINITION

Error messages associated with this SQLState

ERROR 2387: Cannot create projections involving external table string
ERROR 3075: Design type string is invalid
ERROR 3078: Optimization objective string is invalid
ERROR 3199: Error during deployment querying deployment projections table for workspace string
ERROR 3200: Error during deployment querying design projections table for design string in workspace string 
ERROR 3201: Error during deployment while querying deployment projections table for workspace string 
ERROR 3204: Error during drop design from deployment for workspace string 
ERROR 3206: Error during extend catalog while querying deployments table for workspace string
ERROR 3207: Error during getDesignTablesFromDeployment in workspace string 
ERROR 3213: Error during remove deployment drops from deployment string for workspace string 
ERROR 3227: Error in querying string.string
ERROR 3269: Error while checking whether there are only incremental design deployed for deployment string in workspace string 
ERROR 3271: Error while querying designs table for workspace string
ERROR 3968: More than one IDENTITY/AUTO_INCREMENT column defined for table "string"
ERROR 3983: Multiple instances of deployment string in workspace string
ERROR 4128: No valid projections found
ERROR 4230: ON DELETE rule may not use NEW
ERROR 4231: ON INSERT rule may not use OLD
ERROR 4232: ON SELECT rule may not use NEW
ERROR 4233: ON SELECT rule may not use OLD
ERROR 4635: Rule WHERE condition may not contain references to other relations
ERROR 4636: Rules with WHERE conditions may only have SELECT, INSERT, UPDATE, or DELETE actions
ERROR 4919: Temporary table projections are not allowed for this operation
ERROR 4982: There is no deployment string in workspace string
ERROR 4989: This function cannot be called on design string located in design workspace string
ERROR 4990: This function cannot be called on design string, when its design mode is string
ERROR 5367: User defined aggregate must return exactly one column.Function string returns value
ERROR 5369: User defined analytic must return exactly one column
ERROR 5384: User defined transform must provide names or aliases for return columns
ERROR 5385: User defined transform must return at least one column
ERROR 5527: An error occurred on node string when setting up the type, message:
    string
ERROR 5721: Purge is not allowed on temporary tables
ERROR 6095: UseLongStrings has been deprecated
ERROR 6166: Cannot create top-k projection: projection columns and limit are too big for the top-k buffer
ERROR 6483: Invalid enum value for parameter name
ERROR 6627: Aggregate projections may only contain User Defined Transforms with partition by BATCH in the outer query
ERROR 6628: Aggregate projections may only contain User Defined Transforms with partition by PREPASS or BATCH
ERROR 6659: Can not create prejoin projection
ERROR 6660: Can not create prejoin projection when node is recovering
ERROR 6970: Subqueries in aggregate projections may only contain User Defined Transforms with partition by PREPASS
ERROR 6993: The batch and prepass User Defined Transform Functions' signatures are not compatible for use in a live aggregate projection
ERROR 6994: The batch User Defined Transform Function does not have identical input and output signature
ERROR 7788: Only projections with single phase PREPASS User Defined Transforms can have user specified sort order or segmentation
ERROR 7789: ORDER BY / SEGMENTED BY / UNSEGMENTED are not allowed in projections with two phase User Defined Transforms. The projection is automatically ordered and segmented on partition by columns

Note: For information about troubleshooting Vertica error messages, see the Vertica Knowledge Base and the Vertica Forum.