Warning Messages Associated with SQLSTATE 01000

This topic lists the warnings associated with the SQLSTATE 01000.

SQLSTATE 01000 Description

ERRCODE_WARNING

Warning messages associated with this SQLState

WARNING 2021: string Directory for errors files was not created.
     Unable to write errors for this instance of COPY command
WARNING 2022: string Directory for exceptions files was not created.
     Unable to write errors for this instance of COPY command
WARNING 2023: string Directory for rejected data files was not created.
     Unable to write errors for this instance of COPY command
WARNING 2362: Cannot begin transaction; transaction is already running
WARNING 3084: Design couldn't be dropped
WARNING 3152: Duplicate values in columns marked as UNIQUE will now be ignored for the remainder of your session or until reenable_duplicate_key_error() is called
WARNING 3372: Failed to disable profiling: string
WARNING 3373: Failed to enable profiling: string
WARNING 3539: Incorrect results are possible. Please contact Vertica Support if unsure
WARNING 3791: Invalid view string: string
WARNING 4071: NO COMMIT option will be ignored for external table "string"
WARNING 4088: No new valid default roles specified. Retaining previous set of default roles for user string
WARNING 4098: No projections found
WARNING 4102: No rows are inserted into table "string"."string" because ON COMMIT DELETE ROWS is the default for create temporary table
WARNING 4116: No super projections created for table string. 
WARNING 4246: Only GLOBAL scope is supported for clearing string profiles
WARNING 4463: Projection string is not up to date
WARNING 4468: Projection <string> is not available for query processing. Execute the select start_refresh() function to copy data into this projection.
     The projection must have a sufficient number of buddy projections and all nodes must be up before starting a refresh
WARNING 4792: Storage option "string" will be ignored for external table "string"
WARNING 4871: System view string for tuning rule string is currently invalid
WARNING 4873: System view for tuning rule string does not exist
WARNING 4996: This request may deadlock the system.  Please report the details to technical support
WARNING 5068: Total declared length of columns of one of the constraints exceeds the limit, truncation may happen
WARNING 5119: UDx code didn't respond when Vertica tried to get function prototype for string in library string: string
WARNING 5448: View string is currently invalid
WARNING 5451: Violations of some of foreign key constraints may not be reported because of no privilege on the foreign tables
WARNING 5642: Projection string is not persistent or not up to date; it will not be copied
WARNING 5643: Projection string is prejoin projection; it will not be copied
WARNING 5717: No statistics has been exported. Either the DB is empty or you try to export an external table or you do not have access to the available objects
WARNING 5724: Segmentation clause contains a string - data loads may be slowed significantly
WARNING 5727: Sort clause contains a string - data loads may be slowed significantly
WARNING 5741: View string depends on other relations
WARNING 5819: Design could not be reset
WARNING 5821: Detected keys sharing the same case-insensitive key name
WARNING 5860: Due to the data isolation of temp tables with an on-commit-delete-rows policy, the compute_flextable_keys() and compute_flextable_keys_and_build_view() functions cannot access this table's data. The build_flextable_view() function can be used with a user-provided keys table to create a view, but involves a DDL commit which will delete the table's rows
WARNING 5873: Failed to add table string of hcatalog schema string to catalog: string
WARNING 5875: Failed to alter table string of hcatalog schema string to catalog: string
WARNING 5880: Failed to describe table string in hcatalog database string: string
WARNING 5881: Failed to describe table string in schema string: HCatalog database string does not exist
WARNING 5884: Failed to list hcatalog tables of hcatalog schema string: string
WARNING 5886: Failed to mirror table string in schema string: string
WARNING 5909: Found and ignored keys with names longer than the maximum column-name length limit
WARNING 5912: HASH() arguments contain irregular expressions
WARNING 5917: Ignored some keys since the total key count exceeds the view column limit
WARNING 5922: Insufficient privileges to alter table string
WARNING 5923: Insufficient privileges to drop table string
WARNING 5991: Projection basename "string" hint was ignored. "string" is used as the basename
WARNING 5993: Projection is irregularly segmented by column
WARNING 6053: The view creation involved a DDL commit which deleted the table's rows
WARNING 6256: Error while analyzing constraint(s) string on string
WARNING 6257: Error while creating LTT for analyzing constraints on string
WARNING 6356: No partitions have been swapped. Neither table has partitions fall in range
WARNING 6417: Swapped partitions are not immediately moved to a new storage location
WARNING 6515: Projection with name "string" already exists in schema "string" for anchor table "string.string"
WARNING 6565: Inequal query trees produced the same hash code query1:
    string
    query2:
    string
