The Cisco Customer Response Application (CRA) database log files, the tempdb database, or the tempdb log files have become large.
There are two resolutions for this problem:
To manually shrink a Cisco CRA database log file, open a command window on the Cisco CRA server and type these commands:
osql -Usa -Ppassword -ddb_cra, where password is the password for the sa log into 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.
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.
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.
Truncate the log files for both db_cra and db_cra_ccdr to 10 MB by entering runTruncatedHistDBLogs "sa" "sa_password" "db_cra_all" 10
Truncate the tempdb transaction log by entering runTruncateHistDBLogs "sa" "sa_password" "tempdb"
For more details about resolving Cisco CRA issues, refer to these documentation:
Hello, If I am mounting my (2) P60 Cameras to the ceiling, is there a way to invert the display of the video? In other words, because I am mounting my cameras to the ceiling and they will be upside down, is there a setting to ensure the video does no...
I wanted to know if I change the ad so that users have a new domain, those that are currently and that have a device associated, are they deleted? I mean the ones that I will import is the same user id but what changes the @domain. someone happened this s...
I am facing issue. Can someone please help. DC is located in HK, Where CUCM and UCCX are there. Few of the agents are in India. When India agents receive a call it shows HK time instead of India Local time on the Finesse. However their IP P...
Hello Guys, Is there any way to get, 1. Missed call alert for the calls received during off business hours. Alerts should be visible to agents when they logged in back during business hours. 2. Missed call alerts for the calls which g...
Hello Guys, I have a requirement. I have agents who shares skills - Support and Sales. And IVR is set as - Press 1 for Support and Press 2 for sales. Is there any way Agent can get information on the Finesse Agent Desktop about the ski...