4D v13.4

Appendix A: SQL Error Codes

Home

 
4D v13.4
4D SQL Reference
Appendix
Appendix A: SQL Error Codes

Appendix A: SQL Error Codes  


 

 

The SQL engine returns specific errors which are listed below. These errors can be intercepted using an error-handling method installed by the ON ERR CALL command.

1001INVALID ARGUMENT
1002INVALID INTERNAL STATE
1003SQL SERVER IS NOT RUNNING
1004Access denied
1005FAILED TO LOCK SYNCHRONIZATION PRIMITIVE
1006FAILED TO UNLOCK SYNCHRONIZATION PRIMITIVE
1007SQL SERVER IS NOT AVAILABLE
1008COMPONENT BRIDGE IS NOT AVAILABLE
1009REMOTE SQL SERVER IS NOT AVAILABLE
1010EXECUTION INTERRUPTED BY USER

1101Table '{key1}' does not exist in the database.
1102Column '{key1}' does not exist.
1103Table '{key1}' is not declared in the FROM clause.
1104Column name reference '{key1}' is ambiguous.
1105Table alias '{key1}' is the same as table name.
1106Duplicate table alias - '{key1}'.
1107Duplicate table in the FROM clause - '{key1}'.
1108Operation {key1} {key2} {key3} is not type safe.
1109Invalid ORDER BY index - {key1}.
1110Function {key1} expects one parameter, not {key2}.
1111Parameter {key1} of type {key2} in function call {key3} is not implicitly convertible to {key4}.
1112Unknown function - {key1}.
1113Division by zero.
1114Sorting by indexed item in the SELECT list is not allowed - ORDER BY item {key1}.
1115DISTINCT NOT ALLOWED
1116Nested aggregate functions are not allowed in the aggregate function {key1}.
1117Column function is not allowed.
1118Cannot mix column and scalar operations.
1119Invalid GROUP BY index - {key1}.
1120GROUP BY index is not allowed.
1121GROUP BY is not allowed with 'SELECT * FROM ...'.
1122HAVING is not an aggregate expression.
1123Column '{key1}' is not a grouping column and cannot be used in the ORDER BY clause.
1124Cannot mix {key1} and {key2} types in the IN predicate.
1125Escape sequence '{key1}' in the LIKE predicate is too long. It must be exactly one character.
1126Bad escape character - '{key1}'.
1127Unknown escape sequence - '{key1}'.
1128Column references from more than one query in aggregate function {key1} are not allowed.
1129Scalar item in the SELECT list is not allowed when GROUP BY clause is present.
1130Sub-query produces more than one column.
1131Subquery must return one row at the most but instead it returns {key1}.
1132INSERT value count {key1} does not match column count {key2}.
1133Duplicate column reference in the INSERT list - '{key1}'.
1134Column '{key1}' does not allow NULL values.
1135Duplicate column reference in the UPDATE list - '{key1}'.
1136Table '{key1}' already exists.
1137Duplicate column '{key1}' in the CREATE TABLE command.
1138DUPLICATE COLUMN IN COLUMN LIST
1139More than one primary key is not allowed.
1140Ambiguous foreign key name - '{key1}'.
1141Column count {key1} in the child table does not match column count {key2} in the parent table of the foreign key definition.
1142Column type mismatch in the foreign key definition. Cannot relate {key1} in child table to {key2} in parent table.
1143Failed to find matching column in parent table for '{key1}' column in child table.
1144UPDATE and DELETE constraints must be the same.
1145FOREIGN KEY DOES NOT EXIST
1146Invalid LIMIT value in SELECT command - {key1}.
1147Invalid OFFSET value in SELECT command - {key1}.
1148Primary key does not exist in table '{key1}'.
1149FAILED TO CREATE FOREIGN KEY
1150Column '{key1}' is not part of a primary key.
1151FIELD IS NOT UPDATEABLE
1152FOUND VIEW COLUMN
1153Bad data type length '{key1}'.
1154EXPECTED EXECUTE IMMEDIATE COMMAND
1155INDEX ALREADY EXISTS
1156Auto-increment option is not allowed for column '{key1}' of type {key2}.
1157SCHEMA ALREADY EXISTS
1158SCHEMA DOES NOT EXIST
1159Cannot drop system schema
1160CHARACTER ENCODING NOT ALLOWED

