Error Messages Associated with SQLSTATE 42602

This topic lists the errors associated with the SQLSTATE 42602.

SQLSTATE 42602 Description

ERRCODE_INVALID_NAME

Error messages associated with this SQLState

ERROR 2383: Cannot create projections due to naming conflicts with existing projections
ERROR 2398: Cannot determine the best encoding options for some columns in table string.string due to insufficient data
ERROR 3059: DEPRECATED syntax. Segment expression "string" is a projection column name, segmenting on attribute "string"stringstringstring instead
ERROR 3378: Failed to generate a unique relation or sequence name
ERROR 3674: Invalid identifier name (value octets) "string"
ERROR 3703: Invalid name syntax
ERROR 3747: Invalid savepoint identifier string
ERROR 4159: Non-ASCII characters in names are prohibited
ERROR 4267: Only table column names & filler column names can appear in the list
ERROR 4451: Projection "string" does not exist
ERROR 4506: Query weight must be positive
ERROR 5360: User "string" does not exist
ERROR 5403: User/role "string" already exists
ERROR 5569: Either column "string" does not exist or table alias "string" is not allowed in "WHEN MATCHED THEN UPDATE SET"
ERROR 5769: Cannot drop the main vertica license
ERROR 5968: No such license string to drop
ERROR 5970: Node string is not a control node
ERROR 6089: Unknown control node string
ERROR 6676: Cannot drop global heir user "string". Try changing / clearing the GlobalHeirUsername config parameter
ERROR 7117: Refresh table name error: string
ERROR 8304: Paramter has the same name as argument: string
ERROR 8403: Cannot drop the only AutoPass license
ERROR 8642: Invalid model name: string

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.