Error Messages Associated with SQLSTATE VP000

This topic lists the errors associated with the SQLSTATE VP000.

SQLSTATE VP000 Description

ERRCODE_USER_PROC_ERROR

Error messages associated with this SQLState

ERROR 2059: string with specified name and parameters does not exist: string
ERROR 2315: Can't have more than one parameters with the same name: string
ERROR 3354: External procedures directory has not been set
ERROR 3355: External procedures have not been installed
ERROR 3465: Function cannot be moved into a system schema
ERROR 4322: Parameter must have names
ERROR 4323: Parameter type is not valid for an external procedure: string
ERROR 4373: Phase value of multi-phase transform function marked prepass
ERROR 4430: Procedures cannot be created in a system schema
ERROR 5232: Unrecognized identifier: string
ERROR 5368: User Defined Aggregates do not support fenced execution mode
ERROR 5372: User Defined Function type not found
ERROR 5374: User Defined Scalar Function string is giving bad numeric precision value, the maximum is value
ERROR 5375: User Defined Scalar Function string is giving bad string typmod value, the minimum is value
ERROR 5376: User Defined Scalar Function string is giving typmod of precision value, larger than the max precision value
ERROR 5377: User Defined Scalar Function string provided non-zero precision (value) for Interval Year To Month
ERROR 5378: User Defined Scalar Function string provided precision value, larger than the maximum precision value
ERROR 5379: User Defined Scalar Function string provided range for Day To Second, but the function's return type is Interval Year To Month
ERROR 5380: User Defined Scalar Function string provided range for Year To Month, but the function's return type is Interval Day To Second
ERROR 5684: User Defined Extension cannot be created in a system schema
ERROR 6051: The schema has been dropped
ERROR 6576: Schema does not exist: string
ERROR 6580: Stemmer UDx string must have VARCHAR or LONG VARCHAR parameter type
ERROR 6581: Stemmer UDx string must have VARCHAR or LONG VARCHAR return type
ERROR 6642: Argument types must be specified for stemmer "string"
ERROR 6869: Multi-phase transform function must have atleast one phase
ERROR 6961: Stemmer UDx string must return a single argument
ERROR 7010: Tokenizer required to create text index
ERROR 7015: UDSF or SQL Function with specified name and parameters does not exist: string
ERROR 7082: "string" is an incorrect EarlyMaterialize directive
ERROR 7128: Tokenizer "string" with specified argument types could not be found
ERROR 7129: Tokenizer UDx string must be polymorphic or have a single input field of CHAR, VARCHAR, LONG VARCHAR, VARBINARY, LONG VARBINARY, or USER DEFINED argument type
ERROR 7139: View cannot be moved into a system schema
ERROR 7582: User Defined Transforms with cursors do not support fenced execution mode

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