Advantage 61xx Error Codes

Advantage Error Guide

6101 Transaction command out of sequence
6102 XXXXXX is illegal during a transaction
6103 Failed transaction recovery error
6104 Invalid Password
6105 Password is required for this operation
6106 Non-compound IDX contains FTS index
6107 Index file with FTS indexes was not reindexed

6101 Transaction command out of sequence

Problem: The application contained a nested transaction.

Solution: Make sure a BEGIN TRANSACTION command is followed either by a COMMIT TRANSACTION or a ROLLBACK TRANSACTION before another BEGIN TRANSACTION is issued. Also, a COMMIT TRANSACTION or a ROLLBACK TRANSACTION cannot be issued without first issuing a successful BEGIN TRANSACTION.

6102 XXXXXX is illegal during a transaction

Problem: The application issued an illegal command (where XXXXXX is the illegal command) during a transaction.

Solution: The following commands and their associated functions are illegal and will not be performed when used within a transaction:

·	UNLOCK, AX_Unlock(), dbUnlock(), dbUnlockAll(), dbRUnlock(), AX_IsLocked()

·	PACK, ZAP

·	REINDEX, dbReindex()

·	DELETE TAG, AX_KillTag(), ordDestroy()

·	AX_DBFEncrypt(), AX_DBFDecrypt()

·	AX_File2BLOB()

·	CLOSE, CLOSE INDEXES, AX_ClearOrder(), dbCloseArea(), dbClearIndex()

Note A CLOSE command will not only cause an error, it will actually close the table and any open indexes in the work area and then rollback the current transaction.

6103 Failed transaction recovery error

Problem: The AX_TPSCleanup() function failed to complete a failed transaction recovery.

Solution: Make sure the table or index files associated with the failed transaction were not opened by another application. This error can also occur if the transaction log file could not be opened. Refer to the error log file, ADS_ERROR.ADT or ADS_ERR.DBF, for more specific errors related to this failure.

6104 Invalid Password

Problem: The CA-Clipper RDD AX_SetPassword function failed because the password given does not match the one used to encrypt the records in the current table.

Solution: Make sure the correct password is supplied to the function. Advantage allows one password per table. The encryption information is stored in the table header when the password is set on the table for the first time. The password is stored in encrypted form and it cannot be retrieved if forgotten.

6105 Password is required for this operation

Problem: Advantage CA-Clipper applications require that encryption be enabled via the correct password in order to update an encrypted record. This error is returned if an attempt is made to modify an encrypted record without encryption having been enabled.

Solution: Use the AX_SetPassword function to enable encryption before attempting to modify the encrypted record.

6106 Non-compound IDX contains FTS index

Problem: The Advantage Clipper RDD attempted to open a non-compound index (IDX) file that contains a full text search (FTS) index. The Advantage Clipper RDD does not support IDX index files with FTS indexes.

Solution: Use compound index (CDX) files.

6107 Index file with FTS indexes was not reindexed

Problem: This is an informational code that indicates the Advantage Clipper RDD did not rebuild at least one of the index files during a reindex operation because the file contains one or more full text search (FTS) tags. The RDD ignores FTS index files during reindex operations. This informational code can be retrieved after a call to reindex (or dbreindx()) via the AX_Error() function.

Solution: To rebuild index files that contain FTS tags, use another Advantage client or Advantage Data Architect.