Tivoli Service Desk 6.0 Developer's Toolkit Script Language Reference
Return to Main Page
The return codes documented here are generated by Tivoli Service Desk Developer's Toolkit when it processes SQL statements. If you receive an error code that is not listed here, it was generated by the DBMS. In that case, refer to your DBMS documentation for the error code definition.
SQL error codes are grouped into ranges, by message type, to help you identify the nature of the message by its number. The ranges are:
Range | Type of Message |
1 | Success |
-100 to -299 | Information |
-17301 to -17399 | Errors (excluding text retrieval errors) |
-17400 to -17499 | Text Retrieval Subsystem Errors |
-17500 to -17599 | Warnings |
Error Code | Definition |
1 | Success |
Error Code | Definition |
-100 | Data not found |
Error Code | Definition |
-17301 | Out of memory |
-17302 | Field not found |
-17303 | Invalid command |
-17304 | Invalid cursor |
-17305 | Type mismatch |
-17306 | Unknown type |
-17307 | Cannot disconnect |
-17308 | Cannot connect |
-17309 | Cannot stop DBMS |
-17310 | Cannot initialize DBMS |
-17311 | Cursor closed |
-17312 | Cursor in use |
-17313 | Too many cursors |
-17314 | Too many statements |
-17315 | Invalid statement |
-17316 | Invalid statement handle |
-17317 | Statement closed |
-17318 | Unable to bind |
-17319 | Not initialized |
-17320 | Not logged on |
-17321 | Unable to create thread |
-17322 | Space unknown |
-17323 | Invalid date format |
-17324 | Invalid time format |
-17325 | Cannot insert unknown |
-17326 | Unknown statement |
-17327 | Unknown table |
-17328 | Unknown where |
-17329 | Unknown statement handle |
-17330 | Unknown cursor |
-17331 | Unable to create semaphore |
-17332 | Unable to obtain semaphore |
-17333 | Statement in use |
-17334 | Duplicate key insert |
-17335 | Duplicate key insert multi line edit |
-17336 | Duplicate key update |
-17337 | Duplicate key update multi line edit |
-17338 | Foreign key insert |
-17339 | Foreign key update |
-17340 | Bind 805 |
-17341 | Bind 818 |
-17342 | Row has changed |
-17343 | Cannot update unknown |
-17344 | Bad parameter |
-17345 | Not connected |
-17346 | Invalid connection |
-17347 | Parent key delete |
-17348 | Parent key update |
-17349 | Not implemented |
-17350 | General error |
-17351 | Table not found |
-17352 | Unable to load object |
-17353 | Unable to free object |
-17354 | Too many connections |
-17355 | No transaction |
-17356 | Missing database |
-17357 | Already connected |
-17358 | Cannot nest transaction |
-17359 | Unrecognized option |
-17360 | Unrecognized driver |
-17361 | File open |
-17362 | Too many defaults |
-17363 | Too many auto connections |
-17364 | No driver |
-17365 | Missing entry |
-17366 | No source |
-17367 | Qualifier stack empty |
-17368 | No default source |
-17369 | No driver |
-17370 | Connection not found |
-17371 | Unrecognized source |
-17372 | Unrecognized driver |
-17373 | PC update number mismatch |
-17374 | PC update name mismatch |
-17375 | Unable to initialize trace |
-17376 | Transactions not supported |
-17377 | Invalid driver |
-17378 | Unable to get procedure address |
-17379 | Statement too long |
-17380 | Invalid driver mode |
Error Code | Definition |
-17400 | Invalid text retrieval object |
-17401 | Can not open configuration file |
-17402 | Null configuration string |
-17403 | Bad fetched data |
-17404 | Unknown index |
-17405 | Null column list |
-17406 | Index type conflict |
-17407 | No key |
-17408 | No longchar |
-17409 | Column type conflict |
-17410 | Index name not found |
-17411 | Bad key type |
-17412 | Bad filter list |
-17413 | Can not make cache |
-17414 | Join not allowed |
-17415 | Text retrieval not initialized |
-17416 | Duplicate index |
-17417 | Invalid text search |
Error Code | Definition |
-17500 | Data truncation |
-17501 | Cursor open |
-17502 | Statement open |
-17503 | Transaction in progress |
-17510 | Null item |
Tivoli Service Desk 6.0 Developer's Toolkit Script Language Reference