The Cisco Unified CCX server runs out of disk space

From DocWiki

(Difference between revisions)
Jump to: navigation, search
m (1 revision)

Revision as of 19:50, 12 August 2009

The Cisco Unified CCX server runs out of disk space

Problem Summary Possible symptoms are:
  • An out of memory error occurs on the Cisco Unified CCX server.
  • Accessing purging or synchronization pages on the Administration UI returns an error.
  • Running historical reports returns SQL error 5048.
Error Message SQL error 5048.
Possible Cause The Cisco Unified CCX database log files, the tempdb database, or the tempdb log files have grown large.
Recommended Action

There are two possible actions you can take:

  • To manually shrink a Cisco Unified CCX database log file, open a command window on the Cisco Unified CCX server and type the following commands:
osql -Usa -Ppassword -ddb_cra, where password is the password for the sa log in to the Cisco Unified CCX database.
USE database_name, where database_name is db_cra.
GO
DBCC SHRINKFILE (database_name_log.mdf), where database_name is db_cra.
GO
  • Alternatively, you can shrink the log files by running the batch file runTruncateHistDBLogs.bat, installed under the wfavvid directory. Depending on the arguments, it shrinks the log files of db_cra or tempdb.

Examples

  • Truncate the log files for db_cra to 10MB: runTruncatedHistDBLogs “sa” “sa_password” “db_cra_all” 10
  • Truncate the tempdb transaction log: runTruncateHistDBLogs “sa” “sa_password” “tempdb”

Additional information can be found about truncating logs in the Managing Historical Reporting Databases section of the Cisco Unified CCX Administration Guide.

Note Note: This troubleshooting tip also applies to the Cisco Unified CCX Database Problems section and the Cisco Unified CCX Historical Reporting Problems section.
Release Release 7.0(1)
Associated CDETS # None.

Rating: 3.0/5 (1 vote cast)

Personal tools