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
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.
Technical Tips Conventions for more information on document
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
Go to Start > Program Files
> Microsoft SQL Server 6.5 on the system that has the
A connection screen opens.
Type the name of the system on which you are working (for example,
If the connection is successful, a query window
From the drop-down menu at the top of the query window, select the
name of the database that has the problem (for example,
Type in these statements with each statement on a separate
dbcc checktable (syslogs)
dump tran <database name> with
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
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
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.