Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

SAP HANA, SQLDBC and MaxDB Error Codes

|| 0

SAP HANA, SQLDBC and MaxDB Error Codes
Stechies

List of SAP HANA, SQLDBC and MaxDB Error Codes

When we are trying to connect Netweaver to different SQLDBC libraries to databases such as SAP HANA or SAP MaxDB, it might be useful to have a brief explaination for the various error codes.

Following list is from HANA error codes, however it might be used also in MaxDB.

// Environment, Tracing, Filehandling 10000 - 10099

-10803, "", "Allocation of shared memory failed "%s" of size %d failed" },
-10803, "", "Allocation of shared memory failed (%s)" },
-10808, "", "Feature (%s) not implemented yet in module: %s line: %d" },
-10001, "", "System error: %s." },
-10003, "", "Feature not supported for kernel version %d" },
-10810, "", "Session already in use" },

// Connection 10100 - 10199

-10807, "", "Connection down: [%d] %.*s" },
-10857, "", "Missing database name for connection" },
-10715, "", "Missing user name for connection" },
-10715, "", "Missing password for connection" },
-10709, "", "Connection failed (%s:%s)" },
-10709, "", "Connection failed (%s:[%d] %s)" },
-10709, "", "Data format '%s' not supported by the engine" },
-10709, "", "Connection failed" },
-10100, "", "Invalid value for option '%s' of SQLDBC_ConnectProperties" },
-10101, "", "Invalid value for ISOLATIONLEVEL (%s)" },
-10101, "", "Invalid value for ISOLATIONLEVEL (%d)" },
-10102, "", "Invalid value for PACKETCOUNT (%s)" },
-10103, "", "Invalid value for STATEMENTCACHESIZE (%s)" },
-10104, "", "Invalid value for KEY" },
-10104, "", "Invalid value for KEY (%s)" },
-10105, "01S02", "Codepage not supported (%s)" },
-10106, "", "Invalid client application id (%s)" },
-10757, "", "Secure store error: %s:%d - (%d) %s" },
-10757, "", "XUSER error (%s)"},
-10107, "", "Authentication failed." },
-10107, "", "Authentication failed (%s)." },
-10108, "", "Session has been reconnected." },
-10709, "", "Connection failed (no reachable host left)" },

// API handling 10200 - 10299

-10200, "HY010", "Function sequence error (data for execution expected)" },
-10201, "HY010", "Function sequence error (no data for execution expected)" },
-10202, "HY010", "Function sequence error (operation was aborted by disconnect)" },
-10210, "HY010", "Invalid command state (No prepared SQL command)" },
-10220, "HY010", "Calling %s is not allowed for %s." },
-10221, "HY010", "Command info to long [length is %d maximum length %d]" },

// Parameter, Column handling 10300 - 10399

