In this blog post, let’s learn about the error message “377 Must terminate transaction before closing database.” in Hydra and the description of the error.
Error Message
377 Must terminate transaction before closing database.
Error Details
This statement (DATABASE, CREATE DATABASE, or CLOSE DATABASE) cannot be executed until the current transaction is finished.
Use either COMMIT WORK or ROLLBACK WORK and then close the database.
If you export a database and then import it, large-object handles (for images) will be different after you import the database.
Therefore, if you use static html references for images and export the database and then import it, you will have to determine the new large-object handle for each static html reference.