The Cisco Unified CCX server runs out of disk space

• 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.

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:

This troubleshooting tip also applies to the Cisco Unified CCX Database Problems section and the Cisco Unified CCX Historical Reporting Problems section.