HANA SQL Error Message (1801 – 3849)

Posted by — September 28, 2018 in HANA SQL Error Message — Leave a reply

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
1801ERR_SHM_DROP_REMOVED_ IDENTIFIERshmid points to a removed identifier
1802ERR_SHM_DROP_NO_PERMISSIONthe effective user ID of the calling process is not the creator
1803ERR_SHM_DROP_OVERFLOWthe gid or uid value is too large to be stored in the structure
1804ERR_SHM_ATTACH_NO_ACCESSthe user does not have permission to access the shared memory segment
1805ERR_SHM_ATTACH_INVALIDinvalid shmid
1806ERR_SHM_ATTACH_NO_MORE_ MEMORYno memory could be allocated for the descriptor or for the page tables
1807ERR_SHM_UNKNOWNunknown shared memory error
2048ERR_CScolumn store error
2049ERR_CS_NO_PRIMARY_KEYprimary key is not specified for column table
2050ERR_CS_NOT_SUPPORTED_DDLnot supported DDL type for column table
2051ERR_CS_NOT_SUPPORTED_ DATA_TYPEnot supported data type for column table
2052ERR_CS_NOT_SUPPORTED_DMLnot supported DML type for column table
2053ERR_CS_INVALID_RETURNED_ VALUEinvalid returned value from attribute engine
2054ERR_CS_DELTA_LOG_REPLAY_ FAILEDdelta log replay failed
2055ERR_CS_MAXIMUM_ROWmaximum number of rows per table or partition reached
2056ERR_CS_CONSISTENCY_CHECK_ FAILEDcolumn store table consistency check failed
2304ERR_PYDBAPIpython dbapi error
2305ERR_PYDBAPI_INTERFACE_ FAILUREinterface failure
2306ERR_PYDBAPI_PROGRAMMING_ MISTAKEprogramming mistake
2307ERR_PYDBAPI_INVALID_QUERY_ PARAMETERinvalid query parameter
2308ERR_PYDBAPI_NOT_SUPPORTED_ STR_ENCODINGnot supported encoding for string
2560ERR_METADATAmetadata error
2561ERR_DIST_METADATAdistributed metadata error
2562ERR_DIST_METADATA_ REDIRECT_FAILUREDDL redirect error
2563ERR_DIST_METADATA_DDL_ NOTIFICATION_FAILUREDDL notification error
2564ERR_DIST_METADATA_INVALID_ CONTAINER_IDDDL invalid container id
2565ERR_DIST_METADATA_INVALID_ INDEX_IDDDL invalid index id
2566ERR_DIST_METADATA_ TNSCLIENT_FAILUREdistributed environment error
2567ERR_DIST_METADATA_NETWORK_ FAILUREnetwork error
2568ERR_DIST_METADATA_ NOT_SUPPORTmetadata update not supported in slave
2569ERR_DIST_METADATA_MASTER_ UPDATE_FAILUREmetadata update in master indexserver is failed
2570ERR_METADATA_ROW_PAGE_ INTEGRITY_FAILURErow page consistency check is failed
2571ERR_INTEGRITY_BROKEN_ METADATAintegrity check detects broken metadata
2572ERR_INTEGRITY_INCONSISTENCYintegrity check detects inconsistency
2573ERR_INTEGRITY_ORPHANEDintegrity check detects orphaned object
2574ERR_METADATA_SEGMENT_ MIGRATION_GENERALmetadata segment migration pre-check error
2575ERR_METADATA_SEGMENT_ MIGRATION_FATALmetadata segment migration internal error
2576ERR_CATALOG_INVALID_ ADDRESSattempt to access metadata of an invalid address (already deleted or corrupted etc.)
2577ERR_CATALOG_NULL_ TERMINATIONcatalog object has wrong null termination
2578ERR_CATALOG_LOCATION_ ERRORcatalog object has wrong location
2579ERR_CATALOG_INVALID_ REFERENCEcatalog object has invalid reference(corrupted address)
2580ERR_CATALOG_UNEXPECTED_ REFERENCEcatalog object has wrong reference
2581ERR_CATALOG_VALUE_ DOMAIN_GENERALthe value of catalog object is broken
2582ERR_CATALOG_FOREIGN_KEY_ CONSTRAINTcan not find catalog object
2583ERR_CATALOG_WRONG_ VAR_SLOT_SIZEcatalog object has wrong slot size
2584ERR_CATALOG_CYCLIC_DEPENDENCYcan not make cyclic dependency
2585ERR_ES_BROKEN_METADATAinconsistency between HANA and DT catalog
2586ERR_ES_METADATA_FIX_FAILrepair operation to fix inconsistency failed
2816ERR_SQLSCRIPTSqlScript Error
2817ERR_SQLSCRIPT_BUILTIN_TOO_MANY_RETURN_ PARAMSqlScript Builtin Function
2818ERR_SQLSCRIPT_FUNCTION_ NOT_FOUNDSqlScript
2819ERR_SQLSCRIPT_TEMPLATE_PARAMETER_NUMBER_ WRONGSqlScript
2820ERR_SQLSCRIPT_VARIABLE_ NOT_DECLAREDSqlScript
2821ERR_SQLSCRIPT_DUPLICATE_ VARIABLE_NAMESqlScript
2822ERR_SQLSCRIPT_SQL_EXECUTION_ FAILEDSqlScript
2823ERR_SQLSCRIPT_DROP_FUNCTION_ FAILEDSqlScript
2824ERR_SQLSCRIPT_LOAD_FUNCTION_ FAILEDSqlScript
2825ERR_SQLSCRIPT_SIGNATURE_MISMATCH_WITH_ CATALOGSqlScript
2826ERR_SQLSCRIPT_REGISTER_FUNCTION_IN_ CATALOG_FAILEDSqlScript
2827ERR_SQLSCRIPT_SCALAR_INPUT_PARAMS_NOT_ SUPPORTEDSqlScript
2828ERR_SQLSCRIPT_LANGUAGE_ NOT_SUPPORTEDSqlScript
2829ERR_SQLSCRIPT_DROP_FUNCTION_FAILED_ EXISTING_CALLERSqlScript
2830ERR_SQLSCRIPT_LLANG_EXACTLY_ONE_OUTPUT_ PARAMSqlScript
2831ERR_SQLSCRIPT_BUILTIN_FIRST_PARAM_NOT_ COLUMN_TABLESqlScript
2832ERR_SQLSCRIPT_BUILTIN_PARAM_COUNT_ NOT_IN_RANGESqlScript
2833ERR_SQLSCRIPT_BUILTIN_PARAM_COUNT_ MISMATCHSqlScript
2834ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_INPUTSqlScript
2835ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_TABLE_NAMESqlScript
2836ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_VARIABLESqlScript
2837ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_VARIABLE_VECTORSqlScript
2838ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_SCALAR_VALUESqlScript
2839ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_SQLIDENT_VECTORSqlScript
2840ERR_SQLSCRIPT_BUILTIN_PARAM_ ATTRIBUTE_WITH_SCHEMASqlScript
2841ERR_SQLSCRIPT_BUILTIN_MISSING_ATTRIBUTE_ IN_PROJECTIONSqlScript
2842ERR_SQLSCRIPT_BUILTIN_MISSING_JOIN_ATTR_ IN_PROJECTIONSqlScript
2843ERR_SQLSCRIPT_TEMPL_FUNCTION_CAN_NOT_BE_ CALLEDSqlScript
2844ERR_SQLSCRIPT_PARAM_COUNT_ MISMATCHSqlScript
2845ERR_SQLSCRIPT_PARAM_WRONG_ TYPESqlScript
2846ERR_SQLSCRIPT_PARAM_WRONG_ TYPE_COMPARED_TO_SIGNATURESqlScript
2847ERR_SQLSCRIPT_PARAM_WRONG_ TABLE_TYPESqlScript
2848ERR_SQLSCRIPT_PARAM_MODE_ MISMATCHSqlScript
2849ERR_SQLSCRIPT_PARAM_ UNSUPPORTED_TYPESqlScript
2850ERR_SQLSCRIPT_NO_ OUTPUT_PARAMSqlScript
2851ERR_SQLSCRIPT_OUTPUT_ PARAM_ NOT_TABLE_TYPESqlScript
2852ERR_SQLSCRIPT_BUILTIN_ NOT_DEFINEDSqlScript
2853ERR_SQLSCRIPT_VAR_DEPENDS_ ON_UNASSIGNED_VARSqlScript
2854ERR_SQLSCRIPT_VAR_ CYCLIC_DEPENDENCYSqlScript
2855ERR_SQLSCRIPT_PARAM_ NOT_INITIALIZEDSqlScript
2856ERR_SQLSCRIPT_PARAM_ MISMATCH_ TABLE_TYPESqlScript
2857ERR_SQLSCRIPT_CALL_OPEN_ MISSING_CALL_CLOSESqlScript
2858ERR_SQLSCRIPT_BUILTIN_IN_PARAM_ NOT_SAME_TABLE_TYPESqlScript
2859ERR_SQLSCRIPT_BUILTIN_JOINATTR_ NOT_FOUND_IN_VARSqlScript
2860ERR_SQLSCRIPT_FUNCTION_ NOT_NESTABLESqlScript
2861ERR_SQLSCRIPT_CALL_CLOSE_MISSING_ CALL_OPENSqlScript
2862ERR_SQLSCRIPT_TABLE_TYPE_NOT_ DERIVABLESqlScript
2863ERR_SQLSCRIPT_MISSING_FTC_TYPE_ MAPPINGSqlScript
2864ERR_SQLSCRIPT_INVALID_TABLE_ TYPE_NAMESqlScript
2865ERR_SQLSCRIPT_DUPLICATE_ ATTRIBUTE_NAMESqlScript
2866ERR_SQLSCRIPT_FUNCTION_EXISTINGSqlScript
2867ERR_SQLSCRIPT_FUNCTION_TYPE_ NOT_SUPPORTEDSqlScript
2868ERR_SQLSCRIPT_FUNCTION_NAME_MAX_LENSqlScript
2869ERR_SQLSCRIPT_BUILTIN_PARAM_ATTRIBUTE_ WITH_ALIASSqlScript
2870ERR_SQLSCRIPT_INTERNAL_ERRSqlScript
2871ERR_SQLSCRIPT_BUILTIN_PARAM_NOT_AGGREGFUN_ VECTORSqlScript
2872ERR_SQLSCRIPT_FUNCTION_NAME_INVALIDSqlScript
2873ERR_SQLSCRIPT_BUILTIN_PARAM_NOT_PROJECTION_ VECTORSqlScript
2874ERR_SQLSCRIPT_BUILTIN_PARAM_NOT_FILTER_ EXPRESSIONSqlScript
2875ERR_SQLSCRIPT_RLANG_EXACTLY_ ONE_OUTPUT_PARAMSqlScript
2876ERR_SQLSCRIPT_JSLANG_EXACTLY_ ONE_OUTPUT_PARAMSqlScript
2877ERR_SQLSCRIPT_SQLLANG_EXACTLY_ ONE_OUTPUT_PARAMSqlScript
2878ERR_SQLSCRIPT_GENERICLANG_EXACTLY_ ONE_OUTPUT_PARAMSqlScript
2879ERR_SQLSCRIPT_BUILTIN_PARAM_NOT_ TABLE_TYPESqlScript
2880ERR_SQLSCRIPT_VARIABLE_NOT_TABLE_TYPESqlScript
2881ERR_SQLSCRIPT_BUILTIN_CALCATTR_ EXPRESSION_SYNTAXSqlScript
2882ERR_SQLSCRIPT_BUILTIN_UNEVEN_ NR_OF_PARAMSSqlScript
2883ERR_SQLSCRIPT_CALC_ATTR_NOT_ALLOWEDSqlScript
2884ERR_SQLSCRIPT_BUILTIN_DUPLICATE_ COLUMN_NAMESqlScript
2885ERR_SQLSCRIPT_BUILTIN_PARAM_NOT_ KEY_VALUE_VECTORSqlScript
2886ERR_SQLSCRIPT_BUILTIN_CALCATTR_ REFERENCED_FIELD_MISSINGSqlScript
2887ERR_SQLSCRIPT_BUILTIN_FILTER_REFERENCED_ FIELD_MISSINGSqlScript
2888ERR_SQLSCRIPT_BUILTIN_FILTER_EXPRESSION_ SYNTAXSqlScript
2889ERR_SQLSCRIPT_BUILTIN_PARAM_NOT_ COL_OR_AGGR_VECTORSqlScript
2890ERR_SQLSCRIPT_TABLE_INPUT_PARAMS_ NOT_SUPPORTEDSqlScript
2891ERR_SQLSCRIPT_TABLE_INOUT_PARAMS_NOT_ SUPPORTEDSqlScript
3584ERR_DIST_SQLdistributed SQL error
3585ERR_DIST_SQL_EXPR_SHIPPING_ FAILUREexpression shipping failure
3586ERR_DIST_SQL_OPERATOR_SHIPPING_ FAILUREoperator shipping failure
3587ERR_DIST_SQL_INVALID_PROTOCOLinvalid protocol or service shutdown during distributed query execution
3588ERR_DIST_SQL_SEQUENCE_SHIPPING_ FAILUREsequence shipping failure
3589ERR_DIST_SQL_REMOTE_EXECUTION_ FAILUREremote query execution failure
3840ERR_AUDITINGgeneral auditing error
3841ERR_AUDITING_NO_PRIV_NAMEInvalid privilege
3842ERR_AUDITING_TRAIL_WRITER_ BLOCKEDAudit trail writer is blocked
3843ERR_AUDITING_POLICY_ALREADY_ EXISTSAudit policy with current name already exists
3844ERR_AUDITING_INV_POLICY_TYPEInvalid combination of audit actions
3845ERR_AUDITING_INV_ACTION_STATUSInvalid action status for auditing
3846ERR_AUDITING_INV_LEVELInvalid auditing level
3847ERR_AUDITING_INV_POLICY_NAMEInvalid policy name
3848ERR_AUDITING_INV_ACTION_ OBJECT_TYPEInvalid combination of audit action and object type
3849ERR_AUDITING_INV_OBJECT_TYPEAudit policy for this object type not supported

You May Also Like

HANA SQL Error Message (5142 – 5737)

HANA SQL Error Message (4096 – 5141)

HANA SQL Error Message (661 – 1800)

HANA SQL Error Message (295 – 660)

Leave a Reply?