-10300, "07009", "Invalid parameter index" },
-10300, "07009", "Invalid parameter index %d" },
-10300, "07009", "Invalid parameter index 0" },
-10301, "" , "Invalid host type (%s) for parameter (%d)" },
-10304, "07002", "Parameter/Column (%d) not bound." },
-10305, "HY090", "Parameter (%d) contains null pointer" },
-10306, "HY090", "Negative buffer length for parameter (%d) not allowed (found %d)" },
-10307, "HY090", "Invalid length or indicator value for parameter (%d)" },
-10308, "HY019", "Non-character and non-binary data for parameter (%d) for piece wise insert not allowed" },
-10310, "07009", "Invalid column index (%d)" },
-10312, "HY020", "Attempt to concatenate to a NULL or DEFAULT value for parameter (%d)" },
-10313, "HY010", "Requested parameter (%d) was already processed" },
-10314, "HY010", "Invalid parameter processing sequence, process"
-10315, "" , "Invalid start position (%d)" },
-10316, "HY010", "DATA AT EXECUTE for parameter (%d) not allowed (conflicts "
-10317, "HY010", "LOB type for parameter (%d) not allowed (conflicts "
-10318, "HY010", "Invalid LOB object" },
-10319, "HY010", "Could not read LOB for parameter/column (%d)" },
-10319, "HY010", "Could not write write LOB for parameter/column (%d)" },
-10320, "HY010", "LOB already closed LOB for parameter/column (%d)" },
-10320, "HY010", "LOB is closed by transaction end" },
-10321, "HY010", "LOB invalidated by a previous error for "
-10322, "HY010", "Could not insert LOB." " Parameter/column (%d) has a NULL/DEFAULT value" },
-10323, "HY019", "Non-character and non-binary data for parameter/column (%d) was "
-10861, "HY010", "Invalid use of null pointer for stream handle in parameter (%d)" },
-10324, "HY010", "Stream with id (%d) not found" },
-10325, "HY010", "Stream parameter (%d) is not an input parameter (callback missing)" },
-10325, "HY010", "Stream parameter (%d) is not an output parameter (callback missing)" },
-10862, "HY010", "Stream parameter (%d), error (%d) in read procedure" },
-10862, "HY010", "Stream parameter (%d), error in write procedure" },
-10326, "HY010", "No data found for stream (%d), but data was expected" },
-10327, "HY010", "Invalid use of null pointer in stream parameter field " "of stream descriptor for parameter/column (%d)" },
-10328, "HY010", "Mismatch of number of stream members for parameter (%d) "
-10329, "HY010", "Invalid serial value requested, must be first or last value." },
-10330, "HY010", "Multiple stream output sequence error, unexpected '%s' part." },
-10331, "HY010", "Input stream callback buffer overflow for table id %d, " "allowed %d, written %d bytes." },
-10332, "HY010", "No callback function supplied for stream parameter %d." },
-10333, "", "Unsupported database type in parameter/column (%d)." },
-10334, "HY010", "No BLOB/CLOB for DATA AT EXECUTE currently supported as procedure parameter (%d)." },
-10335, "HY010", "Cannot use BLOB/CLOB parameter %d before parameter %d is processed." },
-10336, "HY010", "Switch between different BLOB/CLOB parameters in procedure not supported."},
-10337, "HY010", "Cannot set keep-alive mode for LOB parameter (%d)."},
-10338, "HY010", "Cannot use an uninitialized LOB object for copy in parameter (%d)."},
-10339, "HY010", "Cannot copy LOB from other connection in parameter (%d)."},
-10340, "HY010", "Cannot copy LOB of different types onto each other for parameter (%d)."},
-10341, "", "Cannot use LOB copy semantics for database procedures in parameter (%d)." },
-10342, "HY010", "Invalid or too long LOB search pattern" },
-10343, "HY010", "LOB parameter not supported for database procedure" },
-10345, "HY010", "LOB parameter type unsupported in array commands (parameter %d)" },
-10346, "", "ABAP stream handling error" },

// Data Conversion 10400 - 10499

-10400, "", "Conversion looses significant digits for parameter/column (%d)" },
-10401, "", "Conversion of parameter/column (%d) would truncate data" },
-10811, "", "Numeric overflow for parameter/column (%d) source type %s, target type %s, value '%s'" },
-10802, "", "Invalid numeric value for parameter/column (%d) source type %s, target type %s" },
-10404, "", "Conversion not supported for parameter/column (%d), source type %s and target type %s" },
-10405, "" , "Cannot convert UCS2 data to ASCII for parameter/column (%d)" },
-10406, "", "Invalid data length for UCS2 data for parameter/column (%d)" },
-10407, "" , "Corrupted UTF8 data for parameter/column (%d)" },
-10408, "" , "Character conversion failed" },
-10410, "22007", "Date/Time format is not supported for parameter (%d)" },
-10411, "", "Illegal DATE value for parameter/column (%d)" },
-10412, "", "Illegal TIME value for parameter/column (%d)" },
-10413, "", "Illegal TIMESTAMP value for parameter/column (%d)" },
-10414, "", "Conversion from binary value to string is not enabled for " "parameter/column (%d)" },
-10415, "", "Indicator must not be a null pointer for DECIMAL input value " " for parameter/column (%d)" },
-10416, "", "Invalid indicator value for DECIMAL input value for " " parameter/column (%d)" },
-10417, "", "Invalid definition for DECIMAL input value for paramater/column "
-10418, "", "Buffer for DECIMAL too short for parameter/column (%d)" },
-10419, "", "Character value contains non-ASCII characters (%d)" },
-10420, "", "Could not convert byte buffer to hexadecimal string for " "parameter/column (%d)" },
-10421, "", "Could not convert too large LONG data for parameter/column (%d)" },
-10422, "01004", "Appending data to binary output not supported for parameter/column (%d)" },
-10423, "22003", "Appending data to binary output not supported for numeric parameter/column (%d)" },
-10424, "22003", "Conversion from %s data to binary would truncate data for parameter/column (%d)" },
-10425, "", "Search pattern is too long for parameter/column (%d)" },
-10426, "", "Internal error: No data available at column (%d)" },
-10427, "", "Conversion of parameter (%d) to %s failed" },
-10427, "", "Conversion of parameter (%d) from data type %s to %s failed" },
-10427, "", "Conversion of parameter (%d) from data type %s to %s failed (%s)" },
-10427, "", "Conversion of character parameter (%d) failed with return code %d" },
-10428, "", "Unsupported length %d of decimal float parameter/column (%d)" },

