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 |
|---|---|---|
| 661 | ERR_SQL_EXST_WORKLOAD_MAPPING | cannot use duplicate workload mapping name |
| 662 | ERR_SQL_INV_WORKLOAD_MAPPING | invalid workload mapping name |
| 663 | ERR_SQL_CONNECT_NOT_ALLOWED | user not allowed to connect from client |
| 664 | ERR_SQL_INV_AGENT_GROUP | invalid agent group name |
| 665 | ERR_SQL_EXST_AGENT_GROUP | cannot use duplicate agent group name |
| 666 | ERR_SQL_AGENT_GROUP_NOT_EMPTY | agents are still set to this agent group. |
| 667 | ERR_SQL_TEXT_MINING_FAILURE | text mining error |
| 668 | ERR_SQL_2D_POINTS_SUPPORTED_ONLY | ST_Point columns support 2-dimensional points only |
| 669 | ERR_SQL_SPATIAL_ERROR | spatial error |
| 670 | ERR_SQL_PART_NOT_EXIST | part does not exist |
| 671 | ERR_SQL_EXST_LIBRARY | cannot use duplicate library name |
| 672 | ERR_SQL_DPLC_ASSOCIATION | duplicate association name |
| 673 | ERR_SQL_INV_GRAPH_WORKSPACE | invalid graph workspace name |
| 674 | WRN_SQL_EXPORT_SKIP_CROSSDB_OBJECT | cross database object found and skipped in exporting so IMPORT might fail |
| 675 | ERR_SQL_EXST_GRAPH_WORKSPACE | cannot use duplicate graph workspace name |
| 676 | ERR_SQL_DUP_WORKLOAD_MAPPING | cannot use duplicate workload mapping to same combination of (user name application user name application name client application component name application component type) |
| 677 | ERR_SQL_CHECK_CONSTRAINT_VIOLATION | check constraint violation |
| 678 | ERR_SQL_PLANSTABILIZER | plan stabilizer error |
| 679 | ERR_SQL_PLANSTABILIZER_NO_MANAGER | plan stabilizer error – manager not found: please check if Plan Stabilizer is enabled |
| 680 | ERR_SQL_PLANSTABILIZER_STORED_HINT | plan stabilizer stored hint error – statement hint table error |
| 681 | ERR_SQL_PLANSTABILIZER_STORED_ HINT_COMMAND | plan stabilizer stored hint error – error while processing statement hint command |
| 682 | ERR_SQL_PLANSTABILIZER_STORED_ HINT_TABLE_EMPTY | plan stabilizer stored hint error – statement hint table is empty |
| 683 | ERR_SQL_PLANSTABILIZER_STORED_ HINT_MAP_LOAD_ERROR | plan stabilizer stored hint error – statement hint table is corrupt. |
| 684 | ERR_SQL_PLANSTABILIZER_STORED_ HINT_RECORD_ALREADY_EXISTS | plan stabilizer stored hint error – statement hint record already exists |
| 685 | ERR_SQL_PLANSTABILIZER_STORED_ HINT_RECORD_DOES_NOT_EXIST | plan stabilizer stored hint error – statement hint record does not exist |
| 686 | ERR_SQL_START_TASK_ERROR | start task error |
| 687 | ERR_SQL_EXCEED_LAG_TIME | exceed lag time of RESULT_LAG |
| 688 | ERR_IO_FAILURE_ON_FILE_WRITE | I/O error occured on file write |
| 689 | ERR_SQL_DUPLICATE_ROWID_MATCHED | Duplicate rowid matched during merge into |
| 690 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN | plan stabilizer stored plan error |
| 691 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_COMMAND | plan stabilizer stored plan error – error while processing command |
| 692 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_TABLE_EMPTY | plan stabilizer stored plan error – stored plan table is empty |
| 693 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_MAP_LOAD_ERROR | plan stabilizer stored plan error – stored plan table is corrupt. |
| 694 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_RECORD_ALREADY_EXISTS | plan stabilizer stored plan error – stored plan record already exists |
| 695 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_RECORD_DOES_NOT_EXIST | plan stabilizer stored plan error – stored plan record does not exist |
| 696 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_CANNOT_CONVERT_ABSTRACT_PLAN | plan stabilizer stored plan error – cannot convert to abstract plan |
| 697 | ERR_SQL_PREACTIVE_KEY_EXISTS | Preactive key already exists |
| 698 | ERR_SQL_NO_PREACTIVE_KEY | No preactive key exists |
| 699 | ERR_SQL_EXST_DEPENDENCY_RULE | cannot use duplicate dependency rule name |
| 700 | ERR_SQL_SINGLE_COLUMN_SEARCH_ THROW_ERROR | no_stacked_column_search(throw_error) error |
| 701 | ERR_SQL_EXST_USERGROUP | usergroup name already exists |
| 702 | ERR_SQL_INV_USERGROUP | invalid usergroup name |
| 703 | ERR_INCORRECT_ROOT_KEYS_BACKUP_ PASSWORD | incorrect root keys backup password |
| 704 | ERR_SQL_USERGROUP_DELETION_FAILED | usergroup cannot be dropped |
| 705 | ERR_SQL_CONCURRENT_GRANT | Two concurrent statements performed the same grant operation |
| 706 | ERR_SQL_INV_SYMMETRIC_CIPHER | currently only AES-256-CBC is supported: invalid cipher |
| 707 | ERR_SQL_EXST_COLUMN_KEY | cannot use duplicate column key name |
| 708 | ERR_SQL_EXST_COLUMN_KEYCOPY | column keycopy already exists |
| 709 | ERR_SQL_EXST_KEYPAIR | keypair already exists |
| 710 | ERR_SQL_INV_ASYMMETRIC_CIPHER | currently only RSA-OAEP-2048 is supported: invalid cipher |
| 711 | ERR_SQL_EXST_COLUMN_KEY_ID | cannot use duplicate column key id |
| 712 | ERR_SQL_PLANSTABILIZER_STORED_ PLAN_MIGRATION | plan stabilizer stored plan error – migration error |
| 713 | ERR_SQL_NOT_OWN_KEYPAIR | keypair not owned by the creator of the column key |
| 714 | ERR_SQL_DROP_COLUMN_KEYCOPY | cannot drop the last key admin keycopy |
| 715 | ERR_SQL_EMPTY_WORKLOAD_MAPPING | cannot use a workload mapping with no properties |
| 716 | ERR_SQL_STALE_STATEMENT | statement is stale metadata or column encryption key of some columns have changed |
| 717 | ERR_SQL_INV_KEY_ID | invalid key id |
| 1024 | ERR_SES | session error |
| 1025 | ERR_COM | communication error |
| 1026 | ERR_COM_LISTEN | cannot bind a communication port |
| 1027 | ERR_COM_INIT | communication initialization error |
| 1028 | ERR_COM_IOCTL | I/O control error |
| 1029 | ERR_COM_CONNECT | connection failure |
| 1030 | ERR_COM_SEND | send error |
| 1031 | ERR_COM_RECEIVE | receive error |
| 1032 | ERR_SES_THREAD_CREATE | cannot create a thread |
| 1033 | ERR_SES_INV_PROTOCOL | error while parsing protocol |
| 1034 | ERR_SES_EXCEED_MAX_SESSION | exceed maximum number of sessions |
| 1035 | ERR_SES_INV_VERSION | not supported version |
| 1036 | ERR_SES_INV_SESSION | invalid session id |
| 1037 | ERR_COM_UNKNOWN_HOST | unknown hostname |
| 1038 | ERR_SES_SERVER_BUSY | rejected as server is temporarily overloaded |
| 1088 | ERR_DATA_STAT | data statistics error |
| 1089 | ERR_DATA_STAT_NOT_FOUND | no matching data statistics objects found |
| 1090 | ERR_DATA_STAT_REMOTE_QUERY_ERR | invalid result from query to remote source |
| 1091 | ERR_DATA_STAT_TABLE_NOT_FOUND | specified table not found or not supported |
| 1092 | ERR_DATA_STAT_BUILD_ERROR | error building data statistics object |
| 1093 | ERR_DATA_STAT_EXISTS | data statistics object already exists |
| 1094 | ERR_DATA_STAT_INVALID_SETTING | invalid combination of settings specified |
| 1120 | ERR_USERGROUP_GENERAL | usergroup error |
| 1121 | ERR_USERGROUP_USER_NOT_ MEMBER_OF_ANY | user is not member of any usergroup |
| 1122 | ERR_USERGROUP_EQUAL_CURRENT_ AND_NEW_USERGROUP | current and new usergroup are the same |
| 1123 | ERR_USERGROUP_UNKNOWN_ PARAMETER_NAME | unknown parameter for usergroup |
| 1124 | ERR_USERGROUP_UNKNOWN_ PARAMETER_SET_NAME | unknown parameter set for usergroup |
| 1125 | ERR_USERGROUP_DUPLICATE_ PARAMETER_NAME | same parametername specified more than once |
| 1126 | ERR_USERGROUP_INVALID_ PARAMETER_VALUE | invalid value for usergroup parameter |
| 1280 | ERR_SQLSCRIPT_2 | sqlscript error |
| 1281 | ERR_SQLSCRIPT_WRONG_PARAMS | wrong number or types of parameters in call |
| 1282 | ERR_SQLSCRIPT_OUT_PARAM_VAR | output parameter not a variable |
| 1283 | ERR_SQLSCRIPT_OUT_PARAM_ DEFAULT | OUT and IN OUT parameters may not have default expressions |
| 1284 | ERR_SQLSCRIPT_DUP_PARAMETERS | duplicate parameters are not permitted |
| 1285 | ERR_SQLSCRIPT_DUP_DECL | at most one declaration is permitted in the declaration section |
| 1286 | ERR_SQLSCRIPT_CURSOR_ SELECT_STMT | cursor must be declared by SELECT statement |
| 1287 | ERR_SQLSCRIPT_ID_NOT_ DECLARED | identifier must be declared |
| 1288 | ERR_SQLSCRIPT_NOT_ASSIGN_ TARGET | expression cannot be used as an assignment target |
| 1289 | ERR_SQLSCRIPT_NOT_INTO_TARGET | expression cannot be used as an INTO-target of SELECT/FETCH statement |
| 1290 | ERR_SQLSCRIPT_LHS_CANNOT_ ASSIGNED | expression is inappropriate as the left hand side of an assignment statement |
| 1291 | ERR_SQLSCRIPT_EXPR_ WRONG_TYPE | expression is of wrong type |
| 1292 | ERR_SQLSCRIPT_ILLEGAL_ EXIT_STMT | illegal EXIT statement it must be appear inside a loop |
| 1293 | ERR_SQLSCRIPT_ID_ EXCEPTION_TYPE | identifier name must be an exception name |
| 1294 | ERR_SQLSCRIPT_INTO_CLAUSE | an INTO clause is expected in SELECT statement |
| 1295 | ERR_SQLSCRIPT_NOT_ALLOWED_ SQL_STMT | EXPLAIN PLAN and CALL statement are not allowed |
| 1296 | ERR_SQLSCRIPT_NOT_CURSOR | identifier is not a cursor |
| 1297 | ERR_SQLSCRIPT_NUM_FETCH_VALUES | wrong number of values in the INTO list of a FETCH statement |
| 1298 | ERR_SQLSCRIPT_UNHANDLED_EXCEPTION | unhandled user-defined exception |
| 1299 | ERR_SQLSCRIPT_NO_DATA_FOUND | no data found |
| 1300 | ERR_SQLSCRIPT_FETCH_MANY_ROWS | fetch returns more than requested number of rows |
| 1301 | ERR_SQLSCRIPT_VALUE_ERROR | numeric or value error |
| 1302 | ERR_SQLSCRIPT_OUT_PARAM_ IN_FUNCTION | parallelizable function cannot have OUT or IN OUT parameter |
| 1303 | ERR_SQLSCRIPT_USER_DEFINED_ EXCEPTION | user-defined exception |
| 1304 | ERR_SQLSCRIPT_CURSOR_ALREADY_OPEN | cursor is already opened |
| 1305 | ERR_SQLSCRIPT_INVALID_RETURN_TYPE | return type is invalid |
| 1306 | ERR_SQLSCRIPT_RETURN_TYPE_MISMATCH | return type mismatch |
| 1307 | ERR_SQLSCRIPT_UNSUPPORTED_DATATYPE | unsupported datatype is used |
| 1308 | ERR_SQLSCRIPT_INVALID_SINGLE_ ASSIGNMENT | illegal single assignment |
| 1309 | ERR_SQLSCRIPT_INVALID_USE_OF_ TABLE_VARIABLE | invalid use of table variable |
| 1310 | ERR_SQLSCRIPT_NOT_ALLOWED_ SCALAR_TYPE | scalar type is not allowed |
| 1311 | ERR_SQLSCRIPT_NO_OUT_PARAM | Out parameter is not specified |
| 1312 | ERR_SQLSCRIPT_AT_MOST_ONE_ OUT_PARAM | At most one output parameter is allowed |
| 1313 | ERR_SQLSCRIPT_OUT_PARAM_TABLE | output parameter should be a table or a table variable |
| 1314 | ERR_SQLSCRIPT_INVALID_ VARIABLE_NAME | inappropriate variable name: do not allow "" or '_SYS_' prefix for the name of variable or parameter |
| 1315 | ERR_SQLSCRIPT_RETURN_RESULT_ SET_WITH_RESULTVIEW | Return result set from SELECT statement exist when result view is defined |
| 1316 | ERR_SQLSCRIPT_NOT_ASSIGNED_ OUT_TABVAR | some out table variable is not assigned |
| 1317 | ERR_SQLSCRIPT_FUNCTION_NAME_ MAX_LEN | Function name exceedes max. limit |
| 1318 | ERR_SQLSCRIPT_BUILTIN_NOT_DEFINED | Built-in function not defined |
| 1319 | ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_TABLE_NAME | Parameter must be a table name |
| 1320 | ERR_SQLSCRIPT_BUILTIN_PARAM_ ATTRIBUTE_WITH_SCHEMA | Parameter must be an attribute name without a table name upfront |
| 1321 | ERR_SQLSCRIPT_BUILTIN_PARAM_ ATTRIBUTE_WITH_ALIAS | Parameter must be an attribute name without an alias |
| 1322 | ERR_SQLSCRIPT_CALC_ATTR_NOT_ ALLOWED | CE_CALC not allowed |
| 1323 | ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_COL_OR_AGGR_VECTOR | Parameter must be a vector of columns or aggregations |
| 1324 | ERR_SQLSCRIPT_BUILTIN_MISSING_ JOIN_ATTR_IN_PROJECTION | Join attribute must be available in projection list |
| 1325 | ERR_SQLSCRIPT_BUILTIN_PARAM_ NOT_SQLIDENT_VECTOR | Parameter must be a vector of sql identifiers |
| 1326 | ERR_SQLSCRIPT_DUPLICATE_ ATTRIBUTE_NAME | Duplicate attribute name |
| 1327 | ERR_SQLSCRIPT_PARAM_UNSUPPORTED_ TYPE | Parameter has a non supported type |
| 1328 | ERR_SQLSCRIPT_BUILTIN_MISSING_ ATTRIBUTE_IN_PROJECTION | Attribute not found in column table |
| 1329 | ERR_SQLSCRIPT_BUILTIN_ DUPLICATE_COLUMN_NAME | Duplicate column name |
| 1330 | ERR_SQLSCRIPT_BUILTIN_ CALCATTR_EXPRESSION_SYNTAX | Syntax Error for calculated Attribute |
| 1331 | ERR_SQLSCRIPT_BUILTIN_FILTER_ EXPRESSION_SYNTAX | Syntax Error in filter expression |
| 1332 | ERR_SQLSCRIPT_BUILTIN_FIRST_ PARAM_NOT_COLUMN_TABLE | Parameter must be a valid column table or projection view on column tables |
| 1333 | ERR_SQLSCRIPT_BUILTIN_JOINATTR_ NOT_FOUND_IN_VAR | Join attributes not found in variable |
| 1334 | ERR_SQLSCRIPT_BUILTIN_IN_PARAM_ NOT_SAME_TABLE_TYPE | Input parameters do not have the same table type |
| 1335 | ERR_SQLSCRIPT_RUNTIME_CYCLIC_ DEPENDENCY | Cyclic dependency found in a runtime procedure |
| 1336 | ERR_SQLSCRIPT_RUNTIME_UNEXPECTED_ EXCEPTION | Unexpected internal exception caught in a runtime procedure |
| 1337 | ERR_SQLSCRIPT_VAR_DEPENDS_ON_ UNASSIGNED_VAR | Variable depends on an unassigned variable |
| 1338 | ERR_SQLSCRIPT_CE_CONVERSION_ CUSTOM_TAB_MISSING | CE_CONVERSION: customizing table missing |
| 1339 | ERR_SQLSCRIPT_TOO_MANY_PARAMS | Too many parameters |
| 1340 | ERR_SQLSCRIPT_NESTED_CALL_ TOO_DEEP | The depth of the nested call is too deep |
| 1341 | ERR_SQLSCRIPT_VERSION_VALIDATION_ FAILED | Procedure version validation failed |
| 1342 | ERR_SQLSCRIPT_CE_CALC_ATTRIBUTE_ AND_ALIAS_ARE_SAME | Attribute has the same name as the alias |
| 1343 | ERR_SQLSCRIPT_RETRY_EXCEPTION | Retry Exception is occurred in a runtime procedure |
| 1344 | ERR_SQLSCRIPT_NOT_ALLOWED_ DYNAMIC_SQL | Dynamic SQL or DDL is not allowed |
| 1345 | ERR_SQLSCRIPT_NOT_ALLOWED_ CONCURRENT_WRITES | Concurrently two or more write operations to the same object are not allowed |
| 1346 | ERR_SQLSCRIPT_NOT_ALLOWED_ CONCURRENT_READ_AND_WRITE | Concurrently read and write operations to the same object are not allowed |
| 1347 | WRN_SQLSCRIPT_NOT_RECOMMENDED_ FEATURE | Not recommended feature |
| 1348 | ERR_SQLSCRIPT_LLANG_GET_LIBRARY_ IMPORT_LIST_FAILED | Failed to retrieve the list of imported libraries from LLANG procedure |
| 1349 | ERR_SQLSCRIPT_INITIAL_ASSIGNMENT_ REQUIRED_FOR_CONSTANT_TABLE | Assigning initial value is required for declaring constant table variable |
| 1350 | ERR_SQLSCRIPT_NOT_ALLOWED_NON_ DETERMINISTIC_FEATURE | Non-deterministic feature is not allowed |
| 1351 | ERR_SQLSCRIPT_INVALID_PARSE_TREE | Invalid parse tree |
| 1352 | ERR_SQLSCRIPT_ENCRYPTION_NOT_ ALLOWED | Not allowed for encrypted procedure or function |
| 1353 | ERR_SQLSCRIPT_NOT_NULL_COLUMN_ IGNORED | NOT NULL constraints in explicit table types are ignored |
| 1354 | ERR_SQLSCRIPT_CURSOR_NOT_OPENED | Cursor to be fetched has not been opened yet |
| 1355 | ERR_SQLSCRIPT_INVALID_EXTERN_LANG | Invalid external language |
| 1356 | ERR_SQLSCRIPT_COMPOSITE | Composite error in SQLScript processing |
| 1792 | ERR_SHM | shared memory error |
| 1793 | ERR_SHM_CREATE_INVALID | invalid key or invalid size |
| 1794 | ERR_SHM_CREATE_ALREADY_EXIST | the segment already exists |
| 1795 | ERR_SHM_CREATE_EXCEED_LIMIT | exceed the system-wide limit on shared memory |
| 1796 | ERR_SHM_CREATE_NOT_EXIST | no segment exists for the given key and IPC_CREAT was not specified |
| 1797 | ERR_SHM_CREATE_NO_ACCESS | the user does not have permission to access the shared memory segment |
| 1798 | ERR_SHM_CREATE_NO_MORE_MEMORY | no memory could be allocated for segment overhead |
| 1799 | ERR_SHM_DROP_INVALID | invalid shmid |
| 1800 | ERR_SHM_DROP_NO_ACCESS | allow read access for shmid |
