Each SAP HANA error has a numeric error code. The M_ERROR_CODES system view contains information about the error codes.
To get a complete list of error codes and their descriptions, execute the following query:
SELECT * FROM M_ERROR_CODES ORDER BY CODE ASC;
Output will be as below,
| CODE | CODE_STRING | DESCRIPTION |
|---|---|---|
| 1 | WRN_GENERAL | general warning |
| 2 | ERR_GENERAL | general error |
| 3 | FATAL_GENERAL | fatal error |
| 4 | FATAL_OUT_OF_MEMORY | cannot allocate enough memory |
| 5 | ERR_INIT | initialization error |
| 6 | ERR_DATA | invalid data |
| 7 | ERR_FEATURE_NOT_SUPPORTED | feature not supported |
| 8 | ERR_INV_ARGUMENT | invalid argument |
| 9 | ERR_INDEX_OUT_OF_BOUNDS | index out of bounds |
| 10 | ERR_AUTHENTICATION_FAILED | authentication failed |
| 11 | ERR_INV_STATE | invalid state |
| 12 | ERR_FILE_OPEN_FAILED | cannot open file |
| 13 | ERR_FILE_CREATE_WRITE_FAILED | cannot create/write file |
| 14 | ERR_DISK_SPACE_SHORTAGE | cannot allocate enough disk space |
| 15 | ERR_FILE_NOT_FOUND | cannot find file |
| 16 | ERR_RETRY_STATEMENT | statement retry |
To get information about a specific error code, execute the following query:
SELECT * FROM M_ERROR_CODES WHERE CODE=[ERROR_CODE_NUMBER];
Example as below,
SELECT * FROM M_ERROR_CODES WHERE CODE=139
| CODE | CODE_STRING | DESCRIPTION |
|---|---|---|
| 139 | ERR_TX_ROLLBACK_QUERY_CANCEL | current operation cancelled by request and transaction rolled back |