// Retrieving results and array commands 10500 - 10599

100, "02000", "Row not found" },
-10500, "", "Result set is closed" },
-10500, "", "Result set is closed (transaction end)" },
-10501, "S1109", "Invalid position in resultset: before first row" },
-10502, "S1109", "Invalid position in resultset: after last row" },
-10503, "", "The operation is not allowed for result set type FORWARD_ONLY" },
-10504, "", "Invalid position (%d) for rowset" },
-10505, "", "Result set type is UPDATABLE but row set type is READ_ONLY." },
-10506, "", "Result set type is READ_ONLY but row set type is UPDATABLE" },
-10507, "", "Internal error: No metadata available for rowset operation" },
-10508, "", "Invalid encoding of column name for column %d for rowset operation"},
-10509, "", "The statement was not executed with updatable cursor concurrency" },
-10511, "", "No error available for given row number" },
-10856, "", "Invalid row array size 0" },
-10510, "21S02", "Degree of derived table does not match column list" },
-10512, "", "Row not processed due to previous error" },

// Statement execution 10600 - 10699

-10821, "", "Session not connected" },
-10601, "", "SQL command is the empty string" },
-10602, "", "SQL command contains UNICODE character" },
-10603, "", "SQL command would generate a result set" },
-10604, "", "SQL command contains output parameters" },
-10706, "", "Statement too long" },
-10605, "", "Illegal schema modification, parameters/columns have changed type/number incompatibly" },
-10689, "", "Assertion error: %s" },
-10690, "", "Selected column (%d) is not referenced by any itab target field" },
-10691, "", "selected column (%d) is referenced by more than one itab target field" },
-10692, "", "DB type (%d) of selected column (%d) and ABAP type %s (%d) of target field (%d) are not compatible" },
-10693, "", "Itab target field (%d) references the invalid column position (%d)" },
-10694, "", "Itab target field (%d) defines an unsupported ABAP type %s (%d): initial value creation not possible" },
-10695, "", "Illegal function code (%d): itab select on a non query prepared statement is not allowed" },
-10696, "", "Illegal function code (%d): itab insert on a non insert prepared statement is not allowed" },
-10697, "", "Illegal initial field (%d): initial fields are not supported in itab insert operations" },
-10698, "", "Input parameters must not be bound in this context" },
-10699, "", "Unsupported protocol version: major=%d, minor=%d" },

// Fatal errors 10900 - 10999

-10901, "", "No space left in request packet" },
-10902, "", "Invalid request packet structure" },
-10903, "", "Internal Error: LONGDATA part expected" },
-10904, "", "Internal error: Expected result count" },
-10905, "", "Invalid reply packet structure" },
-10906, "", "Internal Error: Entry for valindex %d not found"},
-10907, "", "Internal Error: Long descriptor has error flag set"},
-10908, "", "Internal Error: GETVAL operation required before data could be read"},
-10910, "HY001", "Internal Error: Unhandled exception %s:%d - (%d) %s" },
-10911, "", "Internal Error: Missing LOB locator id" },
-10912, "", "Internal Error: Too many LOB locator ids found (%d)" },
-10913, "", "Internal Error: No LOB locator id found for index (%d)" },
-10914, "", "Data for output parameters missing" },
-10915, "", "Internal Error: Invalid number of row counts returned (%d, expected %d)" },
-10916, "" , "Internal Error: Error signalled but no message returned from server" },
-10917, "", "Internal Error: Incomplete result description of multiple result sets received" },
-10918, "", "Internal Error: No LOB data received, requested LOB at position %d for %d bytes" },
-10919, "", "Internal Error: No transaction identifier found" },


Advertisement
Advertisement
Advertisement