This document describes how to clear a transaction log of the Cisco Intelligent Contact Management (ICM) database. This procedure is necessary only when you see that the transaction log is filled with SQL errors in the SQL error log. For example:
2000/11/09 03:00:25.90 spid26 Error : 1105, Severity: 17, State: 2
2000/11/09 03:00:25.90 spid26 Can't allocate space for object 'Syslogs' in
database 'csco_awdb' because the 'logsegment' segment is full. If you ran
out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE
or sp_extendsegment to increase the size of the segment.
These messages appear in various Cisco ICM process windows.
Note: This document is valid only for Microsoft SQL Server version 6.5 with all Cisco ICM versions.
Cisco recommends that you have knowledge of these topics:
The information in this document is based on these software and hardware versions:
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.
Refer to Cisco Technical Tips Conventions for more information on document conventions.
SQL Server uses a transaction log to keep track of all the transactions that run at any given moment. Occasionally a transaction is complete, but SQL erroneously does not list the transaction as complete. When this situation arises, the transaction remains in the transaction log. If several such unlisted transactions accumulate, the transaction log can become full, and cause Cisco ICM services to stop.
There are three types of SQL databases in the Cisco ICM system:
The transaction log for any of these databases can get filled to 100% capacity with transactions that are complete but unlisted.
In order to clear a transaction log, complete these steps:
Go to Start > Program Files > Microsoft SQL Server 6.5 on the system that has the problem.
A connection screen opens.
Type the name of the system on which you are working (for example, GEOCSCOLGRA).
If the connection is successful, a query window appears.
From the drop-down menu at the top of the query window, select the name of the database that has the problem (for example, csco_sideA).
Type in these statements with each statement on a separate line.
dbcc checktable (syslogs)
dump tran <database name> with no_log
dbcc checktable (syslogs)
Modify the text in angular brackets (for example, change <database name> to csco_sideA).
At the top of the query window, click Execute (the green arrow).
If the transaction log dump is successful, the results look like what you see here:
Note: The percent of Log Space Used (%) in the csco_sideA database is near zero.
Database Name Log Size (MB) Log Space Used (%) Status
------------- ------------- ------------------ ------
cust1_sideA 100.0 0.00195313 0
pubs 0.0 0.0 1
msdb 2.0 0.292969 0
tempdb 0.0 0.0 1
model 0.0 0.0 1
master 0.0 0.0
After you dump the transaction log, stop and restart the Cisco ICM services for that system.