Run-Time System Errors

This topic lists the Database Connectors for MSSQL error messages that could occur during execution of your program. For information on compile-time errors and several methods for retrieving run time system errors, see the chapter Performance and Troubleshooting.

Run time system errors have this format:

9/xxx

The 9 indicates a file system error and is reported as the first digit of the 2-byte FILE STATUS variable. The xxx is a binary value between 1 and 255 that provides more information. If xxx is 83, you can retrieve additional information with C$RERR. That additional information can come from either the database or the run time. Run-time codes returned with C$RERR include:

Code Message
1 Error reading the XFD file
2 Corrupt XFD/dictionary file
3 Error opening the XFD file
4 Too many key fields (16 max)
5 (no message associated with this error)
7 The interface cannot determine which row to change or delete. For a primary key that allows duplicates, one or both of the following conditions have not been met when rewriting or deleting a row or when executing READ followed by READ NEXT:
  • An identity column must be included. This can be either a hidden column using A-MSSQL-ADD-IDENTITY when the table is created, or an explicit column using the IDENTIY-COLUMN XFD directive.
  • The record to update or delete must be the last record read.
11 Stored procedures not found
12 A column of a key is of data type TEXT or IMAGE, which is illegal
13 Internal error
14 DB library function returned an unexpected error
16 Trying to rename a table across databases
17 Cache error
18 Primary Key error
19 Table Size Error
20 (no message associated with this error)
21 (no message associated with this error)

For a detailed description of a particular message, see the Error Messages section.