1203The functionality is not implemented. 
1204Failed to create record {key1}.
1205Failed to update field '{key1}'.
1206Failed to delete record '{key1}'.
1207NO MORE JOIN SEEDS POSSIBLE
1208FAILED TO CREATE TABLE
1209FAILED TO DROP TABLE
1210CANT BUILD BTREE FOR ZERO RECORDS
1211COMMAND COUNT GREATER THAN ALLOWED
1212FAILED TO CREATE DATABASE
1213FAILED TO DROP COLUMN
1214VALUE IS OUT OF BOUNDS
1215FAILED TO STOP SQL_SERVER
1216FAILED TO LOCALIZE
1217Failed to lock table for reading.
1218FAILED TO LOCK TABLE FOR WRITING
1219TABLE STRUCTURE STAMP CHANGED
1220FAILED TO LOAD RECORD
1221FAILED TO LOCK RECORD FOR WRITING
1222FAILED TO PUT SQL LOCK ON A TABLE
1223FAILED TO RETAIN COOPERATIVE TASK
1224FAILED TO LOAD INFILE

1301PARSING FAILED

1401COMMAND NOT SPECIFIED
1402ALREADY LOGGED IN
1403SESSION DOES NOT EXIST
1404UNKNOWN BIND ENTITY
1405INCOMPATIBLE BIND ENTITIES
1406REQUEST RESULT NOT AVAILABLE
1407BINDING LOAD FAILED
1408COULD NOT RECOVER FROM PREVIOUS ERRORS
1409NO OPEN STATEMENT
1410RESULT EOF
1411BOUND VALUE IS NULL
1412STATEMENT ALREADY OPENED
1413FAILED TO GET PARAMETER VALUE
1414INCOMPATIBLE PARAMETER ENTITIES
1415Query parameter is either not allowed or was not provided.
1416COLUMN REFERENCE PARAMETERS FROM DIFFERENT TABLES
1417EMPTY STATEMENT
1418FAILED TO UPDATE VARIABLE
1419FAILED TO GET TABLE REFERENCE
1420FAILED TO GET TABLE CONTEXT
1421COLUMNS NOT ALLOWED
1422INVALID COMMAND COUNT
1423INTO CLAUSE NOT ALLOWED
1424EXECUTE IMMEDIATE NOT ALLOWED
1425ARRAY NOT ALLOWED IN EXECUTE IMMEDIATE
1426COLUMN NOT ALLOWED IN EXECUTE IMMEDIATE
1427NESTED BEGIN END SQL NOT ALLOWED
1428RESULT IS NOT A SELECTION
1429INTO ITEM IS NOT A VARIABLE
1430VARIABLE WAS NOT FOUND
1431PTR OF PTR NOT ALLOWED
1432POINTER OF UNKNOWN TYPE

1501SEPARATOR_EXPECTED
1502FAILED TO PARSE DAY OF MONTH
1503FAILED TO PARSE MONTH
1504FAILED TO PARSE YEAR
1505FAILED TO PARSE HOUR
1506FAILED TO PARSE MINUTE
1507FAILED TO PARSE SECOND
1508FAILED TO PARSE MILLISECOND
1509INVALID AM PM USAGE
1510FAILED TO PARSE TIME ZONE
1511UNEXPECTED CHARACTER
1512Failed to parse timestamp.
1513Failed to parse duration.
1551FAILED TO PARSE DATE FORMAT

