cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

Running Cisco CRA historical reports returns an SQL error

1669
Views
0
Helpful
0
Comments

Core Issue

The Cisco Customer Response Applications (CRA) database log files, the tempdb database, or the tempdb log files have become large. SQL error 5048 is returned.

Resolution

To resolve to issue, perform one of these procedures:

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

    • 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 runTruncateHistDBLogs.bat batch file, installed under the wfavvid directory. Depending on the arguments, it shrinks the log files of db_cra, db_cra_ccdr, or tempdb.    

    These are 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 additional information about truncating logs, refer to the Managing Historical Reporting Databases.

For details about troubleshooting Cisco CRA/Customer Response Solutions (CRS), refer to these documents:

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here