Btrieve Record Manager Error Listing

A btrieve error message commonly appears as a pair of numbers, such as 5,2, or 12,0. The first number of the pair is the error code itself; the second number is the operation code that Btrieve was trying to accomplish, such as "open" or "close." For example, error 5,2 would be a "duplicate key value" error on operation 2 which is "insert record." This could happen if trying to create a new customer record that has the same customer number as a pre-existing customer. InfoTouch won't let you do this, of course, but if the database index is damaged, InfoTouch might not "see" the duplicate problem until later. A CUS.DB file with a 5,2 error message would require repair to "fix" the database's index of customer numbers.

The most common error codes are 2, 4, 5, 6, 8, 10 and 12. The most common operations are 0, 2, 3, 4 and 14. If the error code is one such as an 11 (invalid file name) or a 12 (file not found) it means the file is missing or perhaps the file attribute or network permissions are set so it can't be accessed. If it's one of the other error codes, it usually means that the data file itself is corrupt and must be repaired using the butil.exe tool.
 

Operation codes: (the 2nd number of the pair)

0-Open    1-Close    2-Insert    3-Update    4-Delete    5-Get Equal    6-Get Next    7-Get Previous    8-Get Greater    9-Get greater or equal    10-Get less than    11-Get less than or equal    12-Get lowest    13-Get highest  14-Create    15-Stat    16-Extend    17-Set directory    18-Get directory    19-Begin transaction    20-End transaction 21-Abort transaction    22-Get position    23-Get direct    24-Step direct    25-Stop  26-Version    27-Unlock    28-Reset     29-Set owner    30-Clear owner 

Error codes: (the 1st number of the pair)

BTRIEVE 1 "INVALID OPERATOR - The operation parameter specified in the call is invalid."

BTRIEVE 2 "I/O ERROR - The file may be damaged or the wrong version of 'WBTRCALL' is running. If the file is damaged it must be repaired using 'BCLEAN' or 'BUTIL' before data can be accessed."

BTRIEVE 3 "FILE NOT OPEN - BTRIEVE must successfully open a file before any other BTRIEVE operations can be performed. (Check access rights to the directory where the BTRIEVE file is located.)"

BTRIEVE 4 "KEY VALUE NOT FOUND - The specified key value in the Index path was not found. The Field Definition file may have changed without a conversion. TCK file may be missing from 'VOLUME.DB'."

BTRIEVE 5 "DUPLICATE KEY VALUE - A record with a key field containing a duplicate key value cannot be added to an index that does not allow duplicate values. NOTE: You cannot modify an auto-increment field. "

BTRIEVE 6 "INVALID KEY NUMBER - The key number must correspond to one of the keys defined when the file was created or to a supplemental index."

BTRIEVE 7 "DIFFERENT KEY NUMBER - Key number changed preventing the BTRIEVE operation from completing. (The BTRIEVE file position changed)"

BTRIEVE 8 "INVALID POSITIONING - The current position must be established to update or delete a record. Confirm may get this error when confirming an index that has been changed with modify index."

BTRIEVE 9 "END-OF-FILE - The operation tried to read past the file boundaries."

BTRIEVE 10 "MODIFIABLE KEY VALUE ERROR - The operation tried to modify a key field which is defined as non-modifiable."

BTRIEVE 11 "INVALID FILENAME - The filename specified does not conform to file naming conventions."

BTRIEVE 12 "FILE NOT FOUND - The specified file does not exist. This may caused by querying on a DB that has not been created, a missing 'TKOALL.DB', or the TKOALLDB value in the .ENV file is set to the wrong directory."

BTRIEVE 13 "EXTENDED FILE ERROR - BTrieve could not find the extension file the application was trying to open."

BTRIEVE 14 "PRE-IMAGE OPEN ERROR - The pre-image file could not be created. Your disk or directory may be full, or you may not have access rights to the pre-image file directory or file, or the pre-image file may be damaged.

BTRIEVE 15 "PRE-IMAGE I/O ERROR - The disk is full or the pre-image file is damaged. If the file is damaged, it must be repaired."

