One possible reason for transaction failure is running out of data device space. If this situation occurs, HADB will write warnings to the history file, and abort the transaction which tried to insert and/or update data.
Typical messages are:
HIGH LOAD: about to run out of device space, ... HIGH LOAD: about to run out of device space on mirror node, ...
The general rule of thumb is that the data devices must have room for at least four times the volume of the user data. Please refer to the Tuning Guide for additional explanation.