HANA SQL Error Message (1-294)

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
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
17	ERR_CATA_VER_MISMATCH	metadata schema version incompatible between database and executable file
18	ERR_SERVICE_SHUTDOWN	service shutting down
19	ERR_INV_LICENSE	invalid license
20	ERR_CON_OUTSIDE_VALIDITY_PERIOD	connect attempt outside user's validity period
21	ERR_PERSISTENCE	persistence error
128	ERR_TX	transaction error
129	ERR_TX_ROLLBACK	transaction rolled back by an internal error
130	ERR_TX_ROLLBACK_INTEGRITY	transaction rolled back by integrity constraint violation
131	ERR_TX_ROLLBACK_LOCK_TIMEOUT	transaction rolled back by lock wait timeout
132	ERR_TX_ROLLBACK_RESOURCE	transaction rolled back due to unavailable resource
133	ERR_TX_ROLLBACK_DEADLOCK	transaction rolled back by detected deadlock
134	FATAL_REC_CHKPT_FILE_FAIL	failure in accessing checkpoint file
135	FATAL_REC_ANCHOR_FILE_FAIL	failure in accessing anchor file
136	FATAL_REC_LOG_FILE_FAIL	failure in accessing log file
137	FATAL_REC_ARCHIVE_FILE_FAIL	failure in accessing archive file
138	ERR_TX_SERIALIZATION	transaction serialization failure
139	ERR_TX_ROLLBACK_QUERY_CANCEL	current operation cancelled by request and transaction rolled back
140	ERR_TX_INV_TID	invalid write-transaction identifier
141	ERR_INV_LOG_FILE_FAIL	failure in accessing invisible log file
142	ERR_TX_EXCEED_MAX_TX_NUM	exceed max num of concurrent transactions
143	ERR_TX_SERIALIZATION_WITH_TIMEOUT	transaction serialization failure until timeout expires
144	ERR_TX_ROLLBACK_UNIQUE_VIOLATED	transaction rollback unique constraint violated
145	ERR_TX_DIST_FAILURE	transaction distribution work failure
146	ERR_TX_LOCK_ACQUISITION_FAIL	Resource busy and NOWAIT specified
147	ERR_TX_DATA_LOG_INCONSISTENT	inconsistency between data and log
148	ERR_TX_START_BLOCKED	transaction start is blocked until Master_Restart finishes
149	ERR_TX_DIST_2PC_FAILURE	distributed transaction commit failure
150	ERR_TX_SNAPSHOT_TOO_OLD	statement cancelled or snapshot timestamp already invalidated
151	ERR_TX_ROLLBACK_ROW_STORE_FULL	transaction rollback exceed max size of persistent row store data space
152	ERR_TX_ROLLBACK_ROW_STORE_FULL_DBAREQ	transaction rollback exceed max size of persistent row store data space request DBAdmin's action
153	ERR_TX_SERIALIZATION_UNLOCK_REQUIRED	transaction serialization failure internally used to distinguish serialzation failure caused by delete and other versions
154	ERR_TX_INDEX_HANDLE_ACQUISITION_FAIL	failure in acquiring index handle
155	ERR_TX_ROLLBACK_DEFERRED_FK	transaction rollback deferred fk constraint violation
208	ERR_TX_XAER	XA transaction error
209	ERR_TX_XAER_ASYNC	asynchronous operation error
210	ERR_TX_XAER_DUPID	duplicate XID
211	ERR_TX_XAER_INVAL	invalid argument of XA call
212	ERR_TX_XAER_NOTA	no valid XID
213	ERR_TX_XAER_OUTSIDE	outside of global transaction
214	ERR_TX_XAER_PROTO	improper XA call sequence
215	ERR_TX_XAER_RMERR	resource manager error
216	ERR_TX_XAER_RMFAIL	Resource manager unavailable
217	ERR_TX_XA_RBPROTO	A protocol error occurred in the resource manager
218	ERR_TX_XA_RBROLLBACK	The rollback was caused by an unspecified reason
256	ERR_SQL	sql processing error
257	ERR_SQL_PARSE	sql syntax error
258	ERR_SQL_INSUFF_PRIV	insufficient privilege
259	ERR_SQL_INV_TABLE	invalid table name
260	ERR_SQL_INV_COLUMN	invalid column name
261	ERR_SQL_INV_INDEX	invalid index name
262	ERR_SQL_INV_QUERY	invalid query name
263	ERR_SQL_INV_ALIAS	invalid alias name
264	ERR_SQL_INV_DATATYPE	invalid datatype
265	ERR_SQL_MISSING_EXP	expression missing
266	ERR_SQL_INCNST_DATATYPE	inconsistent datatype
267	ERR_SQL_LONG_LEN_TYPE	specified length too long for its datatype
268	ERR_SQL_AMBG_COLUMN	column ambiguously defined
269	ERR_SQL_MANY_VALUES	too many values
270	ERR_SQL_FEW_VALUES	not enough values
271	ERR_SQL_DPLC_ALIAS	duplicate alias
272	ERR_SQL_DPLC_COLUMN	duplicate column name
273	ERR_SQL_LONG_CHAR	not a single character string
274	ERR_SQL_INS_LARGE_VALUE	inserted value too large for column
275	ERR_SQL_NOT_FUNCTION	aggregate function not allowed
276	ERR_SQL_NOT_SINGLE_GROUP	missing aggregation or grouping
277	ERR_SQL_NOT_GROUP_EXP	not a GROUP BY expression
278	ERR_SQL_NESTED_WO_GROUP	nested group function without GROUP BY
279	ERR_SQL_TOO_DEEP_NESTED	group function is nested
280	ERR_SQL_ORDER_EXCEED_NUM	ORDER BY item must be the number of a SELECT-list
281	ERR_SQL_OUTER_IN_OR	outer join not allowed in operand of OR or IN
282	ERR_SQL_OUTER_CROSS_JOIN	two tables cannot be outer-joined to each other
283	ERR_SQL_OUTER_MORE_TWO	a table may be outer joined to at most one other table
284	ERR_SQL_JOIN_NOT_MATCH	join field does not match
285	ERR_SQL_INV_JOIN_PRED	invalid join condition
286	ERR_SQL_LONG_IDENTIFIER	identifier is too long
287	ERR_SQL_NOT_NULL	cannot insert NULL or update to NULL
288	ERR_SQL_EXST_TABLE	cannot use duplicate table name
289	ERR_SQL_EXST_INDEX	cannot use duplicate index name
290	ERR_SQL_EXST_QUERY	cannot use duplicate query name
291	ERR_SQL_NOT_POS_ARGUMENT	argument identifier must be positive
292	ERR_SQL_FEW_ARGUMENT	wrong number of arguments
293	ERR_SQL_INV_ARGUMENT	argument type mismatch
294	ERR_SQL_MANY_PRIMARY_KEY	cannot have more than one primary key

You May Also Like

HANA SQL Error Message (5142 – 5737)

HANA SQL Error Message (4096 – 5141)

HANA SQL Error Message (1801 – 3849)

HANA SQL Error Message (661 – 1800)

Leave a Reply?Cancel reply