BTRIEVE 16 "EXPANSION ERROR - Check for disk hardware failure."

BTRIEVE 17 "CLOSE ERROR - Check for disk hardware failure."

BTRIEVE 18 "DISK FULL - The disk is full. You will need to free up some space before any additional records can be inserted into the database."

BTRIEVE 19 "UNRECOVERABLE ERROR - File integrity cannot be ensured. Either use 'BUTIL -RECOVER' to retrieve the damaged file's data records in a sequential file, or replace the BTrieve file with its most recent backup."

BTRIEVE 20 "RECORD MANAGER INACTIVE - Check to be sure that 'BTRIEVE.NLM' is loaded on the file server and 'BREQUEST' is loaded on the workstation. Standalone stations should not load BTrieve before running windows."

BTRIEVE 21 "KEY BUFFER TOO SHORT - The key buffer was not long enough to fit the key field the index path requested. This may be caused by a wrong combination of 'BREQUEST', 'WBTRCALL.DLL', and 'BTRIEVE.NLM'."

BTRIEVE 22 "DATA BUFFER LENGTH - The data buffer was not long enough to fit the data record defined when the file was created. The may be caused by a wrong combination of 'BREQUEST', 'WBTRCALL.DLL', and 'BTRIEVE.NLM'."

BTRIEVE 23 "POSITION BLOCK LENGTH - The position block parameter was not 128 bytes long."

BTRIEVE 24 "PAGE SIZE ERROR - The page size was invalid. The page size must be 4096 bytes or larger in 512 byte increments. NOTE: Check 'WIN.INI' file under [BTRIEVE] on the options line, it should look similar to: options=/m:48 /p:4096.

BTRIEVE 25 "CREATE I/O ERROR - Unable to create a Btrieve file. The drive or directory may be full, or the file that Btrieve tried to create exists and is currently open or flagged transactional."

BTRIEVE 26 "NUMBER OF KEYS - The number of keys for the page size is invalid. Btrieve files with with a page size of 512 bytes must have 1 to 8 key segments. For larger page sizes, 1 to 24 key segments must exist."

BTRIEVE 27 "INVALID KEY POSITION - The key field position specified exceeded the defined record length for the file."

BTRIEVE 28 "INVALID RECORD LENGTH - The record length was invalid. The record length specified (plus overhead for duplicates) must be less than or equal to the page size minus six, or greater than or equal to four bytes."

BTRIEVE 29 "INVALID KEY LENGTH - The length specified must be between 1 and 255. The length of a binary key must be even. Each key page must be large enough to hold at least 8 keys."

BTRIEVE 30 "NOT A BTRIEVE FILE - The file name specified is not a Btrieve file, or the first page is damaged."

BTRIEVE 31 "FILE ALREADY EXTENDED - The file specified has already been extended. A file can only be extended once."

BTRIEVE 32 "EXTEND I/O ERROR - The file could not be extended. The disk or directory may be full."

BTRIEVE 33 "Unknown"

BTRIEVE 34 "INVALID EXTENSION NAME - The filename specified for the extended partition was invalid."

BTRIEVE 35 "DIRECTORY ERROR - The specified drive or directory that points to the Btrieve file is not correct."

BTRIEVE 36 "TRANSACTION ERROR - Transaction operations could not be performed because no transactions were specified when Btrieve was configured."

BTRIEVE 37 "TRANSACTION IS ACTIVE - Can not begin a transaction while another transaction is active. (Transactions cannot be nested)"

BTRIEVE 38 "TRANSACTION CONTROL FILE I/O ERROR - Could not write to the transaction control file. The drive may be full or write-protected, or the control file may have been deleted."

BTRIEVE39 "END/ABORT TRANSACTION ERROR"

BTRIEVE 40 "TRANSACTION MAX FILES - Tried to update more than the maximum number of files allowed within a transaction. The maximum file of files that can be updated durring a transaction id set when Btrieve is configured."

BTRIEVE 41 "OPERATION NOT ALLOWED - An operation that is not allowed at this time was called."

