Summary

Synopsis

If Transaction Log becomes full on SQL Server... this will cause Technopedia Sync to Fail.

Updater log indicates the following:
Error: The transaction log for database 'BDNA_PUBLISH_####' is full due to 'ACTIVE_TRANSACTION'.

Discussion

Transaction Logs for databases need to be shrunk. To resolve this, you can do the following [in SQL Server 2008] (to clear up all BDNA DB Transaction Log space):

Note: You should backup the Transaction Log before proceeding [those steps are not below].

1. In SQL Server Mgt Studio? select each BDNA database (separately)...
   1. Right Click.. select Properties
   2. Select Options
   3. Ensure recovery mode = ?Simple?
   4. Click OK
   5. Right click the Database again
   6. Select Task > Shrink > Files
   7. In ?File Type:?? select ?Log?
   8. Click OK
   9. Repeat steps above for each BDNA database

-----------------------------------------------------------------------------------------------------
Alternatively.. you could use SQL directly?
ALTERDATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)