Troubleshooting: Database transaction log full

Symptoms

The process ended abruptly when you were loading data or applying an upgrade. The sm.log file contains error messages that resemble the following:

[Microsoft][ODBC SQL Server Driver][SQL Server] The log file for database 'DB_Name' is full. Back up the transaction log for the database to free up some log space. (message,add.schedule)
An error occurred while attemping to add a record (file.load,add.record.0)

Resolution

Running an upgrade generates a huge number of transactions and this is likely to make the transaction log full. Restore the database to the latest pre-upgrade state, refer to the documentation for your RDBMS to increase the database transaction log size or enable auto-growth, and then restart the upgrade.