Error Messages Associated with SQLSTATE 55000

This topic lists the errors associated with the SQLSTATE 55000.

SQLSTATE 55000 Description

ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE

Error messages associated with this SQLState

ERROR 2088: A concurrent load into the partition or a concurrent mergeout operation interfered with this statement
ERROR 2143: AHM advanced beyond snapshot epoch
ERROR 2149: AHM can't be set
ERROR 2150: AHM can't be set while retentive refresh is running
ERROR 2151: AHM can't be set. (value nodes are down, out of value.)
ERROR 2152: AHM can't be set. (value nodes are down.)
ERROR 2159: All nodes must be UP to rebalance a cluster
ERROR 2163: Already released
ERROR 2175: An error occurred when loading library file on node string, message:
    string
ERROR 2200: AnalyzeStatsPlanMaxColumns configuration parameter 'value' invalid; must be greater than zero
ERROR 2201: AnalyzeStatsSampleBands configuration parameter 'value' invalid; must be greater than zero
ERROR 2241: Attempt to create view using an invalid relation
ERROR 2242: Attempt to run multi-node KV plan
ERROR 2294: CALL_USE_SESSION_NODES used without setting nodes
ERROR 2303: Can not tell if tables have data, too few responses (value) to be conclusive
ERROR 2316: Can't match imported node 'string' to node in current database
ERROR 2371: Cannot commit DML/DDL while a node is shutting down
ERROR 2378: Cannot convert column "string" to type "string"
ERROR 2380: Cannot create a library without an initialized LibraryPath on node: string
ERROR 2388: Cannot create projections on a temporary table that has data
ERROR 2409: Cannot drop any more columns in string
ERROR 2410: Cannot drop column "string" since it is referenced in the default expression of column "string"
ERROR 2413: Cannot drop column "string" since it was referenced in the default expression of added column "string"
ERROR 2422: Cannot Drop: string string depends on string string
ERROR 2424: Cannot execute query with temporary table because a node has recovered since the start of this session
ERROR 2448: Cannot issue this command in a read-only transaction
ERROR 2459: Cannot modify temporary table string because a node has recovered or rebalance data took place since the start of this string
ERROR 2483: Cannot remove snapshots without an initialized SnapshotPath
ERROR 2496: Cannot revoke EXECUTE permission from the owner: string
ERROR 2497: Cannot revoke EXECUTE permission from the super user
ERROR 2505: Cannot set column "string" in table "string" to NOT NULL since it contains null values
ERROR 2512: Cannot set memoryCap for session whose current user has been dropped
ERROR 2516: Cannot set runTimeCap for session whose current user has been dropped
ERROR 2517: Cannot set tempSpaceCap for session whose current user has been dropped
ERROR 2541: Cannot use addAny() with any other input column types
ERROR 2542: Cannot use addAny() with any other output column types
ERROR 2563: Cannot validate DV storage
ERROR 2564: Cannot validate storage
ERROR 2587: Changes cannot be made to [string]. It has been retired
ERROR 2762: COPY: Cannot load into IDENTITY column "string"
ERROR 2763: COPY: Cannot specify parsing options for IDENTITY column "string"
ERROR 2903: Could not reset epoch because DML locks are held
ERROR 2904: Could not reset epoch because projections exist
ERROR 2933: Couldn't force partition projection string
ERROR 2934: Couldn't force partition projections string
ERROR 2954: Current phase of recovery failed due to missed event at epoch value
ERROR 2955: Current set of up nodes do not satisfy dependencies
ERROR 2956: Current set of up nodes do not satisfy dependencies for table string
ERROR 2961: Current user has been dropped so no defaults are available
ERROR 2962: Current user has been dropped so no roles are available
ERROR 2969: Cursor can only scan forward
ERROR 3002: DDL statement interfered with alter column type
ERROR 3136: drop_partition failed for string on node string. The projection contains unpartitioned data
ERROR 3196: Error deserializing objects
ERROR 3229: Error loading library file:[string]
ERROR 3254: Error reading from file
ERROR 3278: Error writing to file
ERROR 3318: Execution aborted by node state change
ERROR 3392: Failed to update local min/max objects for column "string"
ERROR 3807: JobTracker::getMarkedStorages(): Unknown job value
ERROR 3808: JobTracker::jobComplete(string): Unknown job value
ERROR 3809: JobTracker::setDetails(value,value,value): Unknown job value
ERROR 3810: JobTracker::setJobDescription(string): Unknown job value
ERROR 3838: Key value already in use
ERROR 3882: Location cannot be dropped as it stores data files
ERROR 3911: maxMemorySize for string can be changed only when the string WOS is empty
ERROR 3924: merge_partitions() failed on string because of unpartitioned data
ERROR 3925: Mergeout failed: projection string is not up-to-date
ERROR 4032: Naming conflict: string exists
ERROR 4092: No plan received at node
ERROR 4120: No transaction running on node
ERROR 4121: No transaction running, does previous load_snapshot_prep succeeded?
ERROR 4127: No valid cache found
ERROR 4138: Node string is not available for queries
ERROR 4144: Node has not been set up for plan execution
ERROR 4146: Node is not active or recovering, cannot plan query
ERROR 4148: Node not prepared to accept plan
ERROR 4151: Node unprepared for rebalance
ERROR 4177: Not enough nodes are up for Projection <string> to be available, marking it as out of date
ERROR 4403: Portal "string" cannot be run
ERROR 4457: Projection string checkpoint epoch lags snapshot epoch
ERROR 4458: Projection string contains data in the WOS
ERROR 4459: Projection string create epoch is greater than the epoch in the query
ERROR 4462: Projection string has HSE > snapshot epoch and buddy string has HSE <= snapshot epoch
ERROR 4464: Projection string is not up-to-date
ERROR 4467: Projection (name: string, oid: value) is newly added during current recovery
ERROR 4485: Projections string contain data in the WOS
ERROR 4530: Rebalance unable to moveout all data on projection string
ERROR 4592: reset_epoch is disabled because the EnableResetEpoch configuration parameter is 0
ERROR 4611: Returned string value '[string]' with length [value] is greater than declared field length of [value] of field [string] at output column index [value]
ERROR 4698: Sequence "string" has been created by an IDENTITY/AUTO_INCREMENT column and cannot be dropped
ERROR 4700: Sequence string has not been accessed in the session
ERROR 4765: Specified K-safety for projection creation is insufficient to support currently down nodes
ERROR 4791: Storage extends beyond specified segment range
ERROR 4793: Stream error: string
ERROR 4860: System is not k-safe. DDL is disallowed
ERROR 4861: System is not k-safe. DDL/DML is disallowed
ERROR 4879: Table "string" has projections in non-up-to-date state
ERROR 4880: Table "string" has projections that are not up-to-date that can refresh from buddy
ERROR 4903: Table or projection no longer exists
ERROR 4934: The attribute "string" in table "string" needs to be included in projection "string" because it is used in the partitioning expression
ERROR 4941: The data type requires length/precision specification
ERROR 4965: The restore violates K safety
ERROR 4972: The types/sizes of source column (index value, length value) and destination column (index value, length value) do not match
ERROR 5084: Tried to add field 'string' that already exists
ERROR 5085: Tried to add unknown node 'string' to user-defined query plan
ERROR 5132: Unable to evaluate the delete performance after dropping this column for projection "string"
ERROR 5151: Unable to validate data in string: string
ERROR 5204: Unknown data type
ERROR 5210: Unknown object: string
ERROR 5321: Usage of [string] cannot be changed. It has been retired
ERROR 5381: User Defined Scalar Function can only have 1 return column, but value is provided
ERROR 5522: A concurrent operation interfered with this statement
ERROR 5534: Can't create table in specified target schema
ERROR 5535: Can't find target table's schema
ERROR 5543: Cannot use column type 'any' with any other input column types
ERROR 5544: Cannot use column type 'any' with any other output column types
ERROR 5568: DVWos can not be moved
ERROR 5583: Fault Group "string" already exists in a fault group
ERROR 5587: Fault Group "string" not found in Fault Group "string"
ERROR 5590: Found value unsegmented projections with basename string; inconsistent with permanent nodes count value
ERROR 5626: Node "string" already exists in a fault group
ERROR 5627: Node "string" not found in Fault Group "string"
ERROR 5660: Source table can not be temp, virtual, system, or external
ERROR 5662: Storage tier string has not been found on all nodes
ERROR 5666: Table "string" has prejoin projections
ERROR 5667: Target table can not be temp, virtual, system, or external
ERROR 5674: TM interfered with this statement
ERROR 5676: Unable to move/swap partitions because some projection(s) contain unpartitioned data
ERROR 5705: Dvmergeout failed: projection string is not up-to-date
ERROR 5712: JobTracker::reportStart: Unknown job value
ERROR 5735: Tier string is referenced by storage policies. Can not make storage location changes as requested
ERROR 5760: Can only change setting when all started nodes are UP
ERROR 5765: Cannot change control node away from self because other nodes depend on this node to be their control node
ERROR 5766: Cannot change final control node away from self until at least one other node is promoted to be a control node
ERROR 5772: Cannot manually alter automatically generated fault groups
ERROR 5786: Column value does not have corresponding storages yet. A concurrent add column operation might be running
ERROR 5883: Failed to list hcatalog tables
ERROR 6001: Recovery failed because DVROS straddles discard epoch
ERROR 6002: Recovery failed because ROS value [0xvalue, 0xvalue] straddles endEpoch value to discard
ERROR 6003: Recovery failed because ROS straddles discard epoch
ERROR 6035: Table "string" has no non-null records under the column key_name
ERROR 6037: Table "string_string" cannot be found or was not created internally
ERROR 6065: Tried to allocate and initialize a value-byte string with value zero bytes; VString is too small
ERROR 6066: Tried to copy a value-byte string to value-byte VString object; VString is too small
ERROR 6105: View "string" is already linked to flex table "string".  Linked views will not be overwritten
ERROR 6106: View "string" is already linked to this table.  Linked views will not be overwritten
ERROR 6107: View "string_string" cannot be found or was not created internally
ERROR 6110: A design/deployment process is currently executing in this design space
ERROR 6121: A concurrent opertation interfered with this statement
ERROR 6176: Cannot replace node string because it is already a STANDBY
ERROR 6177: Cannot replace node string because it is not DOWN
ERROR 6184: Cannot swap partition between same table
ERROR 6185: Cannot transition node string to string because it still has data
ERROR 6186: Cannot transition node string to STANDBY because its loss would cause the cluster to shutdown
ERROR 6207: Could not create internal data-storage directory 'string': value
ERROR 6352: Need to split partitions before move/swap partitions
ERROR 6357: No standby nodes are currently available
ERROR 6359: Node string has not been replaced
ERROR 6360: Node string is a string node and cannot store data
ERROR 6374: Original node string is not currently available in STANDBY mode
ERROR 6419: Table string can not be temp, virtual, system, or external
ERROR 6422: Target node string is a string node, not a STANDBY node
ERROR 6424: Target standby node string is not currently available
ERROR 6446: UDx set BOOLEAN column value to non-boolean value value
ERROR 6478: Can only take object-level snapshot from local storage locations
ERROR 6484: Mergeout failed: ROS(es) have been dropped/moved
ERROR 6524: DDL interfered with this statement. Table is not partitioned or partition expression got changed
ERROR 6553: Compact storage failed: projection string is not up-to-date
ERROR 6554: Compact storage failed: ROS(es) have been dropped/moved
ERROR 6633: An enabled constraint can only be declared on a global temporary table during CREATE TABLE
ERROR 6634: An enabled constraint cannot be created on a temporary table with existing data
ERROR 6646: Attempted to commit when column value has value rows while column 0 has value rows
ERROR 6647: Attempted to use a string as a string
ERROR 6648: Attempted to write past the end of a column
ERROR 6658: Can not string to the same table
ERROR 6665: Can not set priority for text index, please use its source table
ERROR 6667: Can only change setting when lockless recovery is enabled
ERROR 6674: Cannot do object level restore while a node is recovering
ERROR 6675: Cannot drop column "string" since it is the last non-IDENTITY, non-AUTO_INCREMENT column
ERROR 6677: Cannot execute query because table recovery status change
ERROR 6811: Incorrect use of setter in processBlock
ERROR 6812: Incorrect use of setter in processPartition for [value] column
ERROR 6826: Invalid node Oid value
ERROR 6870: Multiple values for the parameter string. The parameter will not be set
ERROR 6937: Restore: Cannot overwrite object string
ERROR 6957: Source items are not the correct encoding for direct copies
ERROR 6958: Source items are not the correct size for direct copies
ERROR 6976: Table "string" has not been recovered. Please try later
ERROR 6982: Table can not be temp, virtual, system, or external
ERROR 6989: Terminate() must be overidden for a User Defined Aggregate
ERROR 6997: The key string doesn't exist
ERROR 7001: The sessionParamReader for namespace 'string' doesn't exist
ERROR 7002: The sessionParamWriter for namespace 'string' doesn't exist
ERROR 7016: UDx set BOOLEAN column value, row value to non-boolean value value
ERROR 7017: Unable to acquire side process info
ERROR 7072: WebHCat query [string] failed: string
ERROR 7093: Comment length of parameter 'string' is 'value' which exceeds the maximum allowed 'value'
ERROR 7096: Failed to rollover MinMaxObj on all nodes
ERROR 7119: Source and target table do not match: string
ERROR 7121: Staging table and target table do not match: string
ERROR 7173: Current set of up nodes do not satisfy dependencies for DFS file distribution value
ERROR 7193: RecoverByContainer::recover can't advance the cpe by recovering containers
ERROR 7212: Cannot restore data to node string
ERROR 7290: Trying to set the column "string" to size of value All data type lengths in table "string" must not be greater than value, the current maximum raw size for flex table values
ERROR 7299: Cannot alter type of column "string" since it is referenced in the default expression of table "string", column "string"
ERROR 7300: Cannot alter type of column "string" since it is referenced in the set using expression of table "string", column "string"
ERROR 7301: Cannot drop column "string" since it is referenced in the default expression of table "string", column "string"
ERROR 7302: Cannot drop column "string" since it is referenced in the set using expression of table "string", column "string"
ERROR 7343: string expression of IDENTITY/AUTO_INCREMENT column "string" cannot be altered
ERROR 7386: Cannot proceed with the revoke. User string would be left without access to a resource pool
ERROR 7390: Cannot set idlesessiontimeout for session whose current user has been dropped
ERROR 7448: Location cannot be dropped as it stores DFS files
ERROR 7458: Mergeout failed: found missed string on table string
ERROR 7537: Sequence "string" has been created by an IDENTITY/AUTO_INCREMENT column and cannot be used in a string expression
ERROR 7583: User or Role value cannot be found
ERROR 7617: SBJobTracker::jobComplete: Unknown projOid "value"
ERROR 7618: SBJobTracker::jobComplete: Unknown txnid "value"
ERROR 7619: SBJobTracker::setAdditionalInfo: Unknown oid "value"
ERROR 7671: Wrong checksum for library file string
ERROR 7766: Cannot drop column "string" since it is referenced in the set using expression of column "string"
ERROR 7811: SendFiles on node string: file [string] has changed
ERROR 7821: Cannot rename user "string" since they use MD5 password format
ERROR 7856: Not all requested nodes are available at this moment
ERROR 7857: Not enough available nodes at this moment
ERROR 7866: DDL statement interfered with this statement. ProjCol value cannot be found
ERROR 7978: Can only use KV hint with SELECT queries
ERROR 7983: Cannot use KV Hint with a subquery
ERROR 8009: Running KV query inside existing transaction. There will be a performance implication. Consider rerunning the query outside of an existing transaction

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