1601NULL INPUT STRING
1602NON TERMINATED STRING
1603NON TERMINATED COMMENT
1604INVALID NUMBER
1605UNKNOWN START OF TOKEN
1606NON TERMINATED NAME/* closing ']' is missing
1607NO VALID TOKENS

1701Failed to validate table '{key1}'.
1702Failed to validate FROM clause.
1703Failed to validate GROUP BY clause.
1704Failed to validate SELECT list.
1705Failed to validate WHERE clause.
1706Failed to validate ORDER BY clause.
1707Failed to validate HAVING clause.
1708Failed to validate COMPARISON predicate.
1709Failed to validate BETWEEN predicate.
1710Failed to validate IN predicate.
1711Failed to validate LIKE predicate.
1712Failed to validate ALL ANY predicate.
1713Failed to validate EXISTS predicate.
1714Failed to validate IS NULL predicate.
1715Failed to validate subquery.
1716Failed to validate SELECT item {key1}.
1717Failed to validate column '{key1}'.
1718Failed to validate function '{key1}'.
1719Failed to validate CASE expression.
1720Failed to validate command parameter.
1721Failed to validate function parameter {key1}.
1722Failed to validate INSERT item {key1}.
1723Failed to validate UPDATE item {key1}.
1724Failed to validate column list.
1725Failed to validate foreign key.
1726Failed to validate SELECT command.
1727Failed to validate INSERT command.
1728Failed to validate DELETE command.
1729Failed to validate UPDATE command.
1730Failed to validate CREATE TABLE command.
1731Failed to validate DROP TABLE command.
1732Failed to validate ALTER TABLE command.
1733Failed to validate CREATE INDEX command.
1734Failed to validate LOCK TABLE command.
1735Failed to calculate LIKE predicate pattern.

1801Failed to execute SELECT command.
1802Failed to execute INSERT command.
1803Failed to execute DELETE command.
1804Failed to execute UPDATE command.
1805Failed to execute CREATE TABLE command.
1806Failed to execute DROP TABLE command.
1807Failed to execute CREATE DATABASE command.
1808Failed to execute ALTER TABLE command.
1809Failed to execute CREATE INDEX command.
1810Failed to execute DROP INDEX command.
1811Failed to execute LOCK TABLE command.
1812Failed to execute TRANSACTION command.
1813Failed to execute WHERE clause.
1814Failed to execute GROUP BY clause.
1815Failed to execute HAVING clause.
1816Failed to aggregate.
1817Failed to execute DISTINCT.
1818Failed to execute ORDER BY clause.
1819Failed to build DB4D query.
1820Failed to calculate comparison predicate.
1821Failed to execute subquery.
1822Failed to calculate BETWEEN predicate.
1823Failed to calculate IN predicate.
1824Failed to calculate ALL/ANY predicate.
1825Failed to calculate LIKE predicate.
1826Failed to calculate EXISTS predicate.
1827Failed to calculate NULL predicate.
1828Failed to perform arithmetic operation.
1829Failed to calculate function call '{key1}'.
1830Failed to calculate case expression.
1831Failed to calculate function parameter '{key1}'.
1832Failed to calculate 4D function call.
1833Failed to sort while executing ORDER BY clause.
1834Failed to calculate record hash.
1835Failed to compare records.
1836Failed to calculate INSERT value {key1}.
1837DB4D QUERY FAILED
1838FAILED TO EXECUTE ALTER SCHEMA COMMAND
1839FAILED TO EXECUTE GRANT COMMAND

2000CACHEABLE NOT INITIALIZED
2001VALUE ALREADY CACHED
2002CACHED VALUE NOT FOUND
2003CACHE IS FULL
2004CACHING IS NOT POSSIBLE

3000HEADER NOT FOUND
3001UNKNOWN COMMAND
3002ALREADY LOGGED IN
3003NOT LOGGED IN
3004UNKNOWN OUTPUT MODE
3005INVALID STATEMENT ID
3006UNKNOWN DATA TYPE
3007STILL LOGGED IN
3008SOCKET READ ERROR
3009SOCKET WRITE ERROR
3010BASE64 DECODING ERROR
3011SESSION TIMEOUT
3012FETCH TIMESTAMP ALREADY EXISTS
3013BASE64 ENCODING ERROR
3014INVALID HEADER TERMINATOR
3015INVALID SESSION TICKET
3016HEADER TOO LONG
3017INVALID AGENT SIGNATURE
3018UNEXPECTED HEADER VALUE

 
PROPERTIES 

Product: 4D
Theme: Appendix