## 2.2.1  SQL Error Reference
The following reference table provides links to sources of troubleshooting information for many frequently occurring SQL errors.
SQL Error Codes
|   Code | Type                      | Description                   | More information                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|--------|---------------------------|-------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|      4 | FATAL_OUT_OF_MEMORY       | Cannot allocate enough memory | This error indicates an out-of-memory (OOM) situation. - KBA 1999997 - FAQ:SAPHANA Memory                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
|      7 | ERR_FEATURE_NOT_SUPPORTED | Feature not supported         | Commonpreamble to a more detailed error. Please review the error detail following the pre- amble "feature not supported: ...." and search the SAP HANAKnowledge base for existing Knowledge based articles and SAP Notes. Some examples: 2970997 - feature not supported: Invalid op- tions 2804287 - feature not supported: Create da- tabase command on SYSTEMDB only 2870701 - Error "feature not supported: global temporary table must be empty to drop" 2661916 - feature not supported: Snapshot backup not supported on a tenant database 2710915 - feature not supported: move with- out partition not allowed on partitioned table |
|      8 | ERR_INV_ARGUMENT          | Invalid argument              | 3104969 - DBSQL_SEMREQ_ERROR. 22 In- valid argument. (Internal KBA)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|     10 | ERR_AUTHENTICATION_FAILED         | Authentication failed                              | This error indicates a failure during user authen- tication - (See KBA 2399990 ) See section '11. How can tracing be activated for security topics like authorization, authentication and login?' - 2159014 - FAQ: SAP HANASe- curity                 |
|     11 | ERR_INV_STATE                     | Invalid state                                      | 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments.                                                                                                                                                                                 |
|     12 | ERR_FILE_OPEN_FAILED              | Cannot open file                                   | Issue with a backup file in the backup catlog or a data / redo log file in the persistence directory on the HANAdata and log volumes. Check the underlying HANAservices that use persistence and their trace files for more information on the error. |
|     15 | ERR_FILE_NOT_FOUND                | Cannot find file                                   | Typically an issue with a third party backint tool: 2801380 - ERROR: [110063] The backup destination header is corrupt 2541007 - Not able to restore database from Symantec NetBackup if the backup file name contains square brackets                |
|     18 | ERR_SERVICE_SHUTDOWN              | Service shutting down                              | Indicates that a HANAservice has been sent a shutdown command either manually from <sid>adm, or a parent process like the sap- start service, daemon or nameserver. Check the HANAservice trace files for the events leading up to the error.         |
|     19 | ERR_INV_LICENSE                   | Invalid license                                    | 19: invalid license' is described in more detail in SAP KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                      |
|     20 | ERR_CON_OUTSIDE_VALID- ITY_PERIOD | Connect attempt out- side user's validity pe- riod | Connect attempt outside user's validity peri- od' is described in more detail in SAP KBA 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                        |
|     21 | ERR_PERSISTENCE                   | Persistence error                                  | Persistence error' is described in more detail in SAP KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                        |
|    128 | ERR_TX                         | Transaction error                                                   | SQL error 128: transaction error: exceed maxi- mumnumberof transactions' is described in further detail in KBA 2154870 - How-To: Un- derstanding and defining SAP HANALimitations                                                                                      |
|    129 | ERR_TX_ROLLBACK                | Transaction rolled back by an internal error                        | This is a quite generic message that something went wrong and the transaction had to be rolled back. Check the HANAservice trace files for related detailed error messages.                                                                                            |
|    131 | ERR_TX_ROLLBACK_LOCK_TIME- OUT | Transaction rolled back by lock wait timeout                        | SAP KBAs: 3066406 - SQL code: 131" occurred while accessing table 1999998 - FAQ: SAP HANALock Analysis 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                           |
|    132 | ERR_TX_ROLLBACK_RESOURCE       | Transaction rolled back due to unavailable re- source               | SAP KBAs: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2154870 - How-To: Understanding and defin- ing SAP HANALimitations                                                                                |
|    133 | ERR_TX_ROLLBACK_DEADLOCK       | Transaction rolled back by detected deadlock                        | This type of short dump indicates a deadlock, so a cross-wise transactional lock. In most cases deadlocks are caused by inadequate application coding that results in risk of cross-wise locking of different transactions. See 1999998 - FAQ: SAP HANALock Analy- sis |
|    138 | ERR_TX_SERIALIZATION           | Transaction serializa- tion failure                                 | This error indicates that a retry for a database request was triggered, but the request is not retriable. This trace error can be linked to "138: trans- action serialization failure: Serialization failure" errors observed on client side (SAP KBA 2399990 )        |
|    139 | ERR_TX_ROLLBACK_QUERY_CAN- CEL | Current operation can- celed by request and transaction rolled back | SAP Note 2931813 - Memory Related Error or Warning Trace Messages when Cancelling a Query                                                                                                                                                                              |
|    142 | ERR_TX_EXCEED_MAX_TX_NUM               | Exceedmaxnum of concurrent transac- tions         | This error is generated if the limit of configured external connections is reached. See SAP KBAs: 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 1910159 - How to handle HANAAlert 25: 'Check number of connections'                                                     |
|    144 | ERR_TX_ROLLBACK_UNIQUE_VIO- LATED      | Transaction rollback unique constraint vio- lated | See '19. Which error messages exist in the con- text of indexes?' - 2160391 - FAQ:SAPHANA Indexes                                                                                                                                                                                            |
|    145 | ERR_TX_DIST_FAILURE                    | Transaction distribu- tion work failure           | Multiple , generic causes. See KBAs: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                                              |
|    146 | ERR_TX_LOCK_ACQUISITION_FAIL           | Resource busy and NOWAIT specified                | This error indicates that an operation is per- formed with a NOWAIT option and so it termi- nates immediately in case the transactional ob- ject or record lock can't be acquired. See KBAs for more information: 1999998 - FAQ: SAP HANALock Analysis 2380176 - FAQ: SAP HANADatabase Trace |
|    149 | ERR_TX_DIST_2PC_FAILURE                | Distributed transaction commit failure            | This error indicates major problems on server side, so the SAP HANAdatabase should be in- vestigated.                                                                                                                                                                                        |
|    154 | ERR_TX_INDEX_HANDLE_AC- QUISITION_FAIL | failure in acquiring in- dex handle               | This error indicates an index handle contention issue (SAP Note 1999998 ) accessing a mon- itoring view like M_CS_NSE_ADVISOR. SAP Note - 3125519 - Querying M_CS_NSE_ADVISOR Might Fail and Not Pro- duce Any Recommendation                                                                |
|    256 | ERR_SQL                                | sql processing error                              | [256]: sql processing error:' is a generic error and needs further investigation via theHANA service traces. 2073630 - DBIF_RSQL_SQL_ERROR SQL er- ror 256 when access table 2380176 - FAQ: SAP HANADatabase Trace                                                                           |
|    257 | ERR_SQL_PARSE       | sql syntax error       | This error indicates a wrong syntax and you need to check the related SQL statement for correctness. In rare cases the issue can also be a conse- quence of problems on lower layers (infrastruc- ture / hardware) erroneously modifying SQL statement strings. SAP KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments |
|    258 | ERR_SQL_INSUFF_PRIV | insufficient privilege | Authorization / permission problems. This ter- mination indicates missing privileges. Make sure that proper roles and privileges are assigned. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2159014 - FAQ: SAP HANASecurity                                                    |
|    259 | ERR_SQL_INV_TABLE   | invalid table name     | This error indicates that the table or view <ob- ject> isn't found. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                                                                     |
|    260 | ERR_SQL_INV_COLUMN  | invalid column name    | This error indicates that column <column> doesn't exist in table <table> and so the da- tabase operation <op> (e.g. 'INS' for INSERT) fails. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                            |
|    261 | ERR_SQL_INV_INDEX   | invalid index name     | 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2142945 - FAQ: SAP HANAHints 2800008 - FAQ: SAP HANAFulltext Indexes                                                                                                                                                                                                    |
|    262 | ERR_SQL_INV_QUERY   | invalid query name     | ODBC_SQL* queries are built-in database quer- ies (installed when the SAP HANAdatabase is created) that are used for certain ODBCdriver related actions, e.g. ODBC_SQL_COLUMNS for retrieving column metadata. The error indicates that the query isn't available. Check why it is missing or not properly accessible.                       |
|    264 | ERR_SQL_INV_DATATYPE    | invalid datatype           | 21. Are there restrictions in processing LOB col- umns?' - 2220627 - FAQ:SAPHANALOBs 2222219 - SAP HANAErrors and different Results due to Design Changes 2765864 - Update Statement Fails With Er- ror "invalid datatype: $rowid$ of invalid data types" |
|    266 | ERR_SQL_INCNST_DATATYPE | inconsistent datatype      | 2486755 - "inconsistent datatype: lob type comparison" when selecting from a column with typeTEXT-HANADB 2222219 - SAP HANAErrors and different Results due to Design Changes                                                                             |
|    268 | ERR_SQL_AMBG_COLUMN     | column ambiguously defined | 2695943 - SQL failed with error "column am- biguously defined" 2552712 - The Error "column ambiguously defined" May Occur When a Statement is Exe- cuted                                                                                                  |
|    269 | ERR_SQL_MANY_VALUES     | too many values            | This error indicates that a database operation is executed with a wrong number of arguments, e.g.: SAP KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                           |
|    270 | ERR_SQL_FEW_VALUES      | not enough values          | This error indicates that a database operation is executed with a wrong number of arguments, e.g.: SAP KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                           |
|    272 | ERR_SQL_DPLC_COLUMN     | duplicate column name      | Column name already exists in the table                                                                                                                                                                                                                   |
|    274 | ERR_SQL_INS_LARGE_VALUE | inserted value too large for column  | This error indicates that a value was inserted in a column that is larger than the maximum column value size, e.g.: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2222219 - SAP HANAErrors and different Results due to Design Changes 3018823 - Inserted Value Too Large For Col- umn 2725050 - SqlScript Execution Fails With "[274]: inserted value too large for column" |
|    286 | ERR_SQL_LONG_IDENTIFIER | identifier is too long               | Identifier are names for SAP HANAobjects like table, column or user. 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2170441 - Query on SDA object fails with Er- ror "ORA-00972: identifier is too long"                                                                                                                                                                                                              |
|    287 | ERR_SQL_NOT_NULL        | cannot insert NULL or update to NULL | This error happens when a NULL value is in- serted into a column that doesn't allow NULL values, e.g. because of a NOTNULLor primary key constraint. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                                                                           |
|    288 | ERR_SQL_EXST_TABLE      | cannot use duplicate table name      | 2800007 - FAQ: SAP HANATemporary Ta- bles 2562930 - SAP HANALocal Temporary Ta- ble existence boundaries                                                                                                                                                                                                                                                                                                                                  |
|    292 | ERR_SQL_FEW_ARGUMENT    | wrong number of argu- ments          | This error indicates that a database operation is executed with a wrong number of arguments, e.g.: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                                                                                                                                   |
|    293 | ERR_SQL_INV_ARGUMENT     | argument type mis- match               | Can occur during catalog consistency checks and during HANservice removal from the topol- ogy: 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions 2342394 - Unable to remove additional index server 2504698 - Removing additional indexserver services fails with error on a SAP HANAsystem                                                                                                                                   |
|    301 | ERR_SQL_UNIQUE_VIOLATED  | unique constraint vio- lated           | This error indicates that a modification isn't possible because the key already exists. Check the existing unique and primary keys and make sure that duplicates aren't processed. 2380176 - FAQ: SAP HANADatabase Trace 2572224 - How-To: Repairing SAP HANATa- bles 2160391 - FAQ: SAP HANAIndexes                                                                                                                                  |
|    302 | ERR_SQL_INV_CHAR_VAL     | invalid CHARor VAR- CHARvalue          | This error indicates a wrong character encoding and is typically caused by a data corruption. See SAP Note 2116157 in order to check the consistency of the database (with a particular focus on the table returning the error) and take appropriate actions to repair inconsistencies.                                                                                                                                               |
|    303 | ERR_SQL_INV_DATETIME_VAL | "invalid DATE TIME or TIMESTAMP value" | This error indicates that a value <value> can't be parsed as date, time or timestamp. This problem can be caused by wrong data in under- lying tables or inadequate application design. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2361364 - [303]: invalid DATE, TIME or TIMESTAMP value: search table error: [6931] at- tribute value is not a date or wrong syntax |
|    304 | ERR_SQL_DIV_BY_ZERO      | division by zero unde- fined           | 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2945199 - search table error: [6859] Attribu- teEngine: divide by zero 2548692 - Alert in HANAStudio '[3] 304 division by zero undefined: search table error: [6859] AttributeEngine: divide by zero'                                                                                                                                                            |
|    305 | ERR_SQL_SINGLE_ROW       | single-row query re- turns more than one row | This termination indicates that more than 1 re- cord is returned although only a single row can be used. It is typically caused by a coding error on application side. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace                |
|    306 | ERR_SQL_INV_CURSOR       | invalid cursor                               | These termination indicates a lack of memory on SAP HANAserver side. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                        |
|    307 | ERR_SQL_NUM_OUT_OF_RANGE | numeric value out of range                   | This termination indicates an overflow while processing decimal numbers. Adjust the appli- cation, data or column precision in order to make sure that overflows no longer happen. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace    |
|    308 | ERR_SQL_EXST_COLUMN      | column name already exists                   | A CREATE or ALTER statement processing an existing table column may encounter this during a DDL operation.                                                                                                                                                                                       |
|    310 | ERR_SQL_IN_PROC          | sql error in procedure                       | 2647960 - Checks after phase MAIN_NEW- BAS/JOB_RS_DMO_HDB_CONTENT_ACTIVATE were negative for Delivery Unit A2EESNHI_DE- LIVERY_UNIT                                                                                                                                                              |
|    311 | ERR_SQL_DROP_ALL_COLUMNS | cannot drop all col- umns in a table         | Restriction for issuing a DROPcommandfor all columns in a database table                                                                                                                                                                                                                         |
|    313 | ERR_SQL_INV_SEQ          | invalid sequence                             | 6. Which problems exist in context of sequen- ces?' - 2600095 - FAQ: SAP HANASequen- ces                                                                                                                                                                                                         |
|    314 | ERR_SQL_OVERFLOW_NUMERIC | numeric overflow                             | This error is returned if you use a higher number precision than defined for the column. Either reduce the precision on application side or in- crease the precision in the database. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace |
|    320 | ERR_SQL_LOB_INDEX              | cannot create index on expression with data- type LOB | 21. Are there restrictions in processing LOB col- umns?' - 2220627 - FAQ:SAPHANALOBs                                                                                                                                                                                                                                                                                                                         |
|    324 | ERR_SQL_EXST_SEQ               | cannot use duplicate sequence name                    | 2134323 - Nesting error in SQLRUN_ISU_TRIGGERS: maximum depth 8                                                                                                                                                                                                                                                                                                                                              |
|    325 | ERR_SQL_ESC_SEQ                | invalid escape se- quence                             | 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                                                                                                                                                                                                         |
|    328 | ERR_SQL_INV_FUNC_PROC          | invalid name of func- tion or procedure               | This error indicates that an object (e.g. table) accessed in a database request doesn't exist. Make sure that the application only accesses objects that exist on SAP HANAlevel. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                  |
|    332 | ERR_SQL_INV_USER               | invalid user name                                     | 2433879 - Restricted User getting "Invalid User Name/Password" 2354866 - "Could Not Save the Connection Data; Invalid User Nameor Password" 2506777 - Unable to login after resetting the SYSTEM user's password forHANA 2538907 - Error "Logon to SAP System Host failed" when using updated password to log on HANAsystem 2764976 - 10: authentication failed: ERR_AU- THENTICATION_FAILED SQLSTATE: 28000 |
|    338 | ERR_SQL_ZERO_LEN_NOT_AL- LOWED | zero-length columns are not allowed                   | HANAdoes not support zero-length columns. 2674281 - Error "SAP DBTech JDBC: [338]: zero-length columns are not allowed:"                                                                                                                                                                                                                                                                                     |
|    339 | ERR_SQL_INV_NUMBER             | invalid number                                        | This termination indicates that a number was expected but something else was found. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2972659 - Reason for error "339: invalid number"                                                                                                                                                                                                    |
|    340 | ERR_SQL_VAR_NOT_BOUND           | not all variables bound                              | This termination indicates an issue with bind variable processing. See SAP Note 2380176 -> "unbound parameter: <cnt> of <total>, <cnt> out of <total_batch> batches" for more details. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace                            |
|    348 | ERR_SQL_INV_DATETIME_FOR- MAT   | invalid datetime format                              | 2271717 - SAP HANASDA: Error executing query [Oracle][ODBC]Invalid datetime format. 2933606 - SDA Oracle Remote Query Fails With [Oracle][ODBC]Invalid datetime format                                                                                                                                                       |
|    349 | ERR_SQL_CREATE_UNIQUE_IN- DEX   | cannot CREATE UNIQUE INDEX; dupli- cate key found    | 2838779 - Error "duplicate key found" when trying to recreate a missing primary index                                                                                                                                                                                                                                        |
|    359 | ERR_SQL_STR_LENGTH_TOO_LAR GE   | string is too long                                   | 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2222219 - SAP HANAErrors and different Results due to Design Changes                                                                           |
|    361 | ERR_SQL_VIEW_UPDATE_VIOLA- TION | data manipulation op- eration not legal on this view | 2738610 - How to truncate or delete rows from sys.table_placement-SAPHANA 2638028 - Behavior Correction of Invalid Up- datable View Creation                                                                                                                                                                                 |
|    362 | ERR_SQL_INV_SCHEMA              | invalid schema name                                  | This error indicates that the specified schema name is invalid. Make sure that you specify an existing schema name and that you are author- ized to access the schema. 2535951 - FAQ: SAP HANAUsers and Sche- mas 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace |
|    378 | ERR_SQL_INV_COLUMN_VIEW        | invalid column view                 | This error is known in the context of BWtables: 2134076 - Report RS_BW_POST_MIGRA- TION failing after migrating to theSAPHANA database 2315758 - Error 2048 creation of column view failed when executing report RSDDB_LOGI- NDEX_CREATE 2114556 - Error 2999 has occurred in the BWA/SAP HANAserver                                                                                                                                           |
|    382 | ERR_SQL_COLLECT_ALL_VER- SIONS | fail to collect all version garbage | Indicates blcoked garbage collection issues. See KBA 2169283 - FAQ: SAP HANAGarbage Collection                                                                                                                                                                                                                                                                                                                                                 |
|    383 | ERR_SQL_INV_IDENTIFIER         | invalid identifier                  | This error indicates that a wrong identifier was used. Check the related SQL statement for cor- rectness. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2572224 - How-To: Repairing SAP HANATa- bles 2160391 - FAQ: SAP HANAIndexes 2606638 - How to deal with error "invalid identifier: _sys_ prefix not allowed" 2728304 - "ALTER SEQUENCE" command fails with error: "invalid identifier: _sys_ prefix not allowed" |
|    384 | ERR_SQL_TOO_LONG_CONSTANT      | string is too long                  | 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2222219 - SAP HANAErrors and different Results due to Design Changes                                                                                                                                                                                             |
|    391 | ERR_SQL_INV_USABLE_VIEW        | invalidated view                    | This error indicates that the view <view> is in- valid. This can e.g. happen if the definition of an underlying object changed or an object was dropped. You have to make sure that the view is consistent and valid or avoid accesses / drop the view. 2985592 - Database returned the SQL code 391. Error text: invalidated view                                                                                                             |
|    396 | ERR_SQL_EXST_USER_DE- FINED_TYPE  | cannot use duplicate user-defined type name                      | 2223237 - Troubleshooting HANAEmbed- ded Statistics Server Migration - decision tree 2122188 - ESS disabled due to duplicate cre- ation of TT_MAIL_COLLECTOR                                     |
|    397 | ERR_SQL_INV_OBJ_NAME              | invalid object name                                              | This error indicates that an object isn't found with the specified name (and schema). 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace |
|    398 | ERR_SQL_MANY_ORDER_BY             | cannot have more than one order by                               | Only one ORDER BY clause is allowed in a state- ment                                                                                                                                             |
|    402 | ERR_SQL_DROPPED_USER              | the user was already dropped before query execution              | 2819401 - Errors Related to the _SYS_XB User and Schema When Running theSAPHANA System Migration Tool to Migrate From SAP HANA1.0 to SAP HANA2.0 on IBM Power                                    |
|    403 | ERR_SQL_INTERNAL_ERROR            | internal error                                                   | Generic preamble. Check the HANAservice traces and ABAP dump traces for further infor- mation on the error.                                                                                      |
|    406 | ERR_SQL_CANT_UP- DATE_GEN_COL     | "INSERT UPDATE and UPSERT are disallowed on the generated field" | 3070791 - INSERT, UPDATE and UPSERT are disallowed on the generated field                                                                                                                        |
|    410 | ERR_SQL_INV_PRIVILEGE_NAME- SPACE | invalid privilege name- space                                    | 2428863 - Unable to view any package in- side Content Folder of HANAStudio                                                                                                                       |
|    411 | ERR_SQL_INV_TABLE_TYPE            | invalid table type                                               | 2280915 - CREATE procedure gives error "258 - insufficient privilege: Not authorized er- ror".                                                                                                   |
|    412 | ERR_SQL_INV_PASSWORD_LAY- OUT     | invalid password layout                                          | 2895515 - Mismatch password_layout error occurred in HANA.                                                                                                                                       |
|    414 | ERR_SQL_ALTER_PASS- WORD_NEEDED      | user is forced to change password       | Provide a new password for <user> or disable the password life time if it isn't required (e.g. because it is a pure technical user): 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2137351 - Error: 414 user is forced to change password for SAPDBCTRL (or SAPHA- NADBSHD) 2386570 - SAP DBTech JDBC: [591]: internal error: internal error: user is forced to change password 2136604 - Error InstallingPOonaSAP HANAMulti-tenant Database |
|    415 | ERR_SQL_USER_DEACTIVATED             | user is deactivated                     | 2574644 - SAP HANAdatabase user is deac- tivated 2452650 - User password expired with max- imum_unused_initial_password_lifetime set at shot time 2681997 - You have reached maximum num- ber of invalid password entry attempts. User is locked until ... 3066561 - Parameter detailed_er- ror_on_connect controls what messages are re- turned during error connect attempt                                                                                       |
|    416 | ERR_SQL_USER_LOCKED                  | user is locked; try again later         | This error is typically caused because the max- imum number of invalid connect attempts has been reached. It is controlled by the following SAP HANAparameter: indexserver.ini -> [password policy] -> maxi- mum_invalid_connect_attempts (default: 6) 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                         |
|    420 | ERR_SQL_ALTER_PASS- WORD_NOT_ALLOWED | password change cur- rently not allowed | 2765239 - Password change currently not allowed: minimal password lifetime is x days.                                                                                                                                                                                                                                                                                                                                                                               |
|    423 | ERR_SQL_LVC                          | AFL error                               | Multiple causes, review KBA 2399990 - How- To: Analyzing ABAP Short Dumps inSAPHANA Environments                                                                                                                                                                                                                                                                                                                                                                    |
|    424 | ERR_SQL_INV_PACKAGE                  | invalid name of pack- age               | 1891017 - Grant Repository Access to Root Package in SAP HANAStudio                                                                                                                                                                                                                                                                                                                                                                                                 |
|    430 | ERR_SQL_INV_USABLE_PROC               | invalidated procedure                                               | 2935599 - SQL error 430 (invalidated proce- dure) 2196359 - Limitations for cross-database ac- cess in an SAP HANAMDCenvironment                                                                                                                                     |
|    431 | WRN_SQL_NEARLY_EX- PIRED_PASSWORD     | user's password will expire within few days                         | 1752349 - DBconnection fails with SQL error 431 - user's password will expire within few days 1702224 - Disable password lifetime for technical users                                                                                                                |
|    435 | ERR_SQL_INV_EXP                       | invalid expression                                                  | 2222219 - SAP HANAErrors and different Results due to Design Changes 2044468 - FAQ: SAP HANAPartitioning                                                                                                                                                             |
|    436 | ERR_SQL_SET_SYSTEM_LICENSE            | could not set system li- cense                                      | 2263579 - "could not set system license: 5503: nameserver failed to process the request" error during HANAlicense key installation 2311999 - Permanent license import failed via HDBSQL 2772760 - Unable to apply the permanent license to SYSTEMDB                  |
|    437 | ERR_SQL_ONLY_LICENSE_HAN- DLING       | only commands for li- cense handling are al- lowed in current state | 2728984 - System Has No Valid License. Ex- ecute failed (437) - Instance is registered with permanent license 2781578 - "License Expired" error when ena- bling HDI container in MDCHANAenvironments 2670267 - Error: Get server node failed on connection 0: rc=437 |
|    440 | ERR_SQL_TABLE_TYPE_CONVER- SION_ERROR | table type conversion error                                         | 2397189 - SAP DBTech JDBC: [440]: Table Type Conversion Error During SUMUpgrade in The Phase MAIN_SHDIMP/PARMVNT_SHD                                                                                                                                                 |
|    442 | ERR_SQL_MAX_NUM_COLUMN                | number of columns ex- ceeds its maximum                             | 2154870 - How-To: Understanding and defin- ing SAP HANALimitations                                                                                                                                                                                                   |
|    444 | ERR_SQL_PACKMAN                       | package manager er- ror                                             | 2936298 - SAP HANAExternal Machine Learning Library 2.0 requires libssl 1.0.x                                                                                                                                                                                        |
|    446 | ERR_SQL_EXST_TRIGGER                  | cannot use duplicate trigger name                                   | 2911708 - ERROR [SQL-301] unique con- straint violated: Table(STATISTICS_PROPER- TIES)                                                                                                                                                                               |
|    447 | ERR_SQL_BACKUP_FAILED     | backup could not be completed               | backup could not be completed:' is a preamble to the actual root cause for the error. Please check the HANAservice trace files for more in- formation on the error. Example scenarios: 2472144 - HANABackup Using Backint fails with the error: [447] backup could not be com- pleted, [110203] Not all data could be written 2500531 - Error "ERROR BACKUP SAVE DATA terminated with error: [447] backup could not be completed, [2000004 ] Can not open file" when doing a backup 2399786 - Backup could not be completed: Error calling io_setup 2623425 - Backup could not be completed 2310262 - Error [110026] - Backup could not be completedonHANA 2723171 - [447] backup could not be com- pleted, [3000116 ] Could not acquire save- point lock |
|    448 | ERR_SQL_RECOVERY_FAILED   | recovery could not be completed             | recovery could not be completed:' is a preamble to the actual root cause for the error. Please check the HANAservice trace files for more in- formation on the error. Example scenarios: 2728068 - HANAPoint in time recovery fails - [448] recovery could not be completed 2688972 - Recovery Error: [448] recovery could not be completed, [110021] Object 0 with the value 1024 does not exist-SAPHANA                                                                                                                                                                                                                                                                                                                                                 |
|    449 | ERR_SQL_RECOVERY_STRATEGY | recovery strategy could not be deter- mined | recovery strategy could not be determined: ' is a preamble to the actual root cause for the error. Please check the HANAservice trace files for more information on the error. Example scenarios: 2123153 - [449] recovery strategy could not be determined [110512] Backint duringHANA Recovery 2610577 - Backup destination header is cor- rupt [110063] 2736164 - recovery strategy could not be de- termined - BKI1214E: TSMError for session to                                                                                                                                                                                                                                                                                                      |
|    451 | ERR_SQL_NOT_AL- LOWED_SUBJ_TAB_AC- CESS_TRIGGER | modification of subject table in trigger not al- lowed             | 2800020 - FAQ: SAP HANATriggers 2222219 - SAP HANAErrors and different Results due to Design Changes 2170927 - Create trigger fails with error JDBC: [451]: modification of subject table in trigger not allowed: maximum nesting depth                                                                  |
|    452 | ERR_SQL_INV_BACKUPID                            | invalid backup id                                                  | 2962261 - Backup catalog housekeeping: in- valid backup id 'xxxxxxxxxxx'                                                                                                                                                                                                                                 |
|    454 | WRN_SQL_WRONG_HINT_SYN- TAX                     | wrong hint syntax                                                  | 2939423 - Getting Error while creating View with HINT - incorrect syntax near "HINT"                                                                                                                                                                                                                     |
|    455 | ERR_SQL_READ_ONLY_SES- SION_VARIABLE            | the predefined session variable cannot be set via SET command      | 2470084 - XSUAA metadata for XS_APPLI- CATIONUSER trust creation                                                                                                                                                                                                                                         |
|    459 | ERR_SQL_INV_USABLE_FUNC                         | invalidated function                                               | This termination indicates thataSAPHANA function was accessed that is invalidated. You can use SQL: "HANA_Objects_Functions" (ONLY_INVALID_FUNCTIONS = 'X') available via SAP Note 1969700 to list invalid functions in the system. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments |
|    461 | ERR_SQL_FK_NOT_FOUND                            | foreign key constraint violation                                   | This error indicates that a change failed due to a foreign key constraint violation. 2160391 - FAQ: SAP HANAIndexes 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                 |
|    462 | ERR_SQL_FK_ON_UPDATE_DE- LETE_FAILED            | failed on update or de- lete by foreign key con- straint violation | This error indicates that a change failed due to a foreign key constraint violation. 2160391 - FAQ: SAP HANAIndexes 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                 |
|    463 | ERR_SQL_MAX_NUM_TABLE                           | number of tables ex- ceeds its maximum                             | 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2968736 - HANASQLError 463 - number of tables exceeds its maximum                                                                                                                                                                     |
|    464 | ERR_SQL_MAX_PARSE_TREE_DEP TH | SQL internal parse tree depth exceeds its max- imum         | 2385634 - TREX_EXT_SEARCH_CELL_TA- BLE Leads to SQL Error "parse tree depth ex- ceeds its maximum:255" 2332054 - TREX_EXT_LIST_INDEXES fails with "SQL internal parse tree depth exceeds its maximum: parse tree depth exceeds its maxi- mum:255"                                                                                                                         |
|    465 | ERR_SQL_INV_USABLE_TRIGGER    | "Cannot execute trig- ger was invalidated by object change" | This error is caused by an invalidated trigger (SAP Note 2800020 ) on the underlying ta- ble. 2800020 - FAQ: SAP HANATriggers 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                                        |
|    468 | ERR_SQL_HINT                  | hint error                                                  | Generic preamble to a more detailed error. 2142945 - FAQ: SAP HANAHints 2400006 - FAQ: SAP HANAStatement Hints 2938007 - Query on SAP HANAfails with error 468: hint error 2916954 - Normalization of Whitespaces and Comments of SQL statements in Statement Hints 2570351 - Error 468/ "hint error: invalid hint" From TREX_EXT_SEARCH_CELL_TABLE or TREX_EXT_AGGREGATE |
|    472 | ERR_SQL_EXST_DATA_SOURCE      | cannot use duplicate data source name                       | 2408262 - SAP DBTech JDBC: [472]: cannot use duplicate data source name: __esstore$                                                                                                                                                                                                                                                                                       |
|    474 | ERR_SQL_INV_ADAPTER           | invalid adapter name                                        | 2552938 - Error when altering HANARe- mote Source connection adapter type from SDA to SDI: invalid adapter name - SAP HANA1.0 smart data integration 2440935 - SAP DBTech JDBC: [474] (at 21): invalid adapter name: mii: line 1 col 22 (at pos 21)                                                                                                                       |
|    476 | ERR_SQL_INV_REMOTE_OBJECT                     | invalid remote object name                 | Preamble to a more detailed error: 2262782 - Unable to export or import SAP HANAvirtual tables 2033611 - Limitation of export / import for virtual tables 2775477 - SAP DBTech JDBC: [476]: invalid remote object name: IMPORT_TABLE can't be used for functions. 2607873 - Error when creating file adapter virtual table using SQL - SAP HANASmart Data Integration 2554385 - ODBCError during Import of a HANASchema / Table(s)                                       |
|    478 | ERR_SQL_UDF_RUNTIME                           | user defined function runtime error        | 2945199 - search table error: [6859] Attribu- teEngine: divide by zero 2401963 - Invalid table name exception when calling UDF 2792149 - currency/unit conversion error: conversion type '<conversion type>' has unsup- ported 'BKUZU' or 'GKUZU' type set                                                                                                                                                                                                               |
|    485 | ERR_SQL_INV_STRUC- TURED_PRIVILEGE_DEFINITION | invalid definition of structured privilege | 2250455 - SAP DBTech JDBC 485 - Invalid definition of structured privilege: Invalid filter condition 2762943 - ERROR [SQL-485] invalid defini- tion of structured privilege: Condition 1 = 1 can- not be used for <viewname> 2608634 - Invalid definition of structured privilege when use HANAexternal view for modified composite provider 2563281 - Error message "invalid definition of structured privilege: Complex condition [...] cannot be used for view [...]" |
|    488 | ERR_SQL_INV_DATABASE                          | invalid database name                      | HANATenant or SYSTEMDB System ID (SID) not recognised                                                                                                                                                                                                                                                                                                                                                                                                                    |
|    494 | ERR_SQL_INV_EPMQUERY- SOURCE_DEF              | invalid EPMQuery Source definition         | 2481228 - dberror(PreparedStatement.exe- cuteUpdate): 494 - invalid EPMQuery Source definition: no valid EPMlicense available error in SAP Analytics Cloud (BOC)                                                                                                                                                                                                                                                                                                         |
|    500 | ERR_SQL_REQUIRE_PREDICATE  | predicates are required in a where clause                               | 2748386 - Error "SAP DBTech JDBC: [500]: predicates are required in a where clause" When Running Select * From User Authorization Views 2795522 - Querying EFFEC- TIVE_ROLE_GRANTEES fails with error un- known role_name 2088971 - How-To: Controlling the Amount of Records in SAP HANAMonitoring Views 2564718 - Authorization replication termi- nates with SQL error message "predicates are required in a where clause: unknown user_name" 2541080 - Predicates are required in a where clause in SAP Analytics Cloud (BOC)                                                                                                                                                                                                                        |
|    503 | ERR_SQL_EXST_TASK          | cannot use duplicate name of task                                       | 2695441 - Unable to activate flow graph within the import package - SAP HANASmart Data Integration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|    512 | ERR_REP                    | replication error                                                       | Generic preamble to a more detailed error: 2852687 - HANAREPLICATION ERROR 2754755 - HANAsystem replication error oc- curred 2712064 - SAP HANASystem Replication Er- ror port 4####already in use 2680982 - Error "site to unregister is still online, cannot proceed" When Unregistering the Secondary System in System Replication Envi- ronment 2813089 - Replication mode/status is UN- KNOWNinMDCscenario 2695510 - With Table Replication, Error Mes- sage Flooding in Worker Node Indexserver After Coordinator Node Failed-over 2796783 - Copying/Moving a Tenant Data- base From a System Replication Primary Sys- tem to Another HANASystem Fails When Se- cure Network Communication is Disabled 1999880 - FAQ: SAP HANASystem Replica- tion |
|    513 | ERR_SQL_REP_ALREADY_ACTIVE | cannot execute DDL statement on replica- tion table while repli- cating | DDL like CREATE/ALTER/DROP etc not possi- ble during replication operation                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
|    544 | ERR_RS_PARTITION                 | partition error               | 2930379 - How to increase the total number of partitions for CDPOStable                                                                                                                                                                                                                                                                                 |
|    576 | ERR_API                          | api error                     | 2618451 - SSL API error happened when copy or move tenant database betweenHANA systems 2650994 - SAP HANASystem Replication does not work with DBisolation set to HIGH 2771017 - Replication does not complete due to nameserver error 2561693 - HANADatabase fails to start due to SSL error 2862268 - BI Commentary Guidelines for HANASSLConnections |
|    578 | ERR_API_INV_STATEMENT            | invalid statement             | The issue can be a consequence of problems on lower layers (infrastructure / hardware) result- ing in a malformed statement ID. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                    |
|    589 | ERR_API_TOO_MANY_PARAME- TERS    | too many parameters are set   | 3040627 - Error 589 - too many parameters are set: number of parameters xxxxx exceeds maximum number of parameters, 32767 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                      |
|    592 | ERR_API_NOT_SUP- PORTED_TYPECONV | not supported type conversion | 2962294 - HANAAlert 27 is disabled and will not be called. Reason: timeout SNAPSHOT_ID: <timestamp> 2380176 - FAQ: SAP HANADatabase Trace                                                                                                                                                                                                               |
|    597 | ERR_API_SESSION_CONTEXT_ER- ROR  | session context error         | Preamble to more detailed error described fur- ther in: 2380176 - FAQ: SAP HANADatabase Trace 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                                                      |
|    598 | ERR_API_EXTERNAL_EXECU- TION_FAILURE | Failed to execute the external statement | This is a common preamble to a more detailed error. It can have multiple causes. Please review the error detail from the index- server traces and search the SAP HANAKnowl- edge base for existing Knowledge based articles and SAP Notes. 2776953 -Query Fails With Error "failed to execute the external statement: no such data type:.." in HANAScale-out System                                                                                                                                                                                                                                                       |
|    600 | ERR_API_CALL_ROUTING_FAIL- URE       | failed routed execution                  | Preamble to more detailed error described fur- ther in: 2380176 - FAQ: SAP HANADatabase Trace 2200772 - FAQ: SAP HANAStatement Rout- ing and Client Distribution Mode 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2090424 - Error -10108 (Session has been reconnected) after failover of coordina- tor/worker node 2591281 - Blocked Transactions fromHANA JDBC Client Call - Session Will be Closed due to the Error: [600] failed routed execution 2691896 - Distributed Query Fails With "StatementRouting Connection.cc(xxxxx): failed to join XA session due to active user transac- tion" |
|    603 | ERR_API_INV_LOB                      | invalid LOB                              | 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions 2690991 - Error 5400 Invalid type 64 in column of type 32 at udiv during consistency check 2408032 - Reading From LOB Binary Stream After Closing the ResultSet via JDBC Fails With Error "invalid lob locator id (piecewise lob read- ing)" 3017449 - Indexserver Crash in TRexCom- monObjects::writeRow When Executing an UP- DATE Statement on a Partitioned Table                                                                                                                                                                                           |
|    606 | ERR_API_EXCEED_MAX_LOB_SIZE          | exceed maximum LOB size                  | See 2154870 - How-To: Understanding and defining SAP HANALimitations                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
|    608 | ERR_API_EXCEED_MAX_PRE- PARED_STATEMENT             | exceed maximum number of prepared statements         | System limitation. Described further in: 3031816 - "ERROR [SQL-608] exceed maxi- mumnumberof prepared statements" and "the number of prepared statements per connection cannot exceed <number>" 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace |
|    613 | ERR_API_TIMEOUT                                     | execution aborted by timeout                         | This error indicates that a database request hit the timeout (in seconds) 2000003 - FAQ:SAPHANA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 3116306 - [Error] execution aborted by time- out while partitioning                                                                                                                                      |
|    640 | ERR_SQL_2                                           | sql processing error                                 | Starting with SAP HANARev. 122.03 the THROW_ERROR hint is available (SAP Note 2436893 ) that terminates the execution of the underlying database request 2380176 FAQ: SAP HANADatabase Trace 2073630 - DBIF_RSQL_SQL_ERROR SQL er- ror 256 when access table 2142945 FAQ: SAP HANAHints                                                                                       |
|    648 | ERR_SQL_TRIG- GER_AND_PROC_NEST- ING_DEPTH_EXCEEDED | nesting depth of trig- ger and procedure is exceeded | System limitation: 2134323 - Nesting error in SQLRUN_ISU_TRIGGERS: maximum depth 8 2977828 - Trigger Creation Fails With 'nest- ing depth of trigger and procedure is exceeded' 2130431 - 'Nesting depth of trigger and pro- cedure is exceeded' error is raised when SQL trigger with procedure call is created                                                              |
|    651 | ERR_SQL_EXST_OBJECT                                 | cannot use duplicate object name                     | 2572224 - How-To: Repairing SAP HANATa- bles                                                                                                                                                                                                                                                                                                                                  |
|    663 | ERR_SQL_CONNECT_NOT_AL- LOWED                       | user not allowed to connect from client              | 3171342 - ERROR [SQL-663] user not al- lowed to connect from client                                                                                                                                                                                                                                                                                                           |
|    684 | ERR_SQL_PLANSTABIL- IZER_STORED_HINT_RECORD_AL- READY_EXISTS | plan stabilizer stored hint error - statement hint record already ex- ists | 2700051 - Delivery of Statement Hints (SAP HANA>=1.00.122.03) 2400006 - FAQ: SAP HANAStatement Hints                                                                                                                                                                                                                                                                                                |
|    685 | ERR_SQL_PLANSTABIL- IZER_STORED_HINT_RE- CORD_DOES_NOT_EXIST | plan stabilizer stored hint error - statement hint record does not exist   | 2700051 - Delivery of Statement Hints (SAP HANA>=1.00.122.03) 2400006 - FAQ: SAP HANAStatement Hints                                                                                                                                                                                                                                                                                                |
|   1024 | ERR_SES                                                      | session error                                                              | Preamble to more detailed error: 2303494 - Importing Delivery Unit fails with "Session error: Repository: Activation failed for at least one object" 2280915 - CREATE procedure gives error "258 - insufficient privilege: Not authorized er- ror". 2775970 - The re-import of a delivery unit fails after an upgrade                                                                               |
|   1025 | ERR_COM                                                      | communication error                                                        | Network or communication related problem 2222200 - FAQ: SAP HANANetwork 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2000003 - FAQ:SAPHANA                                                                                                                                                                                                                                  |
|   1026 | ERR_COM_LISTEN                                               | cannot bind a commu- nication port                                         | 2261671 - "cannot bind to the local port" when start HANAservices                                                                                                                                                                                                                                                                                                                                   |
|   1033 | ERR_SES_INV_PROTOCOL                                         | error while parsing protocol                                               | These terminations indicate a severe prob- lem during parsing the communication pro- tocol. Check the database trace (SAP Note 2380176 ) for more details. Typically you will find an error "failed to encode cursor: error while parsing protocol" with further accompany- ing details. 2380176 - FAQ: SAP HANADatabase Trace 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments |
|   1037 | ERR_COM_UNKNOWN_HOST                                         | unknown hostname                                                           | 2941074 - SAP HANAserver rebooted 2936450 - SAP HANAis down without crash or shutdown                                                                                                                                                                                                                                                                                                               |
|   1038 | ERR_SES_SERVER_BUSY                       | rejected as server is temporarily over- loaded          | 2908549 - SAP HANADatabase requests fail with error code 1038 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2222250 - FAQ: SAP HANAWorkload Man- agement 3061965 - Unexpected Error "rejected as server is temporarily overloaded"                                                                 |
|   1335 | ERR_SQLSCRIPT_RUNTIME_CY- CLIC_DEPENDENCY | Cyclic dependency found in a runtime pro- cedure        | 3032114 - Cyclic Dependency Error When Revoking Role From User Through GRCin SPS05 3018242 - Removing Role From User via HANAor GRCCanCause Cyclic Dependency Error                                                                                                                                                       |
|   1793 | ERR_SHM_CREATE_INVALID                    | invalid key or invalid size                             | This issue can arise due to wrong configuration of shared memory setting on OSlevel. 2827664 - NameServer persistence initiali- zation failed                                                                                                                                                                             |
|   2048 | ERR_CS                                    | Column store error                                      | Generic preamble to a more detailed error de- scription: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 1999997 - FAQ:SAPHANAMemory 2222200 - FAQ: SAP HANANetwork 2044468 - FAQ: SAP HANAPartitioning 2380176 - FAQ: SAP HANADatabase Trace                                                        |
|   2054 | ERR_CS_DELTA_LOG_RE- PLAY_FAILED          | Redo log replay failed                                  | Check HANAservice traces for more detail on the error cause                                                                                                                                                                                                                                                               |
|   2055 | ERR_CS_MAXIMUM_ROW                        | Maximum number of rows per table or parti- tion reached | System limitation: 2212518 - HANAerror maximum number of rows per partition reached 2154870 - How-To: Understanding and defin- ing SAP HANALimitations 2964715 - Maximum number of rows per table or partition reached: '_SYS_AUDIT:CS_AU- DIT_LOG_' 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments |
|   2560 | ERR_METADATA                          | Metadata error                  | Preamble to more detailed error: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2380176 - FAQ: SAP HANADatabase Trace 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions                                                                                                                                                                                                                                                                  |
|   2561 | ERR_DIST_METADATA                     | Distributed metadata error      | 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions 2245772 - distributed metadata error: Failed to get table location during table lock - Error during BWupgrade or migration                                                                                                                                                                                                                                                                                   |
|   2566 | ERR_DIST_META- DATA_TNSCLIENT_FAILURE | Distributed environ- ment error | 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions 2240241 - Failed to update dependency: dis- tributed environment error 2447887 - Removing Multiple Services from HANAScale Out Environment Can Lead to Data Loss 2062308 - Deadlock Between Worker and Coordinator Node During Worker Startup 2433918 - Execution of a Stored Procedure Fails With the Message "distributed environ- ment error: table already exists;newIndex(..): catalog creation failed" |
|   2567 | ERR_DIST_METADATA_NET- WORK_FAILURE   | Network error                   | Generic preamble to a more detailed descrip- tion: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 1999880 - FAQ: SAP HANASystem Replica- tion 2057046 - FAQ: SAP HANADelta Merges 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions                                                                                                                                                                                                      |
|   3584 | ERR_DIST_SQL                            | Distributed SQL error                                                     | Generic preamble to a more detailed descrip- tion: 1999997 - FAQ:SAPHANAMemory 1999998 - FAQ: SAP HANALock Analysis 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions 2380176 - FAQ: SAP HANADatabase Trace 2901387 - Unable to run HANA_Configura- tion_MiniChecks_2.00.040+ 3105683 - A Query Fails With an Error "dis- tributed SQL error: [18] A received argument has an invalid value" 3121246 - SQL error "SAP DBTech JDBC: [3584]: distributed SQL error: [18] A received argument has an invalid value" 1969700 - SQL Statement Collection for SAP HANA |
|   3587 | ERR_DIST_SQL_INVALID_PROTO- COL         | Invalid protocol or service shutdown dur- ing distributed query execution | The following error messages can indicateOOM situations. Be aware that some of the errors can also be issued in other scenarios. To make sure that they are really memory related, you have to check the related trace file. 1999997 - FAQ:SAPHANAMemory                                                                                                                                                                                                                                                                                                                 |
|   3589 | ERR_DIST_SQL_REMOTE_EXECU- TION_FAILURE | Remote query execu- tion failure                                          | 2439128 - Error 3589 - "remote query execu- tion failure" When Opening XS Applications                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
|   3841 | ERR_AUDITING_NO_PRIV_NAME               | Invalid privilege                                                         | 2428863 - Unable to view any package in- side Content Folder of HANAStudio                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
|   3843 | ERR_AUDITING_POLICY_AL- READY_EXISTS    | Audit policy with cur- rent name already ex- ists                         | Policy name already created as per "CREATE AUDIT POLICY ... "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|   3844 | ERR_AUDITING_INV_POL- ICY_TYPE          | Invalid combination of audit actions                                      | Check auditing configuration and setup: Auditing Activity inSAPHANA Audit Policies Audit Trails Auditing Configuration and Audit Policy Man- agement Best Practices and Recommendations for Cre- ating Audit Policies Configuring Database Auditing                                                                                                                                                                                                                                                                                                                      |
|   3846 | ERR_AUDITING_INV_LEVEL                | Invalid auditing level                              | Check auditing configuration and setup: Auditing Activity inSAPHANA Audit Policies Audit Trails Auditing Configuration and Audit Policy Man- agement Best Practices and Recommendations for Cre- ating Audit Policies Configuring Database Auditing |
|   3847 | ERR_AUDITING_INV_POL- ICY_NAME        | Invalid policy name                                 | Check auditing configuration and setup: Auditing Activity inSAPHANA Audit Policies Audit Trails Auditing Configuration and Audit Policy Man- agement Best Practices and Recommendations for Cre- ating Audit Policies Configuring Database Auditing |
|   3848 | ERR_AUDITING_INV_ACTION_OB- JECT_TYPE | Invalid combination of audit action and object type | Check auditing configuration and setup: Auditing Activity inSAPHANA Audit Policies Audit Trails Auditing Configuration and Audit Policy Man- agement Best Practices and Recommendations for Cre- ating Audit Policies Configuring Database Auditing |
|   3849 | ERR_AUDITING_INV_OB- JECT_TYPE        | Audit policy for this object type not sup- ported   | Check auditing configuration and setup: Auditing Activity inSAPHANA Audit Policies Audit Trails Auditing Configuration and Audit Policy Man- agement Best Practices and Recommendations for Cre- ating Audit Policies Configuring Database Auditing |
|   4096 | ERR_PLANVIZ_GENERAL                             | [PlanViz] general error                                 | 2275905 - How to disallow the Usage of PlanViz in a SAP HANASystem 2825090 - PlanViz for a DMLStatement on Row Store Table Fails in Scale-Out System 2337716 - SAP DBTech JDBC: [4096]: [Plan- Viz] general error: Not supported yet; Please update your server instance                                                                                                                                |
|   4098 | ERR_PLANVIZ_INVA- LID_PLAN_GENERAL              | [PlanViz] invalid plan                                  | 2781336 - PlanViz Execution Fails With "inva- lid plan -- try preparing statement again"                                                                                                                                                                                                                                                                                                                |
|   4104 | ERR_PLANVIZ_PLAN_NOT_FOUND                      | [PlanViz] plan not found                                | 2337716 - SAP DBTech JDBC: [4096]: [Plan- Viz] general error: Not supported yet; Please update your server instance                                                                                                                                                                                                                                                                                     |
|   4105 | ERR_PLANVIZ_UNSUP- PORTED_STMT_TYPE             | [PlanViz] unsupported statement type                    | 2822978 - Statement Execution Fails In SAP HANAStudio after PlanViz Generation Failed                                                                                                                                                                                                                                                                                                                   |
|   4109 | ERR_PLAN- VIZ_TRACE_ONLY_GENERAL                | [PlanViz] error in trace-only mode                      | Due to a SAP HANAbug this error can happen when plan trace is activated with a statement hash filter on SAP HANA<=2.00.046. Make sure that the plan trace is only activated when really required and optimally in non-production systems. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments 2781336 - PlanViz Execution Fails With "inva- lid plan -- try preparing statement again" |
|   4249 | ERR_USER_PARAM_DUPLI- CATE_EMAIL_ADDRESS        | Same email address cannot be used for dif- ferent users | 2845742 - SAP HANACockpit user deletion after failed logon attempts with wrong password                                                                                                                                                                                                                                                                                                                 |
|   4251 | ERR_USER_PARAM_INVA- LID_STATEMENT_MEMORY_LIMIT | Invalid statement memory limit                          | Setting User Parameters for Workload 2222250 - FAQ: SAP HANAWorkload Man- agement                                                                                                                                                                                                                                                                                                                       |
|   4252 | ERR_USER_PARAM_INVA- LID_STATEMENT_THREAD_LIMIT | Invalid statement thread limit                          | Setting User Parameters for Workload 2222250 - FAQ: SAP HANAWorkload Man- agement                                                                                                                                                                                                                                                                                                                       |
|   4274 | ERR_KERBEROS_DUPLI- CATE_PROVIDER   | Duplicate specification of identity for KER- BEROS | 2921965 - Duplicate specification of identity for KERBEROS                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
|   4280 | ERR_TICKET                          | General ticket error                               | 2872841 - Cannot Load Tile Error on Fiori Launchpad                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|   4321 | ERR_SSL_ENFORCE                     | Only secure connec- tions are allowed              | Preamble to more detailed error: 2999904 - hdbsql failed with error "4321: only secure connections are allowed SQLSTATE: HY000". 2475246 - How to configure HANADBcon- nections using SSL from ABAP instance 2572975 - Solman monitoring of only spe- cific HANADBsusing SSL 3168368 - After setting sslenforce as true in HANAdatabase, the R3trans, transport in ABAP are failing 2818623 - Enabled SSL DBCOconnection SolMan to HANAresult in sql error 4321 3028338 - "Only secure connections are al- lowed" in HDB_CHK_PRIVILEGES phase with SUM1.0 2420711 - FAQ: SAP HANAXimoStudio 2795610 - Enabling SSO in HANACockpit Manager of SAP HANACockpit 2 Fails When sslEnforce=true on the Remote SAP HANASys- tem 3083365 - User Provided Service connec- tions with SSL functionality is not available in SAP HANAWebIDEfor HANA(On-Premise) |
|   5136 | ERR_TEXT_COMMON_ALLOCA- TION_FAILED | Allocation failed.                                 | Memory allocation failure. Preamble to more de- tailed error: See '1. Which indications exist forSAPHANA memory problems?' - 1999997 - FAQ: SAP HANAMemory                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
|   5170 | ERR_TEXT_COM- MON_FILE_NOT_FOUND      | File not found.                                                                 | This a generic error where an expected system, library (dll) file or third party client driver file cannot be found at the expected or configured directory location. Some example scenarios: 2349144 - HANAinstance does not stop - kill.sap file not found 2981347 - Failed to create an SDA connec- tion between HANAand DB2 - Can't open lib '/ opt/IBM/db2/dsdriver/lib/libdb2o.so.1': file not found 2928047 - libsqora.so.11.1': file not found |
|   5172 | ERR_TEXT_COMMON_INVA- LID_LENGTH      | Invalid length.                                                                 | Table column inconsistency. 2905396 - Error 5995 reported by check_ta- ble_consistency 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions                                                                                                                                                                                                                                                                                                       |
|   5533 | ERR_TEXT_PREPROCES- SOR_FAILED        | Preprocessor: failed                                                            | This error indicates a problem when communi- cating with the preprocessor service, e.g. in con- text of text searches. You can check the prepro- cessor database trace (SAP Note 2380176 ) for further details. 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANAEnvironments                                                                                                                                                                   |
|   5634 | ERR_CERTADM_INVA- LID_CERT_DEFINITION | Certificate definition inconsistent                                             | 2975450 - Error: "5634: Certificate definition inconsistent" when import Trusted Certificate via SQL                                                                                                                                                                                                                                                                                                                                                   |
|   5637 | ERR_CERTADM_CERTIFI- CATE_IN_USE      | Certificate could not be dropped because it is still in use by at least one PSE | 3169349 - Certificate could not be dropped because it is still in use by at least one pse                                                                                                                                                                                                                                                                                                                                                              |
|   5736 | ERR_MASKING_INVALID_COL- UMN_DATATYPE | Masking: not sup- ported data type                                              | 2669149 - Masking: not supported data type: exception 4075007 : column col- umn_name does not have a character string data type and cannot be masked                                                                                                                                                                                                                                                                                                   |