HANA SQL Error Message (295 – 660)

The following table lists error codes and their descriptions for the SAP HANA database. Please refer to SAP Note 2658020 – List of SAP HANA SQL Error Codes.

Code Type Description
295ERR_SQL_LONG_MULTIKEYtoo long multi key length
296ERR_SQL_REP_TABLE_KEYreplicated table must have a primary key
297ERR_SQL_REP_UPDATE_KEYcannot update primary key field in replicated table
298ERR_SQL_NOT_DDL_STOREcannot store DDL
299ERR_SQL_NOT_DROP_SYSIDXcannot drop index used for enforcement of unique/primary key
300ERR_SQL_ARG_OUT_OF_RANGEargument index is out of range
301ERR_SQL_UNIQUE_VIOLATEDunique constraint violated
302ERR_SQL_INV_CHAR_VALinvalid CHAR or VARCHAR value
303ERR_SQL_INV_DATETIME_VALinvalid DATE TIME or TIMESTAMP value
304ERR_SQL_DIV_BY_ZEROdivision by zero undefined
305ERR_SQL_SINGLE_ROWsingle-row query returns more than one row
306ERR_SQL_INV_CURSORinvalid cursor
307ERR_SQL_NUM_OUT_OF_RANGEnumeric value out of range
308ERR_SQL_EXST_COLUMNcolumn name already exists
309ERR_SQL_SUBQ_TOP_ORDERBYcorrelated subquery cannot have TOP or ORDER BY
310ERR_SQL_IN_PROCsql error in procedure
311ERR_SQL_DROP_ALL_COLUMNScannot drop all columns in a table
312ERR_SQL_SEQ_EXHAUSTsequence is exhausted
313ERR_SQL_INV_SEQinvalid sequence
314ERR_SQL_OVERFLOW_NUMERICnumeric overflow
315ERR_SQL_INV_SYNONYMinvalid synonym
316ERR_SQL_INV_NUM_ARG_FUNCwrong number of arguments in function invocation
317ERR_SQL_NOT_MATCH_PLAN_TABLE"P_QUERYPLANS" not exists nor valid format
318ERR_SQL_DECIMAL_PRECISIONdecimal precision specifier is out of range
319ERR_SQL_DECIMAL_SCALEdecimal scale specifier is out of range
320ERR_SQL_LOB_INDEXcannot create index on expression with datatype LOB
321ERR_SQL_INV_VIEWinvalid view name
322ERR_SQL_EXST_VIEWcannot use duplicate view name
323ERR_SQL_REP_DPLC_IDduplicate replication id
324ERR_SQL_EXST_SEQcannot use duplicate sequence name
325ERR_SQL_ESC_SEQinvalid escape sequence
326ERR_SQL_SEQ_CURRVALCURRVAL of given sequence is not yet defined in this session
327ERR_SQL_CANNOT_EXPLAINcannot explain plan of given statement
328ERR_SQL_INV_FUNC_PROCinvalid name of function or procedure
329ERR_SQL_EXST_FUNC_PROCcannot use duplicate name of function or procedure
330ERR_SQL_EXST_SYNONYMcannot use duplicate synonym name
331ERR_SQL_EXST_USERuser name already exists
332ERR_SQL_INV_USERinvalid user name
333ERR_SQL_COLUMN_NOT_ALLOWED_HEREcolumn not allowed
334ERR_SQL_INV_PRIVinvalid user privilege
335ERR_SQL_EXST_ALIASfield alias name already exists
336ERR_SQL_INV_DEFAULTinvalid default value
337ERR_SQL_INTO_NOT_ALLOWEDINTO clause not allowed for this SELECT statement
338ERR_SQL_ZERO_LEN_NOT_ALLOWEDzero-length columns are not allowed
339ERR_SQL_INV_NUMBERinvalid number
340ERR_SQL_VAR_NOT_BOUNDnot all variables bound
341ERR_SQL_UNDERFLOW_NUMERICnumeric underflow
342ERR_SQL_COLLATE_CONFLICTcollation conflict
343ERR_SQL_INV_COLLATE_NAMEinvalid collate name
344ERR_SQL_LOADER_PARSEparse error in data loader
345ERR_SQL_NOT_REP_TABLEnot a replication table
346ERR_SQL_INV_REP_IDinvalid replication id
347ERR_SQL_INV_OPTIONinvalid option in monitor
348ERR_SQL_INV_DATETIME_FORMATinvalid datetime format
349ERR_SQL_CREATE_UNIQUE_INDEXcannot CREATE UNIQUE INDEX; duplicate key found
350ERR_SQL_DROP_COL_PRIMARY_KEYcannot drop columns in the primary-key column list
351ERR_SQL_DROP_MULTI_COL_UNIQUEcolumn is referenced in a multi-column constraint
352ERR_SQL_CREATE_UNIQUE_INDEX_ON_CDX_TABcannot create unique index on cdx table
353ERR_SQL_EXST_UPDATE_LOG_GROUPupdate log group name already exists
354ERR_SQL_INV_UPDATE_LOG_GROUP_NAMEinvalid update log group name
355ERR_SQL_UPDATE_LOG_TABLE_KEYthe base table of the update log table must have a primary key
356ERR_SQL_MAX_UPDATE_LOG_GROUPexceed maximum number of update log group
357ERR_SQL_BASE_TABLE_ALREADY_HAS_ULTthe base table already has a update log table
358ERR_SQL_ULT_CAN_NOT_HAVE_ULTupdate log table can not have a update log table
359ERR_SQL_STR_LENGTH_TOO_LARGEstring is too long
360ERR_SQL_VIEW_CHECK_VIOLATIONview WITH CHECK OPTION where-clause violation
361ERR_SQL_VIEW_UPDATE_VIOLATIONdata manipulation operation not legal on this view
362ERR_SQL_INV_SCHEMAinvalid schema name
363ERR_SQL_MAX_NUM_INDEX_COLUMNnumber of index columns exceeds its maximum
364ERR_SQL_INV_PARTIAL_KEY_SIZEinvalid partial key size
365ERR_SQL_NO_MATCHING_UNIQUE_OR_PRIMARY_KEYno matching primary key for this column list
366ERR_SQL_NO_PRIMARY_KEYreferenced table does not have a primary key
367ERR_SQL_MISMATCH_OF_COLUMN_NUMBERSnumber of referencing columns must match referenced columns
368ERR_SQL_TEMP_TABLE_WITH_UNIQUEunique constraint not allowed on temporary table
369ERR_SQL_MAX_VIEW_DEPTHexceed maximum view depth limit
370ERR_SQL_DIRECT_INSERT_WITH_UNIQUE_INDEXcannot perform DIRECT INSERT operation on table with unique indexes
371ERR_SQL_XML_PARSEinvalid XML document
372ERR_SQL_XPATH_PARSEinvalid XPATH
373ERR_SQL_INV_XML_DURATIONinvalid XML duration value
374ERR_SQL_INV_XML_FUNCTIONinvalid XML function usage
375ERR_SQL_INV_XML_INDEX_OPERATIONinvalid XML index operation
376ERR_SQL_PYTHONPython buildin procedure error
377ERR_SQL_JITJIT operation error
378ERR_SQL_INV_COLUMN_VIEWinvalid column view
379ERR_SQL_TABLE_SCHEMA_MISMATCHtable schema mismatch
380ERR_SQL_RUN_LEVEL_CHANGEfail to change run level
381ERR_SQL_RESTARTfail to restart
382ERR_SQL_COLLECT_ALL_VERSIONSfail to collect all version garbage
383ERR_SQL_INV_IDENTIFIERinvalid identifier
384ERR_SQL_TOO_LONG_CONSTANTstring is too long
385ERR_SQL_RESTORE_SESSIONcould not restore session
386ERR_SQL_EXST_SCHEMAcannot use duplicate schema name
387ERR_SQL_AMBG_TABLEtable ambiguously defined
388ERR_SQL_EXST_ROLErole already exists
389ERR_SQL_INV_ROLEinvalid role name
390ERR_SQL_INV_USERTYPEinvalid user type
391ERR_SQL_INV_USABLE_VIEWinvalidated view
392ERR_SQL_CYCLIC_ROLEScan't assign cyclic role
393ERR_SQL_NO_GRANT_OPTION_FOR_ROLEroles must not receive a privilege with grant option
394ERR_SQL_CANT_REVOKE_ROLEerror revoking role
395ERR_SQL_INV_USER_DEFINED_TYPEinvalid user-defined type name
396ERR_SQL_EXST_USER_DEFINED_TYPEcannot use duplicate user-defined type name
397ERR_SQL_INV_OBJ_NAMEinvalid object name
398ERR_SQL_MANY_ORDER_BYcannot have more than one order by
399ERR_SQL_TOO_DEEP_ROLE_TREErole tree too deep
400ERR_SQL_INSERT_ONLY_TABLE_WITH_PRIMARY_KEYprimary key not allowed on insert-only table
401ERR_SQL_INSERT_ONLY_TABLE_WITH_UNIQUEunique constraint not allowed on insert-only table
402ERR_SQL_DROPPED_USERthe user was already dropped before query execution
403ERR_SQL_INTERNAL_ERRORinternal error
404ERR_SQL_INV_STRUCTURED_PRIVILEGE_NAMEinvalid (non-existent) structured privilege name
405ERR_SQL_DUP_STRUCTURED_PRIVILEGE_NAMEcannot use duplicate structured privilege name
406ERR_SQL_CANT_UPDATE_GEN_COLINSERT UPDATE and UPSERT are disallowed on the generated field
407ERR_SQL_INV_DATE_FORMATinvalid date format
408ERR_SQL_PASS_OR_PARAMETER_NEEDEDpassword or parameter required for user
409ERR_SQL_TOO_MANY_PARAMETER_VALUESmultiple values for a parameter not supported
410ERR_SQL_INV_PRIVILEGE_NAMESPACEinvalid privilege namespace
411ERR_SQL_INV_TABLE_TYPEinvalid table type
412ERR_SQL_INV_PASSWORD_LAYOUTinvalid password layout
413ERR_SQL_PASSWORD_REUSEDlast n passwords can not be reused
414ERR_SQL_ALTER_PASSWORD_NEEDEDuser is forced to change password
415ERR_SQL_USER_DEACTIVATEDuser is deactivated
416ERR_SQL_USER_LOCKEDuser is locked; try again later
417ERR_SQL_CANT_DROP_WITHOUT_CASCADEcan't drop without CASCADE specification
418ERR_SQL_INV_VIEW_QUERYinvalid view query for creation
419ERR_SQL_CANT_DROP_WITH_RESTRICTcan't drop with RESTRICT specification
420ERR_SQL_ALTER_PASSWORD_NOT_ALLOWEDpassword change currently not allowed
421ERR_SQL_FULLTEXT_INDEXcannot create fulltext index
422ERR_SQL_MIXED_PRIVILEGE_NAMESPACESprivileges must be either all SQL or all from one namespace
423ERR_SQL_LVCAFL error
424ERR_SQL_INV_PACKAGEinvalid name of package
425ERR_SQL_EXST_PACKAGEduplicate package name
426ERR_SQL_NUM_COLUMN_MISMATCHnumber of columns mismatch
427ERR_SQL_CANT_RESERVE_INDEX_IDcan not reserve index id any more
428ERR_INV_QUERY_PLAN_IDinvalid query plan id
429ERR_SQL_INTEGRITY_CHECK_FAILEDintegrity check failed
430ERR_SQL_INV_USABLE_PROCinvalidated procedure
431WRN_SQL_NEARLY_EXPIRED_PASSWORDuser's password will expire within few days
432WRN_SQL_DEPRECATED_SYNTAXthis syntax has been deprecated and will be removed in next release
433ERR_SQL_NOT_NULL_CONSTRAINTnull value found
434ERR_SQL_INV_OBJECTinvalid object ID
435ERR_SQL_INV_EXPinvalid expression
436ERR_SQL_SET_SYSTEM_LICENSEcould not set system license
437ERR_SQL_ONLY_LICENSE_HANDLINGonly commands for license handling are allowed in current state
438ERR_SQL_INVALID_USER_PARAMETER_VALUEinvalid user parameter value
439ERR_SQL_COMPOSITE_ERRORcomposite error
440ERR_SQL_TABLE_TYPE_CONVERSION_ERRORtable type conversion error
441WRN_SQL_DEPRECATED_FEATUREthis feature has been deprecated and will be removed in next release
442ERR_SQL_MAX_NUM_COLUMNnumber of columns exceeds its maximum
443ERR_SQL_INV_CALC_SCENARIOinvalid calculation scenario name
444ERR_SQL_PACKMANpackage manager error
445ERR_SQL_INV_TRIGGERinvalid trigger name
446ERR_SQL_EXST_TRIGGERcannot use duplicate trigger name
447ERR_SQL_BACKUP_FAILEDbackup could not be completed
448ERR_SQL_RECOVERY_FAILEDrecovery could not be completed
449ERR_SQL_RECOVERY_STRATEGYrecovery strategy could not be determined
450ERR_SQL_UNSET_SYSTEM_LICENSEfailed to unset system license
451ERR_SQL_NOT_ALLOWED_SUBJ_TAB_ACCESS_TRIGGERmodification of subject table in trigger not allowed
452ERR_SQL_INV_BACKUPIDinvalid backup id
453ERR_SQL_USER_WITHOUT_PASSWORDuser does not have a password
454WRN_SQL_WRONG_HINT_SYNTAXwrong hint syntax
455ERR_SQL_READ_ONLY_SESSION_VARIABLEthe predefined session variable cannot be set via SET command
456ERR_SQL_NOT_ALLOWED_FOR_SPECIAL_ROLEnot allowed for this role
457ERR_SQL_DPLC_CONSTRAINTduplicate constraint name
458ERR_SQL_UNSUPPORTED_FUNCTIONunsupported function included
459ERR_SQL_INV_USABLE_FUNCinvalidated function
460ERR_SQL_INV_PRIVILEGE_FOR_OBJECTinvalid privilege for object
461ERR_SQL_FK_NOT_FOUNDforeign key constraint violation
462ERR_SQL_FK_ON_UPDATE_DELETE_FAILEDfailed on update or delete by foreign key constraint violation
463ERR_SQL_MAX_NUM_TABLEnumber of tables exceeds its maximum
464ERR_SQL_MAX_PARSE_TREE_DEPTHSQL internal parse tree depth exceeds its maximum
465ERR_SQL_INV_USABLE_TRIGGERCannot execute trigger was invalidated by object change
466ERR_SQL_CREDENTIAL_NOT_FOUNDno credential found
467ERR_SQL_PARAM_VARIABLEcannot use parameter variable
468ERR_SQL_HINThint error
469ERR_SQL_INV_SRC_DATATYPEunsupported datatype on source consider using a view
470ERR_SQL_INV_DATA_SOURCE_CONFinvalid data source configuration
471ERR_SQL_INV_DATA_SOURCEinvalid data source name
472ERR_SQL_EXST_DATA_SOURCEcannot use duplicate data source name
473ERR_SQL_ADAPTER_CONFIGURATIONinvalid adapter configuration
474ERR_SQL_INV_ADAPTERinvalid adapter name
475ERR_SQL_EXST_ADAPTERcannot use duplicate adapter name
476ERR_SQL_INV_REMOTE_OBJECTinvalid remote object name
477ERR_SQL_CREDENTIAL_EXISTScredential exists
478ERR_SQL_UDF_RUNTIMEuser defined function runtime error
479ERR_SQL_INV_SPATIAL_ATTRIBUTEinvalid spatial attribute
480ERR_SQL_INV_SPATIAL_UNITinvalid spatial unit of measure name
481ERR_SQL_EXST_SPATIAL_UNITcannot use duplicate spatial unit of measure name
482ERR_SQL_INV_SPATIAL_REF_SYSinvalid spatial reference system name
483ERR_SQL_EXST_SPATIAL_REF_SYScannot use duplicate spatial reference system name
484ERR_SQL_SESSION_GROUP_COMMAND_FAILUREinvalid session group command
485ERR_SQL_INV_STRUCTURED_PRIVILEGE_DEFINITIONinvalid definition of structured privilege
486WRN_SQL_IMPORT_PARTIALLY_FAILEDsome of rows have failed to be imported
487ERR_SQL_IMPORT_PARTIALLY_FAILEDsome of rows have failed to be imported
488ERR_SQL_INV_DATABASEinvalid database name
489ERR_SQL_INV_EPMMODELinvalid EPM Model name
490ERR_SQL_EXST_EPMMODELcannot use duplicate EPM Model name
491ERR_SQL_INV_EPMMODEL_DEFinvalid EPM Model definition
492ERR_SQL_INV_EPMQUERYSOURCEinvalid EPM Query Source name
493ERR_SQL_EXST_EPMQUERYSOURCEcannot use duplicate EPM Query Source name
494ERR_SQL_INV_EPMQUERYSOURCE_DEFinvalid EPM Query Source definition
495ERROR_SQL_INVALID_CONV_TO_EXTENDEDTable already Extended with right delta option
496ERROR_SQL_INVALID_CONV_FROM_EXTENDEDTable already Non-Extended
497ERROR_EXTENDED_STORAGE_NOT_FOUNDExtended Storage not found for table:
498ERR_SQL_IMPORT_FAIL_ON_MAX_RECORD_SIZE_CHECKMemory for a record exceeds the limit
499ERR_SQL_INV_C2Cinvalid stacked column search
500ERR_SQL_REQUIRE_PREDICATEpredicates are required in a where clause
501ERR_SQL_SERIES_INVALID_SPECInvalid series data specification:
502ERR_SQL_INV_TASKinvalid name of task
503ERR_SQL_EXST_TASKcannot use duplicate name of task
504ERR_SQL_INV_ADAPTER_LOCATIONinvalid adapter location
505ERR_SQL_LAST_ADAPTER_LOCATIONcannot remove last location of adapter use DROP ADAPTER statement
506ERR_SQL_SYSTEM_ADAPTERinvalid create alter or drop system adapter
507ERR_SQL_INV_AGENTinvalid agent name
508ERR_SQL_EXST_AGENTcannot use duplicate agent name
509ERR_SQL_INV_AGENT_PROPSinvalid agent properties
510ERR_SQL_TEMP_TABLE_IN_USEcannot alter global temporary table in use or create/alter/drop index on the table
512ERR_REPreplication error
513ERR_SQL_REP_ALREADY_ACTIVEcannot execute DDL statement on replication table while replicating
514FATAL_REP_ANCHOR_FILE_FAILfailure in accessing anchor file
515FATAL_REP_LOG_FILE_FAILfailure in accessing log file
516ERR_REP_TABLE_HAVE_NOT_REPORT_TABLEreplication table has not conflict report table
517ERR_REPORT_TABLE_ALREADY_ENABLEDconflict report table already enabled
518ERR_REPORT_TABLE_ALREADY_DISABLEDconflict report table already disabled
544ERR_RS_PARTITIONpartition error
545ERR_RS_PARTITION_INVALID_SPECinvalid partition spec
576ERR_APIapi error
577ERR_API_NO_CURSOR_FWDcursor type of forward is not allowed
578ERR_API_INV_STATEMENTinvalid statement
579ERR_API_EXCEED_MAX_GROUP_SIZEexceed maximum batch size
580ERR_API_VERSION_INCOMPATIBLEServer rejected the connection(protocol version mismatch)
581ERR_API_ONLY_SINGLE_STATEMENTthis function can be called only in the case of single statement
582ERR_API_INV_RETURN_OBJECTthis query does not have result set
583ERR_API_CONNECTION_DOES_NOT_EXISTconnection does not exist
584ERR_API_NO_MORE_LOB_DATANo more LOB data
585ERR_API_OPERATION_NOT_PERMITTEDoperation is not permitted
586ERR_API_INV_PARAMETER_FROM_SERVERinvalid parameter is received from server
587ERR_API_INV_RESULTSETresult set is currently invalid
588ERR_API_RESULTSET_NEXT_NOT_CALLEDnext() is not called for this result set
589ERR_API_TOO_MANY_PARAMETERStoo many parameters are set
590ERR_API_MISSING_PARAMETERsome paramters are missing
591ERR_API_INTERNAL_ERRORinternal error
592ERR_API_NOT_SUPPORTED_TYPECONVnot supported type conversion
593ERR_API_REMOTE_ONLYremote-only function
594ERR_API_NO_MORE_RESULT_ROWno more result row in result set
595ERR_API_NOT_OUT_PARAMSpecified parameter is not output parameter
596ERR_API_LOB_STREAM_NOT_PERMITTEDLOB streaming is not permitted in auto-commit mode
597ERR_API_SESSION_CONTEXT_ERRORsession context error
598ERR_API_EXTERNAL_EXECUTION_FAILUREfailed to execute the external statement
599ERR_API_NOT_INITIALIZEDsession layer is not initialized yet
600ERR_API_CALL_ROUTING_FAILUREfailed routed execution
601ERR_API_TOO_MANY_SESSION_VARIABLEStoo many session variables are set
602ERR_API_READONLY_SESSION_VARIABLEcannot set read-only session variable
603ERR_API_INV_LOBinvalid LOB
604ERR_API_REMOTE_TEMP_TABLEremote temp table access failure
605ERR_API_INV_XA_JOINinvalid xa join request
606ERR_API_EXCEED_MAX_LOB_SIZEexceed maximum LOB size
607ERR_API_CLEANUP_RESOURCEfailed to cleanup resources
608ERR_API_EXCEED_MAX_PREPARED_STATEMENTexceed maximum number of prepared statements
609ERR_API_INVALID_CESU8_STRINGinvalid CESU-8 string
610ERR_API_ROLLBACK_FAILUREtransaction rollback failure
611ERR_API_SESSION_VARIABLE_VALUE_LENGTH_EXCEEDEDmaximum length of value for session variable exceeded
612ERR_API_SESSION_VARIABLE_KEY_LENGTH_EXCEEDEDmaximum length of key for session variable exceeded
613ERR_API_TIMEOUTexecution aborted by timeout
614ERR_API_ACCESS_ENCRYPTED_DATAencrypted data access is not permitted
615ERR_API_REMOTE_CONNECTION_DOES_NOT_EXISTremote connection does not exist
640ERR_SQL_2sql processing error
641ERR_SQL_INV_REMOTE_SUBSCRIPTIONinvalid remote subscription name
642ERR_SQL_EXST_REMOTE_SUBSCRIPTIONcannot use duplicate remote subscription name
643ERR_SQL_INV_REMOTE_SUBSCRIPTION_DEFinvalid remote subscription definition
644ERR_SQL_EXST_REMOTE_SOURCE_ADAPTER_LOCATIONremote source refers to the adapter location
645ERR_SQL_EXST_REMOTE_SOURCE_ACTIVE_SUBSCRIPTIONSremote source has active remote subscriptions:
646ERR_SQL_INV_USABLE_TASKinvalidated task
647ERR_SQL_NOT_ALLOWED_SYNTAX_FOR_TRIGGERnot supported syntax in trigger
648ERR_SQL_TRIGGER_AND_PROC_NESTING_DEPTH_EXCEEDEDnesting depth of trigger and procedure is exceeded
649ERR_SQL_QUERY_PINNED_PLANPinned plan error
650ERR_SQL_QUERY_REMOVE_PINNED_PLANRemove pinned plan error
651ERR_SQL_EXST_OBJECTcannot use duplicate object name
652ERR_SQL_AMBG_SCHEMAschema ambiguously defined
653ERR_SQL_SET_ROW_ORDERrow order already set on table
654ERR_SQL_NO_ROW_ORDERno row order on table set
655ERR_SQL_LICENSING_RUNTIMElicensing error
656ERR_SQL_LONG_PROPERTYproperty value too long
657ERR_SQL_CANCEL_TASK_TIMEOUT_REACHEDrequest to cancel task was sent but task did not cancel before timeout was reached
658ERR_SQL_CANNOT_MUTATE_TABLE_DURING_FK_EXECUTIONcannot mutate the table during trigger or foreign key execution
659ERR_SQL_EXST_WORKLOAD_CLASScannot use duplicate workload class name
660ERR_SQL_INV_WORKLOAD_CLASSinvalid workload class name

You May Also Like

Leave a Reply?