# Advantage 60xx Error Codes

*Advantage Error Guide*

## Contents

- [6002 Index corruption detected](#6002-index-corruption-detected)
- [6010 Bad conditional index expression](#6010-bad-conditional-index-expression)
- [6011 Index key is too long](#6011-index-key-is-too-long)
- [6012 Invalid key length](#6012-invalid-key-length)
- [6015 No Advantage Optimized Filter Exists](#6015-no-advantage-optimized-filter-exists)
- [6020 No table open in current work area](#6020-no-table-open-in-current-work-area)
- [6021 No index open](#6021-no-index-open)
- [6022 Tag does not exist](#6022-tag-does-not-exist)
- [6023 Bad tag number](#6023-bad-tag-number)
- [6024 No current record](#6024-no-current-record)
- [6025 Bad arguments](#6025-bad-arguments)
- [6026 Invalid data type](#6026-invalid-data-type)
- [6027 Invalid master index](#6027-invalid-master-index)
- [6028 Operation performed on a non-custom index](#6028-operation-performed-on-a-non-custom-index)
- [6030 Memo entry too long](#6030-memo-entry-too-long)
- [6031 No memo file](#6031-no-memo-file)
- [6032 Invalid FPT memo block size](#6032-invalid-fpt-memo-block-size)
- [6033 Memo field does not exist](#6033-memo-field-does-not-exist)
- [6034 Not an Advantage work area](#6034-not-an-advantage-work-area)
- [6035 Incorrect client driver](#6035-incorrect-client-driver)
- [6036 Encryption password does not exist](#6036-encryption-password-does-not-exist)
- [6037 No memo data exists](#6037-no-memo-data-exists)
- [6040 Error opening file containing the BLOB](#6040-error-opening-file-containing-the-blob)
- [6041 Error creating BLOB file](#6041-error-creating-blob-file)
- [6042 Illegal BLOB file length](#6042-illegal-blob-file-length)
- [6043 Error during BLOB file positioning](#6043-error-during-blob-file-positioning)
- [6044 File read error](#6044-file-read-error)
- [6045 Memo field does not contain a BLOB](#6045-memo-field-does-not-contain-a-blob)
- [6046 File write error](#6046-file-write-error)
- [6060 Advantage Database Server not started/loaded on specified server](#6060-advantage-database-server-not-started-loaded-on-specified-server)
- [6061 Low on memory](#6061-low-on-memory)
- [6062 Tables on different servers](#6062-tables-on-different-servers)
- [6063 Local drive specified. Must access a network drive that has the Advantage server started/loaded](#6063-local-drive-specified-must-access-a-network-drive-that-has-the-advantage-server-started-loaded)
- [6064 Getting the computer name failed](#6064-getting-the-computer-name-failed)
- [6066 Invalid path specified](#6066-invalid-path-specified)
- [6067 Not logged into network](#6067-not-logged-into-network)
- [6069 Primary connection to Advantage server failed](#6069-primary-connection-to-advantage-server-failed)
- [6070 Low level network function initialization failed](#6070-low-level-network-function-initialization-failed)
- [6071 Connection to Advantage server failed](#6071-connection-to-advantage-server-failed)
- [6072 Advantage client failure during creation of a Microsoft networking mailslot](#6072-advantage-client-failure-during-creation-of-a-microsoft-networking-mailslot)
- [6073 Advantage client failure during writing to a Microsoft networking mailslot](#6073-advantage-client-failure-during-writing-to-a-microsoft-networking-mailslot)
- [6074 Advantage client failure during reading to a Microsoft networking mailslot](#6074-advantage-client-failure-during-reading-to-a-microsoft-networking-mailslot)
- [6075 Request of Microsoft networking software configuration failed](#6075-request-of-microsoft-networking-software-configuration-failed)
- [6080 Error loading the Advantage remote communication layer DLL](#6080-error-loading-the-advantage-remote-communication-layer-dll)
- [6081 Error retrieving the function addresses in an Advantage DLL](#6081-error-retrieving-the-function-addresses-in-an-advantage-dll)
- [6082 Error loading the Advantage Local Server DLL](#6082-error-loading-the-advantage-local-server-dll)
- [6083 Error loading client expression engine DLL](#6083-error-loading-client-expression-engine-dll)
- [6084 Error finding task in client expression engine DLL](#6084-error-finding-task-in-client-expression-engine-dll)
- [6087 IPX not installed](#6087-ipx-not-installed)
- [6090 No structural index](#6090-no-structural-index)
- [6091 Index(es) open on destination table](#6091-index-es-open-on-destination-table)
- [6093 Table and index file on different servers](#6093-table-and-index-file-on-different-servers)
- [6094 Login reject](#6094-login-reject)
- [6095 Too many tags](#6095-too-many-tags)
- [6096 Not a compound index file](#6096-not-a-compound-index-file)
- [6097 Bad IP address specified in connection path or in ADS.INI file](#6097-bad-ip-address-specified-in-connection-path-or-in-ads-ini-file)

## 6002 Index corruption detected {#6002-index-corruption-detected}

***Problem:*** File corruption has been detected in the specified index (NTX, IDX, or CDX) file.

***Solution:*** Rebuild the index.

## 6010 Bad conditional index expression {#6010-bad-conditional-index-expression}

***Problem:*** An invalid expression was encountered while creating or opening an index.

***Solution:*** Make sure the key expression (and FOR condition expression, if applicable) is a valid Xbase expression. If a User-Defined Function (UDF) is used in an expression, verify it is available in all applications that use the index.

## 6011 Index key is too long {#6011-index-key-is-too-long}

***Problem:*** The specified index key exceeds the limit of 240 bytes for IDX or CDX, and 256 bytes for NTX indexes.

***Solution:*** Change the index key so that it is no longer than 240 bytes for IDX or CDX, and 256 bytes for NTX indexes.

## 6012 Invalid key length {#6012-invalid-key-length}

***Problem:*** The key length of the stored index and the actual length when evaluating the key expression were different.

***Solution:*** Make sure the key expression will produce a value of the same length for all records. Do not use functions such as TRIM() in the key expression. To restrict the length of the key values, use the LEFT() or PADR() functions. If a User-Defined Function (UDF) is used in the key expression, verify that the same function is available in all applications that use the index and that the function returns a value of the same length for all records.

## 6015 No Advantage Optimized Filter Exists {#6015-no-advantage-optimized-filter-exists}

***Problem:*** An API dealing with an Advantage Optimized Filter was called, but no AOF exists.

***Solution:*** Create an Advantage Optimized Filter before calling APIs that require an AOF to exist.

## 6020 No table open in current work area {#6020-no-table-open-in-current-work-area}

***Problem:*** There is no table opened by Advantage in the current work area, and the requested operation requires one.

***Solution:*** Correct the program so that a table is opened by Advantage in the current or aliased work area before the current operation is attempted.

## 6021 No index open {#6021-no-index-open}

***Problem:*** The specified index is not open or the index order is set to 0.

***Solution:*** Make sure the desired index is specified correctly and is the active index.

## 6022 Tag does not exist {#6022-tag-does-not-exist}

***Problem:*** The specified index tag does not exist.

***Solution:*** Make sure the tag is specified correctly and that the CDX file containing the tag is open.

## 6023 Bad tag number {#6023-bad-tag-number}

***Problem:*** An invalid index tag number was specified.

***Solution:*** Make sure the index is a compound index (CDX) and contains at least as many tags as the tag number you are specifying.

## 6024 No current record {#6024-no-current-record}

***Problem:*** AX_KeyAdd() or AX_KeyDrop() was called and the record pointer was not positioned on a record. For example, you would not be positioned on a record if you were at EOF due to a failed seek operation.

***Solution:*** Perform a GO TOP, GO BOTTOM, SEEK or some other operation to position yourself in the file to a valid record.

## 6025 Bad arguments {#6025-bad-arguments}

***Problem:*** An incorrect number or type of argument was passed to an Advantage function.

***Solution:*** Correct the program so that valid arguments are passed. See your Advantage client guide for the correct syntax.

## 6026 Invalid data type {#6026-invalid-data-type}

***Problem:*** A value/expression of an invalid data type was specified.

***Solution:*** Correct the program so that the correct data type is passed to the function. See your Advantage client guide for the correct usage and syntax.

## 6027 Invalid master index {#6027-invalid-master-index}

***Problem:*** A tag that already existed in a CDX was being reindexed using a master index, but the master index was the tag being reindexed.

***Solution:*** If reindexing an existing tag such that a master index is involved (e.g., the tag is a subindex), make sure the active index order is not set to the index that is to be reindexed.

## 6028 Operation performed on a non-custom index {#6028-operation-performed-on-a-non-custom-index}

***Problem:*** An AX_KeyAdd() or AX_KeyDrop() operation was attempted on an index that was not a custom index.

***Solution:*** You can only perform the AX_KeyAdd() or AX_KeyDrop() functions on custom indexes.

## 6030 Memo entry too long {#6030-memo-entry-too-long}

***Problem:*** The memo field entry for the current record exceeds the memo entry limit (64K).

***Solution:*** Reduce the size of the memo entry using the product that was used to create it.

## 6031 No memo file {#6031-no-memo-file}

***Problem:*** A memo file (DBT or FPT file) does not exist and an operation that requires a memo file was issued. Currently, functions that require a memo file to exist are AX_BLOB2File() and AX_File2BLOB().

***Solution:*** Make sure the table being used also has a memo file before attempting an operation that requires a memo file.

## 6032 Invalid FPT memo block size {#6032-invalid-fpt-memo-block-size}

***Problem:*** An invalid FPT memo block size was specified.

***Solution:*** Correct the program so that a valid FPT memo block size is set. Set the block size to <n>. If <n> is 1-32 inclusive, the block size is 512 * bytes where <n> is 1 to unlimited bytes. If <n> is greater than 32, the block size is <n> bytes.

## 6033 Memo field does not exist {#6033-memo-field-does-not-exist}

***Problem:*** A memo field name specified in an operation does not exist. Currently, functions that specify a memo field name are AX_BLOB2File() and AX_File2BLOB().

***Solution:*** Make sure the specified memo field exists in the table that is being used before attempting an operation requiring that memo field.

## 6034 Not an Advantage work area {#6034-not-an-advantage-work-area}

***Problem:*** An Advantage only function was attempted with a table that was not opened by Advantage.

***Solution:*** Change program to use an Advantage driver to open the desired table.

## 6035 Incorrect client driver {#6035-incorrect-client-driver}

***Problem:*** AX_KeyAdd() or AX_KeyDrop() was called using the Advantage NTX client driver.

***Solution:*** Custom indexes and the operations performed on them are only supported with the Advantage CDX client driver. Make sure you are using this client driver.

## 6036 Encryption password does not exist {#6036-encryption-password-does-not-exist}

***Problem:*** An encryption password did not exist in a work area and an operation requiring an encryption password was issued. Currently, functions that require encryption passwords are AX_DBFEncrypt() and AX_DBFDecrypt().

***Solution:*** Make sure an encryption password is set in the work area before attempting a function requiring an encryption password.

## 6037 No memo data exists {#6037-no-memo-data-exists}

***Problem:*** An operation requiring memo data to exist in a memo field was performed and no memo data exists in that specified memo field. Currently, the function requiring memo data to exist is AX_BLOB2File().

***Solution:*** Make sure memo data exists in the specified memo field before attempting an operation that requires memo data.

## 6040 Error opening file containing the BLOB {#6040-error-opening-file-containing-the-blob}

***Problem:*** An error occurred opening the specified file containing the BLOB to be written to the specified memo field in the function AX_File2BLOB().

***Solution:*** Make sure the specified file containing the BLOB exists. Verify the path specified with the file name exists and is accurate. Also, verify no other users currently have the specified file open. Make sure the user has sufficient access rights to open the specified file.

## 6041 Error creating BLOB file {#6041-error-creating-blob-file}

***Problem:*** An error occurred creating the specified file that is to contain the BLOB to be written from the specified memo field in the function AX_BLOB2File().

***Solution:*** Make sure the path specified with the file name exists and is accurate. If the file already exists, make sure no other users currently have the specified file open. Verify the user has sufficient access rights to create and open the specified file.

## 6042 Illegal BLOB file length {#6042-illegal-blob-file-length}

***Problem:*** The BLOB to be written in either the function AX_BLOB2File() or AX_File2BLOB() with the Advantage Clipper RDD was either too large or was of length 0. The size of the BLOB to be written must be between 1 byte and 16MB.

***Solution:*** Verify the size of the BLOB to be written is between 1 byte and 16MB when using the Advantage Clipper RDD.

## 6043 Error during BLOB file positioning {#6043-error-during-blob-file-positioning}

***Problem:*** An error occurred when positioning with the file containing the BLOB in either the function AX_BLOB2File() or AX_File2BLOB().

***Solution:*** Retry the function. If the error persists, contact Advantage Technical Support.

## 6044 File read error {#6044-file-read-error}

***Problem:*** An error occurred when reading the specified file containing the BLOB to be written to a memo field in the function AX_File2BLOB().

***Solution:*** Retry the function. If the error persists, contact Advantage Technical Support.

## 6045 Memo field does not contain a BLOB {#6045-memo-field-does-not-contain-a-blob}

***Problem:*** The memo field specified in the function AX_BLOB2File() does not contain BLOB data.

***Solution:*** Make sure the specified field contains BLOB data. The only way the specified field can contain BLOB data is if BLOB data were written to it using the function AX_File2BLOB().

## 6046 File write error {#6046-file-write-error}

***Problem:*** An error occurred when writing the BLOB data to the file specified in the function AX_BLOB2File().

***Solution:*** Retry the function. If the error persists, contact Advantage Technical Support.

## 6060 Advantage Database Server not started/loaded on specified server {#6060-advantage-database-server-not-started-loaded-on-specified-server}

***Problem 1:*** The Advantage Database Server is not started/loaded on the specified server.

***Solution 1:*** Verify that the Advantage Database Server is started/loaded on the server. Make sure that the application is referencing the correct server.

***Problem 2:*** An Advantage Windows client v2.6 or greater is being used, a connection is being attempted to a local drive, and the Advantage Database Server is not running on that local machine.

***Solution 2:*** Verify that the Advantage Database Server is started on the local machine. If you are attempting to open the file via the Advantage Local Server, make sure that use of the Advantage Local Server has been enabled via the AdsSetServerType() API, the TAdsSettings.AdsServerTypes property, the TAdsConnection.AdsServerTypes property, or the ADS_SERVER_TYPES setting in the ads.ini file.

**Linux Server Only**

It is possible to receive a 6060 error if the Advantage for Linux daemon started, but had a problem registering for multicast discovery packets. If this happens you will find a detailed error message in the ads_log.txt file.

Following are known issues that can cause this behavior:

| · | No default gateway is assigned. The server must have a default gateway or the multicast registration will not be successful. |
| --- | --- |

| · | Some users have mentioned that they had to enable ip forwarding to resolve this issue. |
| --- | --- |

Other Linux-specific issues that can cause a 6060 error include the following:

| · | Invalid or incorrect IP address in the /etc/hosts file. |
| --- | --- |

| · | Incorrect hostname is assigned. Verify that the hostname returned by running the 'hostname' utility is the same as the name used in the connection string. |
| --- | --- |

| · | If using Samba, verify that the directory you are sharing is located directly off of the root. For example the samba share \\testserv\myshare must be sharing the /myshare directory. |
| --- | --- |

## 6061 Low on memory {#6061-low-on-memory}

***Problem:*** There is insufficient conventional memory on the client for the requested operation.

***Solution:*** For safety, quit the application. Make more memory available before running the application again. Remove unneeded resident utilities or device drivers. Opening fewer database or index files may also make more memory available.

## 6062 Tables on different servers {#6062-tables-on-different-servers}

***Problem:*** A Copy To or Append From operation was attempted with tables located on different servers. The Copy To or Append From operation will not be performed on the server.

***Solution:*** If you want the Copy To or Append From operation to be performed on the server by the Advantage Database Server, make sure and specify tables that are located on the same file server on which the Advantage Database Server is running.

## 6063 Local drive specified. Must access a network drive that has the Advantage server started/loaded {#6063-local-drive-specified-must-access-a-network-drive-that-has-the-advantage-server-started-loaded}

***Problem:*** The file you are trying to access is on a local drive or on a drive letter that has not been mapped.

***Solution:*** If you want to access the file with the Advantage Database Server, the file must be located on a file server for which a drive letter is mapped with the Advantage server started/loaded.

## 6064 Getting the computer name failed {#6064-getting-the-computer-name-failed}

***Problem***: When using 16-bit Windows applications with local drive letters, the name of the local machine is needed. An error occurred while getting the name of the current machine.

***Solution***:** Make sure that the IP and/or IPX protocol is installed. Verify that NETAPI.DLL is in your search path. If possible, specify a UNC path instead of a drive letter.

## 6066 Invalid path specified {#6066-invalid-path-specified}

***Problem:*** The specified path does not exist.

***Solution:*** Make sure that you have specified the correct path and that it does exist.

## 6067 Not logged into network {#6067-not-logged-into-network}

***Problem:*** You must be logged into the network before you can open a file with Advantage.

***Solution:*** Make sure that you are logged into the network and attached to the file server running the Advantage server.

## 6069 Primary connection to Advantage server failed {#6069-primary-connection-to-advantage-server-failed}

***Problem:*** The primary connection attempt to the Advantage server failed. If you are running a CA-Clipper application that is using the IP communication library, and you incorrectly linked in the Advantage IP comm layer library using "LIB" instead of "SEARCH" or "MODULE
"in your link script, this error will occur.

***Solution:*** If you are running a CA-Clipper application that is using the IP communication library, change your link script to use "SEARCH" or "MODULE
" to link in the Advantage IP comm library. Refer to the ADS DOS IP documentation, readme.txt file, or sample link scripts for more information on how to correctly link in the Advantage IP comm library. If you are NOT running a CA-Clipper application that is using the IP communication library, then retry the operation or try reloading your network shell.

## 6070 Low level network function initialization failed {#6070-low-level-network-function-initialization-failed}

***Problem:*** The primary connection attempt to the Advantage server failed.

***Solution:*** Retry the operation. You may want to try restarting/reloading your network shell.

## 6071 Connection to Advantage server failed {#6071-connection-to-advantage-server-failed}

***Problem:*** Connection attempt to the Advantage server failed. See the accompanying OSCode for a more complete description.

***Solution:*** Retry the operation. You may want to try restarting/reloading your network shell.

## 6072 Advantage client failure during creation of a Microsoft networking mailslot {#6072-advantage-client-failure-during-creation-of-a-microsoft-networking-mailslot}

***Problem***:** A failure occurred when Advantage attempted to create a mailslot for communication to the Advantage Database Server for Windows.

***Solution:*** Ensure the Microsoft networking client software is installed correctly, reboot and retry.

## 6073 Advantage client failure during writing to a Microsoft networking mailslot {#6073-advantage-client-failure-during-writing-to-a-microsoft-networking-mailslot}

***Problem:*** A failure occurred when Advantage attempted to write to a mailslot.

***Solution:*** Ensure the Microsoft networking client software is installed correctly, reboot and retry.

## 6074 Advantage client failure during reading to a Microsoft networking mailslot {#6074-advantage-client-failure-during-reading-to-a-microsoft-networking-mailslot}

***Problem:*** A failure occurred when Advantage attempted to read from a mailslot

***Solution:*** Ensure the Microsoft networking client software is installed correctly, reboot and retry.

## 6075 Request of Microsoft networking software configuration failed {#6075-request-of-microsoft-networking-software-configuration-failed}

***Problem:*** A failure occurred when requesting configuration information from the Microsoft Windows network client software.

***Solution:*** Ensure the Microsoft networking client software is installed correctly, reboot and retry.

## 6080 Error loading the Advantage remote communication layer DLL {#6080-error-loading-the-advantage-remote-communication-layer-dll}

***Problem:*** The Advantage remote communication layer DLL(s) could not be loaded. Communication with the Advantage Database Server will not be possible.

***Solution***: Put the Advantage communications DLL(s) somewhere in your client PC's search path (e.g., your \WINDOWS\SYSTEM directory). The Advantage 32-bit Windows communication DLL is axcws32.dll. The Advantage 16-bit Windows DLLs are axcomm16.dll, adsip16.dll, and adsipx16.dll.

## 6081 Error retrieving the function addresses in an Advantage DLL {#6081-error-retrieving-the-function-addresses-in-an-advantage-dll}

***Problem:*** The Advantage DLLs were loaded, but the desired function addresses could not be obtained.

***Solution:*** Your Advantage DLLs may be corrupt or out of date. Reinstall the Advantage DLLs that ship with the version of the Advantage client used in your application.

## 6082 Error loading the Advantage Local Server DLL {#6082-error-loading-the-advantage-local-server-dll}

***Problem:*** The Advantage Local Server DLL could not be loaded. The Advantage Local Server will not be available to your Advantage application.

***Solution:*** Put the applicable Advantage Local Server DLL (ADSLOC32.DLL) somewhere in your client PC's search path (e.g., your \WINDOWS\SYSTEM directory).

## 6083 Error loading client expression engine DLL {#6083-error-loading-client-expression-engine-dll}

***Problem:*** The Advantage client expression engine could not be loaded.

***Solution:*** Your Advantage client expression engine may be corrupt or out of date. Reinstall the Advantage DLLs that ship with the version of the Advantage client used in your application.

## 6084 Error finding task in client expression engine DLL {#6084-error-finding-task-in-client-expression-engine-dll}

***Problem:*** The Advantage client expression engine DLL could not find the task for this process.

***Solution:*** Your Advantage client expression engine may be corrupt or out of date. Reinstall the Advantage DLLs that ship with the version of the Advantage client used in your application.

## 6087 IPX not installed {#6087-ipx-not-installed}

***Problem:*** IPX/SPX shell is not installed.

***Solution:*** Install the IPX/SPX shell.

## 6090 No structural index {#6090-no-structural-index}

***Problem:*** The header indicates a structural index exists, but it cannot be found.

***Solution:*** Make sure the structural index was not deleted or moved out of the directory where the table is located.

## 6091 Index(es) open on destination table {#6091-index-es-open-on-destination-table}

***Problem:*** A Copy To or Append From operation was attempted on the server, but index(es) are open on the destination table, so the operation was performed on the client.

***Solution:*** Close all open indexes on the destination table before attempting the Copy To or Append From operation on the server. Then re-open the indexes when the operation is completed and re-build the indexes.

## 6093 Table and index file on different servers {#6093-table-and-index-file-on-different-servers}

***Problem:*** The index file you are trying to open is not on the same server as the table.

***Solution:*** Make sure that the index file is on the same server.

## 6094 Login reject {#6094-login-reject}

***Problem:*** The server rejected the login because the maximum number of users was already logged in.

***Solution:*** Increase the number of users allowed to login.

## 6095 Too many tags {#6095-too-many-tags}

***Problem:*** The user is trying to create a tag in a CDX index file that already contains the maximum number of tags (256).

***Solution:*** Reuse an existing tag name, delete an existing tag first or use a different CDX index file.

## 6096 Not a compound index file {#6096-not-a-compound-index-file}

***Problem:*** A tag was being added to a file that is not a compound index file (CDX file).

***Solution:*** Use a compound index file for the operation.

## 6097 Bad IP address specified in connection path or in ADS.INI file {#6097-bad-ip-address-specified-in-connection-path-or-in-ads-ini-file}

***Problem***: The Advantage Database Server was not found at the IP address and port specified in the connection path or in the ads.ini file.

***Solution***: Verify the following:

| · | The IP address and port are correct for the Advantage Database Server you are trying to connect to. If you are specifying the address and port in the connection path (e.g., //server:port/path or //ip:port/path), verify that both are valid values. |
| --- | --- |

| · | The Advantage Database Server is currently running. |
| --- | --- |

| · | You can ping the IP address from the client machine to the server machine. |
| --- | --- |

| · | UDP packets are not filtered between the client and server machine. |
| --- | --- |

*[PO]: Purchase Order  
*[AZA]: local folder
*[(PO]: Purchase Order  
*[RQ]: Requisition  
*[(RQ]: Requisition  
*[RfQ]: Request for Quotation  
*[(RfQ]: Request for Quotation  
*[SO]: Service Order  
*[(SO]: Service Order  
*[SQ]: Service Requisition  
*[(SQ]: Service Requisition  
*[SRfQ]: Service Request for Quotation  
*[OoB]: Open on Board  
*[(OoB]: Open on Board 
*[ART]: Average Running Time (operation hours per day) 
*[MC]: Master Contract
*[ADS]: Advantage Database Server (database engine used in previous versions of the ZeeBORN software)
*[.replic]: file extension for replication files (aka data transfer files)