BTRIEVE 42 "INCOMPLETE ACCELERATED ACCESS - Tried to open a file that was previously accessed in accelerated mode and was never successfully closed. The specified file is damaged and must be repaired."

BTRIEVE 43 "INVALID RECORD ADDRESS - The record address specified for a Get Direct operation was invalid. Get Direct should use the four-byte address obtained by a Get Position call."

BTRIEVE 44 "NULL KEY PATH - Tried to use the Get Direct call to establish an index path for a key that has a NULL value in the corresponding file."

BTRIEVE 45 "INCONSISTENT KEY FLAGS - The key flags specification on the Create operation was inconsistent. If a key has multiple segments, the duplicate, modifiable, and NULL attributes should be the same for each segment in the key."

BTRIEVE 46 "ACCESS TO FILE DENIED - Tried to update, add, insert, or delete from a READ-ONLY database."

BTRIEVE 47 "MAXIMUM OPEN FILES - The number of files open in accelerated mode exeeded the number of buffers available in Btrieve's cache."

BTRIEVE 48 "INVALID ALTERNATE SEQUENCE DEFINITION - The first byte of an alternate collating sequence definition (the ID byte) did not contain the hexadecimal value 'AC'."

BTRIEVE 49 "KEY TYPE ERROR - Tried to create a file or supplemental index with an invalid extended key type."

BTRIEVE 50 "OWNER ALREADY SET - Tried to perform a Set Owner on a file that has an owner."

BTRIEVE 51 "INVALID OWNER - The owner name in the key buffer and data buffer did not match, or the specified file has a owner assigned to it."

BTRIEVE 52 "ERROR WRITING CACHE - While trying to make a cache buffer available, Btrieve tried to write data to a logical drive from a file that was previously opened in accelerated mode. An I/O error occurred during a write."

BTRIEVE 53 "INVALID INTERFACE - You must have Btrieve version 4.xx or later to access variable length records."

BTRIEVE 54 "VARIABLE PAGE ERROR - BTrieve could not read all or part of the variable length portion of a record. The file may be damaged."

BTRIEVE 55 "AUTOINCREMENT ERROR - Tried to specify either the segmented or duplicate attribute for an autoincrement key type. An autoincrement key cannot be part of another key and cannot allow duplicates."

BTRIEVE 56 "INCOMPLETE INDEX - A supplemental index was damaged. Perform a Drop Supplemental Index to completely remove the index from the file."

BTRIEVE 57 "EXPANDED MEMORY ERROR - Btrieve was notified by the expanded memory manager of an error."

BTRIEVE 58 "COMPRESSION BUFFER TOO SHORT - Tried to read or write a record that is longer than the value specified for the size of the compression buffer. Reconfigure Btrieve to have a larger 'Maximum Compressed Record Size'."

BTRIEVE 59 "FILE ALREADY EXISTS - Tried to create a file that already exists."

BTRIEVE 60 "REJECT COUNT REACHED - Btrieve reached the end of the file before the extended operation was satisfied."

BTRIEVE 61 "WORKSPACE BUFFER TOO SMALL - The 64K buffer was not large enough to hold the data buffer structure for the extended operation and the largest record to be received."

BTRIEVE 62 "INCORRECT DESCRIPTOR - The passed in descriptor to an extended Get or Step operation is incorrect."

BTRIEVE 63 "INVALID EXTENDED INSERT BUFFER - An extended insert operation provides an invalid buffer. The buffer length is less than 5 bytes, or the number of records specified is 0."

BTRIEVE 64 "FILTER LIMIT REACHED - During an extended operation, a rejected record was reached."

BTRIEVE 65 "INCORRECT FIELD OFFSET - The field offset on an extended operation is not valid."

BTRIEVE 66 "MAXIMUM NUMBER OF OPEN DATABASES EXCEEDED - The application tried to open too many databases at one time. The default is 20 but can be modified by using the '/R' option (/R:30)."

BTRIEVE 67 "RI COULD NOT OPEN SQL DATA DICTIONARIES."

BTRIEVE 68 "RI CASCADES TOO DEEPLY - More than 16 levels of dependent records prevents deleting the record."