WARNING 6594: Unknown RangeTblEntry:value
WARNING 6608: string is an invalid argument for hint string
WARNING 6765: Error parsing distrib value string in Distrib hint's arguments. The whole hint will be ignored
WARNING 6773: Failed to compare plans for query 'string'
WARNING 6797: Hint string can accept at most one argument, the hint with value arguments is ignored
WARNING 6798: Hint string can be specified only once for each join, if multiple instances listed only the first is considered
WARNING 6799: Hint string is not feasible and will be ignored
WARNING 6801: Hint string requires exactly two arguments, the hint with value arguments is ignored
WARNING 6813: Inherited privileges are globally disabled; schema parameter is set but has no effect
WARNING 6814: Inherited privileges are globally disabled; table parameter is set but has no effect
WARNING 6815: Inherited privileges are globally disabled; view parameter is set but has no effect
WARNING 6818: Input operations specified for Hint string is not feasible and will be ignored
WARNING 6922: Projection name was changed to string because it conflicts with the basename of the table string
WARNING 6990: Text index has invalid tokenizer
WARNING 6991: The active saved plan for this query has incompatible output column set. Continuing with the original query
WARNING 7000: The projection 'string' was used to enforce the enabled key constraint 'string', and may be regenerated to validate a DML statement on the base table
WARNING 7020: Unable to find the following query in the export file: 'string'
WARNING 7030: Unexpected group clause found during query comparison
WARNING 7031: Unexpected group clause found during query hashing
WARNING 7033: Unexpected sort clause found during query comparison
WARNING 7036: Unknown Expr:value during query comparison
WARNING 7037: Unknown Expr:value found
WARNING 7038: Unknown Expr:value found during query hashing
WARNING 7039: Unknown Inequality OpOid:value found during query hashing
WARNING 7040: Unknown Logic OpExpr:value found during query comparison
WARNING 7041: Unknown Logic OpExpr:value found during query hashing
WARNING 7044: Unknown OpExpr:value found during query comparison
WARNING 7045: Unknown OpExpr:value found during query hashing
WARNING 7046: Unknown RangeTblEntry:value found during query comparison
WARNING 7047: Unknown RangeTblEntry:value found during query hashing
WARNING 7048: Unknown Sublink:value found during query comparison
WARNING 7049: Unknown Sublink:value found during query hashing
WARNING 7052: Unsupported JoinExpr Type found during query comparison
WARNING 7053: Unsupported JoinExpr Type found during query hashing
WARNING 7070: View "string" will include privileges from schema "string"
WARNING 7074: You appear to be using an old version of HDFS that may have stability problems under high load. See the Vertica documentation for supported HDFS versions
WARNING 7186: Inherited privileges are globally disabled. Privileges will be materialized and visibility of table string may change
WARNING 7204: Updates on the target table with a prejoin projection might ignore PK constraints and cause data integrity violations
WARNING 7265: Inherited privileges are globally disabled. Privileges will be materialized and visibility of view string may change
WARNING 7709: Could not drop table 'string'. Please remove manually if necessary.
    Detail: string
WARNING 7752: Cannot make a local query plan for "try local" hint, please check hash function, segment quantity, segment boundary, etc
WARNING 7793: The cache will be set to 1 instead
WARNING 7942: Unknown expression found during hashing: value
WARNING 7994: Not converged before max_iterations [value]
WARNING 8012: The parameter [string] is not defined for this function

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