Transaction log full

Transaction log full

Logs:

 Depends On Me: com.adventnet.persistence.DataAccessException: [TierComponent] The transaction log for database 'supportcenter' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases


    at org.jboss.deployment.MainDeployer.checkIncompleteDeployments(MainDeployer.java:1155)

    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:607)

Solution:

There are two methods to fix this issue.

Method 1:

Please run the following query to shrink the size of the transaction log.

Executing this query brought the LDF file to around 1MB. 

USE supportcenter
GO
DBCC SHRINKFILE (supportcenter_log, 1)
BACKUP LOG supportcenter WITH TRUNCATE_ONLY
DBCC SHRINKFILE (supportcenter_log, 1)
GO
exec sp_helpfile

Please run this query after taking a Backup of the Database.

You can  run the Script to re-index the Tables in the DB.This shouldn't cause any problems.

The only thing that we insist on is to take a back up of the database before you attempt any of  these steps on the DB.

Please set the transactions logs growth to say 4 GB and set it to unrestricted growth, so that the logs will grow to the mentioned limit and then will overwrite the. This will prevent the logs to grow in size.





Method 2

To fix this issue, we have to detach SupportCenter database, after detaching we can delete the transaction log ( .LDF log) 
and attach the SupportCenter database back.

The important part in this process of attaching database will be removing the log path.The attaching database configuration window will show the path of the log (.LDF log), we have to remove the log path only then we will be able to attach the database

Following steps given below, explains in detail about the process of attaching and detaching database.


# Stop the SupportCenter Plus service.

# Connect to the SQL database, take a SQL backup and detach supportcenter database.


# After detaching the database, goto the location where the .LDF log file is located.

Follow the screenshots given below to delete the .LDF log

Eg:-

C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\DATA
 
Delete the "mike_log.LDF" log file


# Import and add the detached SupportCenter database as per the screenshot given below.



# In order to complete SupportCenter database attaching process, remove the .LDF log file path as per the screen shot given below and click OK.

The important part in this process of attaching database will be removing the log path.The attaching database configuration window will show the path of the log (.LDF log), we have to remove the log path only then we will be able to attach the database. 


# Restart the SupportCenter Plus service. 

          • Related Articles

          • Workaround for Backup Issues - Trimmed backup

            Nowadays the database size is huge in various users instance. It is because the indexing related files, archived files, file attachments are folder are huge in size. Due to which either our application is facing performance issues, Backup is not ...
          • Workaround to add Customized Header Image

            This is applicable only 110XX builds (till 11021). In 11021 users are unable to change the logo of the header image due to the Issue ID - 2538. Below mentioned is the workaround to add Customized Header Image.  -> In the application path ...
          • How to take console log ?

            This article is common for Servicedesk plus MSP and Supportcenter plus applications. To troubleshoot certain UI issues , JS errors , we need console log (output) from the browser. Steps to follow : 1. Login to the application. 2. Right click on the ...
          • To view the full title of the portal

            To view the full title of the portal in the Customer Portal Page: Step1.Go to the location given below and first take a backup of the files highlighted in Bold  ManageEngine\SupportCenterPlus\custom\style\aesm_portal.css and ...
          • Increase serverout log creation count to avoid log overwrite

            The logs get over-written depending upon the app usage. If you want to increase the number of files created for serverout logs, you may edit the logging.xml file (ManageEngine\SupportCenter\server\default\conf) and make the change like explained ...