Core Issue
The Cisco Customer Response Application (CRA) database log files, the tempdb database or the tempdb log files have become large.
Resolution
To resolve this issue, choose from one of these actions:
- To manually shrink a Cisco CRA database log file, open a command window on the Cisco CRA server and issue these commands:
- osql -Usa -Ppassword -ddb_cra, where password is the password for the SA log in to the Cisco CRA database
- USE database_name, where database_name is db_cra or db_cra_ccdr, depending on the Cisco CRA database that you want to shrink
- GO
- DBCC SHRINKFILE (database_name_log.mdf), where database_name is db_cra or db_cra_ccdr, depending on the Cisco CRA database that you want to shrink
- 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, db_cra_ccdr or tempdb.
These are some examples:
Additional information can be found about truncating logs in the Managing the Cisco CRA Historical Report Databases section of the Cisco CRA Administrator Guide.
For more information on resolving Cisco CRA and Customer Response Solution (CRS), refer to these documents: