Check Log Space in MSSQL Server
DBCC SQLPERF('logspace')
If the error occurs:
The transaction log for database ‘AIMS’ is full due to ‘ACTIVE_TRANSACTION’
Alter the logging levels of the database as well as check available disk space:
Right Click database > Properties > Files, set the quota and grow