BTRIEVE69 "RI CASCADE ERROR - A delete cascade error was detected."

BTRIEVE 70 "Unknown"

BTRIEVE 71 "RI DEFINITIONS VIOLATION - Cannot change the value of a primary key."

BTRIEVE 72 "REFERENCED FILE COULD NOT BE OPENED"

BTRIEVE 73 "RI DEFINITIONS OUT OF SYNC"

BTRIEVE 74 "AUTOMATIC TRANSACTION ABORT"

BTRIEVE 75 "SERVER ROUTING LIST TOO SMALL - The initialization parameter /S in 'BRQPARMS' is too small and needs to be increased."

BTRIEVE 76 "FILE SERVER LIST TOO SMALL - You are attached to more file servers than can be accomodated at a time. Disconnect from unneeded servers."

BTRIEVE 77 "VAP WAIT ERROR - A VAP being served by Btrieve was issued a read with a wait lock on a record that is locked by another client."

BTRIEVE 78 "DEADLOCK DETECTED - Btrieve detects a deadlock condition. All locks should be released."

BTRIEVE 79 "PROGRAMMING ERROR - This is an internal programming error. Contact Btrieve Technologies."

BTRIEVE 80 "CONFLICT - Could not update or delete the record because another application changed the record after your applications last read."

BTRIEVE 81 "LOCK ERROR - The Btrieve lock table may be full. Decrease the number of locks that you use, or reconfigure Btrieve and specify a higher value for the 'Maximum Number of Record Locks'."

BTRIEVE 82 "LOST POSITION - The application tried to retrieve a record that was deleted or whose key value was modified by another application."

BTRIEVE 83 "READ OUTSIDE TRANSACTION - The application tried to update or delete a record within a transaction, but the record was not read in the transaction."

BTRIEVE 84 "RECORD IN USE - The application tried to lock a record that was currently locked by another application, or the application tried to lock a file that was locked by another application."

BTRIEVE 85 "FILE IN USE - Tried to open a file, access a record in a transaction, or lock a record while another application was accessing the file."

BTRIEVE 86 "FILE TABLE FULL - Btrieve's file table is full. Reconfigure Btrieve and specify a higher 'Maximum Number of Open Files'."

BTRIEVE 87 "HANDLE TABLE FULL - Btrieve's handle table is full. Reconfigure Btrieve and specify a higher 'Maximum Number of File Handles'."

BTRIEVE 88 "INCOMPATIBLE MODE ERROR - Tried to open a file in an incompatible mode. If the first application opens a file in accelerated mode, all other applications must use the same mode."

BTRIEVE 89 "Unknown"

BTRIEVE 90 "REDIRECTED DEVICE TABLE FULL - BRequest redirection table or server routing table is full. - Need to reload BRequest (Exit Windows first)."

BTRIEVE 91 "SERVER ERROR - BRequest could not establish a session with the server. Make sure you are running corresponding versions of Btrieve.NLM, BRequest, and WBTRCall.DLL."

BTRIEVE 92 "TRANSACTION TABLE FULL - The maximum number of active transactions was exceeded. Reconfigure Btrieve and specify a higher value for the 'Number of Concurrent Transactions'."

BTRIEVE 93 "INCOMPATIBLE LOCK TYPE - Tried to mix single and multiple record locks in the same file at the same time. All locks of one type must be released before another lock type can be used."

BTRIEVE 94 "PERMISSION ERROR - Tried to open or create a file in a directory without the proper privileges. You must have rights to access files in a directory."

BTRIEVE 95 "SESSION NO LONGER VALID - The error occurred at the workstation, the file server, or on the network. You should verify your network connection then reload 'BRequest'."

BTRIEVE 96 "COMMUNICATIONS ENVIRONMENT ERROR - The SPX connection table is full. Reload SPX, specifying a higher value for the connection table."

BTRIEVE 97 "DATA MESSAGE TOO SMALL - Tried to read or write a record which was longer than it could handle. Make sure you are running corresponding versions of Btrieve.NLM, BRequest, and WBTRCall.DLL."

