Control Compliance Suite (CCS) Reporting Database Synchronization job generates error 'The transaction log for database 'tempdb' is full.'
Last Updated August 29, 2011
System job 'Reporting Database Synchronization job' fails to complete successfully.
The following error is reported in the contents of the table dbo.ImportError in CSM_Reports database:
The transaction log for database 'tempdb' is full.
The transaction log for the tempdb database is full because of sizing limitations.
Use the following steps to tune tempdb settings for CCS:
WARNING: Incorrect use of Microsoft SQL Server may prevent the software from functioning properly. Special care should be taken when making changes to any SQL Server database(s) or table(s). Modifications should only be performed by people with experience using SQL Server. It is recommended that a complete backup of the database be made prior to making any changes.
Check Size and Space Available for tempdb (make a note of these values).
Check Initial Size (MB) for data file – tempdev. It is recommended that if the file size is less than the actual file size then change it to the actual size at that time OR set default value to 1 GB.
Check Initial Size (MB) for log file – templog. It is recommended that if the file size is less than the actual file size then change it to the actual size at that time OR set default value to 100 MB.
Check Autogrowth for data file – tempdev. it is recommended that this field is set to ‘By 500MB, unrestricted growth’
Check Autogrowth for log file – templog. it is recommended that this field is set to ‘By 10 percent, unrestricted growth’
Verify that the Recovery model: Simple.
Imported Document ID: TECH168194
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe