|
Troubleshooting |
  
|
|
Troubleshooting |
|
Troubleshooting
Error 5004 AE_FILE_NOT_FOUND
Problem: Either the Advantage Client Engine could not find the specified file, or you do not have sufficient rights to access the file or may not be able to find the file at all.
Solution: Verify the following:
| 1. | Make sure that the file does exist. |
| 2. | If the file does exist then make sure you have "read/write" access. To do this you simply right mouse click on the file and from the menu choose properties and at the bottom you will have a Attributes section where you can see if "read-only" or "hidden" is checked, if so then uncheck that selection. |
| 3. | Make sure that Turbo Title is pointing to the right directory with the data files. To check this refer to Maintenance / Preference Setup |
Error 6420 Unable to "discover" the Advantage Database Server
Problem: The name resolution is not working properly or data packets are unable to be transferred to/from the Advantage Database Server.
Solution: Several problems can cause this error to occur. Reference the Advantage Knowledge Base for a detailed description and known cases when this error can occur.
| 1. | If the server is NetWare 5.x, make sure the version of the Advantage Database Server is 5.6 or newer, and make sure the Advantage client is v2.6 or newer. If communicating to a server that only has IPX installed, make sure the Advantage client is enabled to send IPX packets. If running through a firewall, make sure the Advantage IP send and receive ports are properly configured and opened up through the firewall. |
Error 7008 Advantage server file open failure
Problem: The specified table, memo file, or index file was unable to be opened.
Solution: Verify the following:
| 1. | The file exists and the user has sufficient access rights to open the file. (The location and name of the file that received the 7008 error can be found in the ADS_ERR.DBF file. This file is stored on the root of the C:\ drive) This file must be opened using ARC32. |
| 2. | The file is not already open exclusively by another Advantage user. If another Turbo Title user is currently working on that file then it cannot be opened until they are finished. |
| 3. | When creating a table, index, or memo file, verify that it already exists and another application does not have it opened. |
| 4. | If re-indexing make sure that all Turbo Title users are logged out of Turbo Title and there are no current connections to the database. |
| 5. | If attempting to open a table via the Advantage Local Server, make sure it is not already opened by another connection via the Advantage Database Server. |
| 6. | If attempting to open a table previously used in a query, verify that the query called AdsCloseSQLStatement. If the query did not call AdsCloseSQLStatement the table will be cached open by the server for performance reasons and exclusive access will be denied. |
NOTE: A file open error will be logged in the Advantage Database Server error log, ADS_ERR.DBF. If an error sequence is logged with error codes 16,128, and 7008 (for the Advantage Database Server for NetWare), or 32 and 7008 (for the Advantage Database Server for Windows NT/2000 or the Advantage Database Server for Windows 95/98/ME), this indicates that a non-Advantage application already has the file open, and the Advantage application is attempting to open the file using Advantage Proprietary Locking or Exclusive mode. Note that the other application that has the file open could also be backup software or a report writer.
Error 7057 Record update failed;
Problem: The key value produced from this record was not unique, and the index for the current table has the UNIQUE property. This error most commonly occurs when you are trying to add a new customer or any entry that requires a unique ID or Code. If you are trying to assign an ID or Code that is currently taken within Turbo Title then you will receive this error.
Solution: Simply replace the key value field(s) with a unique value(s). If this is not possible, cancel the operation.