BTRIEVE 98 "INTERNAL TRANSACTION ERROR - An error occurred during a transaction."

BTRIEVE 99 "Unknown"

BTRIEVE 1001 "LOCK PARAMETER OUT OF RANGE - The number specified for the Multiple Locks configuration options must be between 1 and 255, inclusive."

BTRIEVE 1002 "MEMORY ALLOCATION ERROR - Btrieve was unable to allocate the amount of conventional memory needed."

BTRIEVE 1003 "MEMORY PARAMETER TOO SMALL - The value for the Memory Size configuration option is too small to accommodate the required cache size."

BTRIEVE 1004 "PAGE SIZE PARAMETER OUT OF RANGE - The Page Size configuration option must be an even multiple of 512 between 512 and 4096, inclusive."

BTRIEVE 1005 "INVALID PREIMAGE DRIVE PARAMETER - The drive letter specified for the pre-image File Drive configuration option is not valid."

BTRIEVE 1006 "PREIMAGE BUFFER PARAMETER OUT OF RANGE - The Pre-image Buffer Size configuration option must be between 1 and 64, inclusive."

BTRIEVE 1007 "FILE PARAMETER OUT OF RANGE - The Open Files configuration option must be between 1 and 255, inclusive."

BTRIEVE 1008 "INVALID INITIALIZATION PARAMETER - The configuration options contain an invalid or unidentifiable option."

BTRIEVE 1009 "INVALID TRANSACTION FILE PARAMETER - The filename specified for the Transaction Filename configuration is not valid."

BTRIEVE 1010 "ERROR ACCESSING TRANSACTION CONTROL FILE - The error occurred during a transaction recovery."

BTRIEVE 1011 "COMPRESSION BUFFER OUT OF RANGE - The Compression Buffer Size configuration option must be between 1 and 64, inclusive."

BTRIEVE 1012 "Unknown"

BTRIEVE 1013 "TASK TABLE FULL - The value can be set between 1 and 255. Increase the number in 'NOVDB.INI' under [BTRIEVE] or [BREQUESTDPMI] on the 'TASKS=' line to a greater value."

BTRIEVE 1014 "STOP WARNING - The application still has open files, or an active transaction."

BTRIEVE 1015 "INVALID POINTER - One of the pointer parameters passed to Btrieve was invalid."

BTRIEVE 1016 "ALREADY INITIALIZED - An attempt was made to initialize Btrieve while it is already initialized."

BTRIEVE 1017 "Unknown"

BTRIEVE 2001 "INSUFFICIENT MEMORY - The requestor cannot allocate enough memory (Conventional) for the configuration options specified."

BTRIEVE 2002 "PARAMETER INVALID OR OUT OF RANGE - One of the configuration options specified is either invalid (such as /P: instead of /D:) or the value specified for the parameter is out of range."

BTRIEVE 2003 "NO LOCAL ACCESS ALLOWED - The application attempted to access a field store on a local drive. The version of 'WBTRCALL' installed at the workstation does not allow access to local files."

BTRIEVE 2004 "SPX IS NOT NSTALLED - Install the SPX network communication software."

BTRIEVE 2005 "WRONG VERSION OF SPX INSTALLED - Install SPX version 2.0 or greater."

BTRIEVE 2006 "NO AVAILABLE SPX CONNECTION - SPX has established the maximum number of sessions it can handle."

BTRIEVE 2007 "NO TASK SLOTS AVAILABLE - The maximum number of applications accessing the requestor concurrently has been reached. Only 10 active applications can use the requestor at once."

BTRIEVE 2008 "Unknown"

BTRIEVE 2009 "Unknown"

DISCLAIMER
This information is provided "as-is" without any warranty of any kind. End user assumes sole responsibility for using this information.

Return to "How-To" Page

InfoTouch News

InfoTouch Corporation was purchased by Paytrans in 2006, and since then, their product focus has changed so that their POS system is no longer a good choice for golf clubs and courses. We still support all our InfoTouch customers but when the time comes to "upgrade" the software to the newest version, we hope that our InfoTouch users will talk with us about upgrade issues. The conversation may save you a lot of time, expense and agony...