SQL State List

The following table lists the SQLSTATE classes and individual SQLSTATE codes.

SQLState Description Details
Class 00—Successful Completion
00000 ERRCODE_SUCCESSFUL_COMPLETION  
Class 01—Warning
01000 ERRCODE_WARNING associated warning messages
01003 ERRCODE_WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION  
01004 ERRCODE_WARNING_STRING_DATA_RIGHT_TRUNCATION associated warning messages
01006 ERRCODE_WARNING_PRIVILEGE_NOT_REVOKED associated warning messages
01007 ERRCODE_WARNING_PRIVILEGE_NOT_GRANTED associated warning messages
01008 ERRCODE_WARNING_PRIVILEGE_ALREADY_GRANTED  
01009 ERRCODE_WARNING_PRIVILEGE_ALREADY_REVOKED  
0100C ERRCODE_WARNING_DYNAMIC_RESULT_SETS_RETURNED  
01V01 ERRCODE_WARNING_DEPRECATED_FEATURE associated warning messages
01V02 ERRCODE_WARNING_QUERY_RETRIED  
Class 02—No Data
02000 ERRCODE_NO_DATA  
02001 ERRCODE_NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED  
Class 03—SQL Statement Not Yet Complete
03000 ERRCODE_SQL_STATEMENT_NOT_YET_COMPLETE  
Class 08—Client Connection Exception
08000 ERRCODE_CONNECTION_EXCEPTION associated error messages
08001 ERRCODE_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION associated error messages
08003 ERRCODE_CONNECTION_DOES_NOT_EXIST associated error messages
08004 ERRCODE_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION  
08006 ERRCODE_CONNECTION_FAILURE associated error messages
08007 ERRCODE_TRANSACTION_RESOLUTION_UNKNOWN  
08V01 ERRCODE_PROTOCOL_VIOLATION associated error messages
Class 09—Triggered Action Exception
09000 ERRCODE_TRIGGERED_ACTION_EXCEPTION associated error messages
Class 0A—Feature Not Supported
0A000 ERRCODE_FEATURE_NOT_SUPPORTED associated error messages
0A005 ERRCODE_PLAN_TO_SQL_NOT_SUPPORTED associated error messages
Class 0B—Invalid Transaction Initiation
0B000 ERRCODE_INVALID_TRANSACTION_INITIATION associated error messages
Class 0F—Locator Exception
0F000 ERRCODE_LOCATOR_EXCEPTION  
0F001 ERRCODE_L_E_INVALID_SPECIFICATION  
Class 0L—Invalid Grantor
0L000 ERRCODE_INVALID_GRANTOR  
0LV01 ERRCODE_INVALID_GRANT_OPERATION associated error messages
Class 0P—Invalid Role Specification
0P000 ERRCODE_INVALID_ROLE_SPECIFICATION  
Class 21—Cardinality Violation
21000 ERRCODE_CARDINALITY_VIOLATION  
Class 22—Data Exception
22000 ERRCODE_DATA_EXCEPTION associated error messages
22001 ERRCODE_STRING_DATA_RIGHT_TRUNCATION associated error messages
22002 ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER  
22003 ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE associated error messages
22004 ERRCODE_NULL_VALUE_NOT_ALLOWED associated error messages
22005 ERRCODE_ERROR_IN_ASSIGNMENT  
22007 ERRCODE_INVALID_DATETIME_FORMAT associated error messages
22008 ERRCODE_DATETIME_FIELD_OVERFLOW associated error messages
22009 ERRCODE_INVALID_TIME_ZONE_DISPLACEMENT_VALUE associated error messages
2200B ERRCODE_ESCAPE_CHARACTER_CONFLICT associated error messages
2200C ERRCODE_INVALID_USE_OF_ESCAPE_CHARACTER  
2200D ERRCODE_INVALID_ESCAPE_OCTET associated error messages
2200F ERRCODE_ZERO_LENGTH_CHARACTER_STRING  
2200G ERRCODE_MOST_SPECIFIC_TYPE_MISMATCH  
22010 ERRCODE_INVALID_INDICATOR_PARAMETER_VALUE  
22011 ERRCODE_SUBSTRING_ERROR associated error messages
22012 ERRCODE_DIVISION_BY_ZERO associated error messages
22015 ERRCODE_INTERVAL_FIELD_OVERFLOW associated error messages
22018 ERRCODE_INVALID_CHARACTER_VALUE_FOR_CAST  
22019 ERRCODE_INVALID_ESCAPE_CHARACTER associated error messages
2201B ERRCODE_INVALID_REGULAR_EXPRESSION associated error messages
2201E ERRCODE_INVALID_ARGUMENT_FOR_LOG  
2201F ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION  
2201G ERRCODE_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION associated error messages
22020 ERRCODE_INVALID_LIMIT_VALUE  
22021 ERRCODE_CHARACTER_NOT_IN_REPERTOIRE associated error messages
22022 ERRCODE_INDICATOR_OVERFLOW  
22023 ERRCODE_INVALID_PARAMETER_VALUE associated error messages
22024 ERRCODE_UNTERMINATED_C_STRING  
22025 ERRCODE_INVALID_ESCAPE_SEQUENCE associated error messages
22026 ERRCODE_STRING_DATA_LENGTH_MISMATCH  
22027 ERRCODE_TRIM_ERROR  
2202E ERRCODE_ARRAY_ELEMENT_ERROR  
22906 ERRCODE_NONSTANDARD_USE_OF_ESCAPE_CHARACTER associated error messages
22V01 ERRCODE_FLOATING_POINT_EXCEPTION  
22V02 ERRCODE_INVALID_TEXT_REPRESENTATION associated error messages
22V03 ERRCODE_INVALID_BINARY_REPRESENTATION associated error messages
22V04 ERRCODE_BAD_COPY_FILE_FORMAT associated error messages
22V05 ERRCODE_UNTRANSLATABLE_CHARACTER  
22V0B ERRCODE_ESCAPE_CHARACTER_ON_NOESCAPE associated error messages
22V21 ERRCODE_INVALID_EPOCH associated error messages
22V22 ERRCODE_PLPGSQL_ERROR  
22V23 ERRCODE_RAISE_EXCEPTION associated error messages
22V24 ERRCODE_COPY_PARSE_ERROR associated error messages
Class 23—Integrity Constraint Violation
23000 ERRCODE_INTEGRITY_CONSTRAINT_VIOLATION  
23001 ERRCODE_RESTRICT_VIOLATION  
23502 ERRCODE_NOT_NULL_VIOLATION associated error messages
23503 ERRCODE_FOREIGN_KEY_VIOLATION associated error messages
23505 ERRCODE_UNIQUE_VIOLATION associated error messages
23514 ERRCODE_CHECK_VIOLATION associated error messages
Class 24—Invalid Cursor State
24000 ERRCODE_INVALID_CURSOR_STATE  
Class 25—Invalid Transaction State
25000 ERRCODE_INVALID_TRANSACTION_STATE associated error messages
25001 ERRCODE_ACTIVE_SQL_TRANSACTION  
25002 ERRCODE_BRANCH_TRANSACTION_ALREADY_ACTIVE  
25003 ERRCODE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION  
25004 ERRCODE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION  
25005 ERRCODE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION  
25006 ERRCODE_READ_ONLY_SQL_TRANSACTION  
25007 ERRCODE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED  
25008 ERRCODE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL  
25V01 ERRCODE_NO_ACTIVE_SQL_TRANSACTION associated error messages
25V02 ERRCODE_IN_FAILED_SQL_TRANSACTION  
Class 26—Invalid SQL Statement Name
26000 ERRCODE_INVALID_SQL_STATEMENT_NAME  
Class 27—Triggered Data Change Violation
27000 ERRCODE_TRIGGERED_DATA_CHANGE_VIOLATION  
Class 28—Invalid Authorization Specification
28000 ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION associated error messages
28001 ERRCODE_ACCOUNT_LOCKED  
28002 ERRCODE_PASSWORD_EXPIRED  
28003 ERRCODE_PASSWORD_IN_GRACE_PERIOD  
Class 2B—Dependent Privilege Descriptors Still Exist
2B000 ERRCODE_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST  
2BV01 ERRCODE_DEPENDENT_OBJECTS_STILL_EXIST associated error messages
Class 2D—Invalid Transaction Termination
2D000 ERRCODE_INVALID_TRANSACTION_TERMINATION  
Class 2F—SQL Routine Exception
2F000 ERRCODE_SQL_ROUTINE_EXCEPTION  
2F002 ERRCODE_S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED  
2F003 ERRCODE_S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED  
2F004 ERRCODE_S_R_E_READING_SQL_DATA_NOT_PERMITTED  
2F005 ERRCODE_S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT  
Class 34—Invalid Cursor Name
34000 ERRCODE_INVALID_CURSOR_NAME  
Class 38—External Routine Exception
38000 ERRCODE_EXTERNAL_ROUTINE_EXCEPTION  
38001 ERRCODE_E_R_E_CONTAINING_SQL_NOT_PERMITTED  
38002 ERRCODE_E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED  
38003 ERRCODE_E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED  
38004 ERRCODE_E_R_E_READING_SQL_DATA_NOT_PERMITTED associated error messages
Class 39—External Routine Invocation Exception
39000 ERRCODE_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION  
39001 ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED  
39004 ERRCODE_E_R_I_E_NULL_VALUE_NOT_ALLOWED  
39V01 ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED  
39V02 ERRCODE_E_R_I_E_SRF_PROTOCOL_VIOLATED  
Class 3B—Savepoint Exception
3B000 ERRCODE_SAVEPOINT_EXCEPTION  
3B001 ERRCODE_S_E_INVALID_SPECIFICATION  
Class 3D—Invalid Catalog Name
3D000 ERRCODE_INVALID_CATALOG_NAME  
Class 3F—Invalid Schema Name
3F000 ERRCODE_INVALID_SCHEMA_NAME  
Class 40—Transaction Rollback
40000 ERRCODE_TRANSACTION_ROLLBACK  
40001 ERRCODE_T_R_SERIALIZATION_FAILURE  
40002 ERRCODE_T_R_INTEGRITY_CONSTRAINT_VIOLATION  
40003 ERRCODE_T_R_STATEMENT_COMPLETION_UNKNOWN  
40V01 ERRCODE_T_R_DEADLOCK_DETECTED associated error messages
Class 42—Syntax Error or Access Rule Violation
42000 ERRCODE_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION  
42501 ERRCODE_INSUFFICIENT_PRIVILEGE associated error messages
42601 ERRCODE_SYNTAX_ERROR associated error messages
42602 ERRCODE_INVALID_NAME associated error messages
42611 ERRCODE_INVALID_COLUMN_DEFINITION associated error messages
42622 ERRCODE_NAME_TOO_LONG associated error messages
42701 ERRCODE_DUPLICATE_COLUMN associated error messages
42702 ERRCODE_AMBIGUOUS_COLUMN associated error messages
42703 ERRCODE_UNDEFINED_COLUMN associated error messages
42704 ERRCODE_UNDEFINED_OBJECT associated error messages
42710 ERRCODE_DUPLICATE_OBJECT associated error messages
42712 ERRCODE_DUPLICATE_ALIAS associated error messages
42723 ERRCODE_DUPLICATE_FUNCTION associated error messages
42725 ERRCODE_AMBIGUOUS_FUNCTION associated error messages
42803 ERRCODE_GROUPING_ERROR associated error messages
42804 ERRCODE_DATATYPE_MISMATCH associated error messages
42809 ERRCODE_WRONG_OBJECT_TYPE associated error messages
42830 ERRCODE_INVALID_FOREIGN_KEY associated error messages
42846 ERRCODE_CANNOT_COERCE associated error messages
42883 ERRCODE_UNDEFINED_FUNCTION associated error messages
42939 ERRCODE_RESERVED_NAME associated error messages
42P20 ERRCODE_WINDOWING_ERROR associated error messages
42V01 ERRCODE_UNDEFINED_TABLE associated error messages
42V02 ERRCODE_UNDEFINED_PARAMETER associated error messages
42V03 ERRCODE_DUPLICATE_CURSOR associated error messages
42V04 ERRCODE_DUPLICATE_DATABASE associated error messages
42V05 ERRCODE_DUPLICATE_PSTATEMENT  
42V06 ERRCODE_DUPLICATE_SCHEMA associated error messages
42V07 ERRCODE_DUPLICATE_TABLE associated error messages
42V08 ERRCODE_AMBIGUOUS_PARAMETER associated error messages
42V09 ERRCODE_AMBIGUOUS_ALIAS associated error messages
42V10 ERRCODE_INVALID_COLUMN_REFERENCE associated error messages
42V11 ERRCODE_INVALID_CURSOR_DEFINITION associated error messages
42V12 ERRCODE_INVALID_DATABASE_DEFINITION  
42V13 ERRCODE_INVALID_FUNCTION_DEFINITION associated error messages
42V14 ERRCODE_INVALID_PSTATEMENT_DEFINITION  
42V15 ERRCODE_INVALID_SCHEMA_DEFINITION associated error messages
42V16 ERRCODE_INVALID_TABLE_DEFINITION associated error messages
42V17 ERRCODE_INVALID_OBJECT_DEFINITION associated error messages
42V18 ERRCODE_INDETERMINATE_DATATYPE associated error messages
42V21 ERRCODE_UNDEFINED_PROJECTION associated error messages
42V22 ERRCODE_UNDEFINED_NODE associated error messages
42V23 ERRCODE_UNDEFINED_PERMUTATION  
42V24 ERRCODE_UNDEFINED_USER associated error messages
42V25 ERRCODE_PATTERN_MATCH_ERROR associated error messages
42V26 ERRCODE_DUPLICATE_NODE associated error messages
Class 44—WITH CHECK OPTION Violation
44000 ERRCODE_WITH_CHECK_OPTION_VIOLATION  
Class 53—Insufficient Resources
53000 ERRCODE_INSUFFICIENT_RESOURCES associated error messages
53100 ERRCODE_DISK_FULL associated error messages
53200 ERRCODE_OUT_OF_MEMORY associated error messages
53300 ERRCODE_TOO_MANY_CONNECTIONS  
Class 54—Program Limit Exceeded
54000 ERRCODE_PROGRAM_LIMIT_EXCEEDED associated error messages
54001 ERRCODE_STATEMENT_TOO_COMPLEX associated error messages
54011 ERRCODE_TOO_MANY_COLUMNS associated error messages
54023 ERRCODE_TOO_MANY_ARGUMENTS associated error messages
Class 55—Object Not In Prerequisite State
55000 ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE associated error messages
55006 ERRCODE_OBJECT_IN_USE associated error messages
55V02 ERRCODE_CANT_CHANGE_RUNTIME_PARAM associated error messages
55V03 ERRCODE_LOCK_NOT_AVAILABLE associated error messages
55V04 ERRCODE_TM_MARKER_NOT_AVAILABLE associated error messages
Class 57—Operator Intervention
57000 ERRCODE_OPERATOR_INTERVENTION  
57014 ERRCODE_QUERY_CANCELED associated error messages
57015 ERRCODE_SLOW_DELETE associated error messages
57V01 ERRCODE_ADMIN_SHUTDOWN associated error messages
57V02 ERRCODE_CRASH_SHUTDOWN  
57V03 ERRCODE_CANNOT_CONNECT_NOW associated error messages
57V04 ERRCODE_DML_COMMIT_DURING_SHUTDOWN associated error messages
Class 58—System Error
58030 ERRCODE_IO_ERROR associated error messages
58V01 ERRCODE_UNDEFINED_FILE associated error messages
58V02 ERRCODE_DUPLICATE_FILE  
Class V1—Vertica-specific multi-node errors class
V1001 ERRCODE_LOST_CONNECTIVITY associated error messages
V1002 ERRCODE_K_SAFETY_VIOLATION associated error messages
V1003 ERRCODE_CLUSTER_CHANGE associated error messages
Class V2—Vertica-specific miscellaneous errors class
V2000 ERRCODE_AUTH_FAILED associated error messages
V2001 ERRCODE_LICENSE_ISSUE associated error messages
V2002 ERRCODE_MOVEOUT_ABORTED  
Class VC—Configuration File Error
VC001 ERRCODE_CONFIG_FILE_ERROR associated error messages
VC002 ERRCODE_LOCK_FILE_EXISTS  
Class VD—DB Designer errors
VD001 ERRCODE_DESIGNER_FUNCTION_ERROR associated error messages
Class VP—User procedure errors
VP000 ERRCODE_USER_PROC_ERROR associated error messages
VP001 ERRCODE_USER_PROC_EXEC_ERROR associated error messages
Class VX—Internal Error
VX001 ERRCODE_INTERNAL_ERROR associated error messages
VX002 ERRCODE_DATA_CORRUPTED associated error messages
VX003 ERRCODE_INDEX_CORRUPTED associated error messages
VX004 ERRCODE_PLAN_TO_SQL_INTERNAL_EROR associated error messages