Question

What causes the Exception: MS SQL transaction log is full?

Answer 1

See KB article on How to shrink MS SQL Server transaction logs for the QIE database?

Comments

If point-in-time recovery isn't necessary on your SQL database you can set the database to Simple recovery mode.  Doing this should make it so you don't ever have a full transaction log.