cancel
Showing results for 
Search instead for 
Did you mean: 

Error using transactions on Advantage Database Server

wolverine
Explorer
0 Kudos
789

Good morning, today I encountered the following error:


Error 7200: AQE Error: State = HY000; NativeError = 8018; [iAnywhere Solutions][Advantage SQL][ASA] Set end of file error. ** Script error information: -- Location of error in the SQL statement is: 1

This error appears when executing a SQL statement within a transaction:

BEGIN TRANSACTION;

//statements

If i remove BEGIN TRANSACTION; the code is executed without errors.

The help by itself doesn't help me much with this particular code. Previously I solved many problems by reading the https://devzone.advantagedatabase.com knowledge base but it no longer exists and I don't know where to look for more information.

Regards.

Accepted Solutions (0)

Answers (1)

Answers (1)

jeremy_stonehouse
Participant
0 Kudos

Closest match I can see is 8018 error triggering where server has insufficient disk space to write the transaction processing logs?

wolverine
Explorer
0 Kudos

Hi, exactly, that was the problem. Yesterday i check that the disk had practically no space. Not only the Advantage Database Server fails.

Regards.