Summary
This article discusses how to resolve a transaction log full error.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].
- In SQL Server Mgt Studio? select each BDNA database (separately)...
- Right Click.. select Properties
- Select Options
- Ensure recovery mode = ?Simple?
- Click OK
- Right click the Database again
- Select Task > Shrink > Files
- In ?File Type:?? select ?Log?
- Click OK
- Repeat steps above for each BDNA database
-----------------------------------------------------------------------------------------------------
Alternatively.. you could use SQL directly?
ALTERDATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)
Related Articles
ARL Import process can require significant compliance database transaction log space, potentially failing with error: "The… 6Number of Views System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'FNMSCompliance' is full due to 'LOG_BAC… 78Number of Views Force a full Technopedia catalog sync 41Number of Views Data Update Job fails due to insufficient transaction log space 73Number of Views "Connection Reset" error when attempting to log in to User Console 10Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago