What should I do if I have received mail saying transaction logs full?

What should I do if I have received mail saying transaction logs full?

Reason: 
You will receive this error if you are using Microsoft SQL back end for Applications Manager and if the transaction log for Applications Manager database or tempdb becomes full. If the log fills up, Applications Manager can only read and show data but cannot insert or update data being collected. User action is required to make log space available.

Solution: You can try the following steps to fix this problem:
  1. Shutdown Applications Manager.
  2. If you have sufficient disk space, increase the size of log file or add another log file to database.
  3. If you do not have sufficient disk space, move the log file to a disk drive with sufficient space or free disk space so that the log can automatically grow.
  4. Take a backup of the transaction logs of the Applications Manager back end database. For ex: BACKUP LOG AMDB TO DISK = 'd:\AMDB.bak'
  5. Change the Applications Manager back end database recovery mode to SIMPLE. For ex: ALTER DATABASE AMDB SET RECOVERY SIMPLE;
  6. Execute the DBCC SHRINKDATABASE for the back end database. For ex: DBCC SHRINKDATABASE (AMDB);
  7. For enabling future database backups, change the database recovery mode to FULL. For ex: ALTER DATABASE AMDB SET RECOVERY FULL;
  8. Start Applications Manager.

Note : If you do not have sufficient disk space or log file allocated space the problem may occur again after some time. It is recommended that you allocate sufficient disk / log file space for the SQL Database back end. For disk space requirement refer the following System requirements link: https://www.manageengine.com/products/applications_manager/help/system-requirements.html


                  New to ADSelfService Plus?

                    • Related Articles

                    • Transaction Count Mismatch Between APM Insight and applications

                      Transaction counts are crucial for understanding application performance. However, discrepancies between APM Insight-reported and application-reported counts can cause confusion. This article explores common causes and solutions for these mismatches, ...
                    • Can I view the trace of a web transaction that consumes more response time?

                      Please make sure that "Enable transaction tracing" option is enabled in Agent Configuration. Set the threshold for transaction tracing in "Transaction trace threshold" option (in seconds). Traces will be generated for any transactions that takes ...
                    • Folder path to view the Node.js agent logs

                      By default, the logs generated by the Node.js agent are stored in the apminsightdata folder, which resides in your application's current working directory. The log files can be found at: <app-path>\apminsightdata\logs If you would like to customize ...
                    • AppManager disk is full - I want to clear some space

                      Increased Applications Manager database utilization could have increased the Applications Manager Disk size. To clear some space, follow the steps below: 1. In the <AppManager_Home>\working\heapdump directory, check if any old files are present and ...
                    • Where can I see the .NET agent logs?

                      The .NET agent logs can be found only in the common application folder (Usually under C:\ProgramData\ from Vista onwards and C:\Documents and Settings\All Users\Application Data\ for Windows Server 2003. This is a hidden folder) Check the below ...