Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

Errors occur when the user accesses purging or synchronization pages under Cisco CRA Administration

Core Issue

The Cisco Customer Response Application (CRA) database log files, the tempdb database, or the tempdb log files have become large.

Resolution

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:

    1. osql -Usa -Ppassword -ddb_cra, where password is the password for the sa log into the Cisco CRA database.

    2. USE database_name, where database_name is db_cra or db_cra_ccdr, depending on the Cisco CRA database that you want to shrink. 

    3. GO

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

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

    Examples:

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


    375
    Views
    0
    Helpful
    0
    Comments