An out of memory error occurs on the Cisco CRA server

[TCC_2]

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:   

1. osql -Usa -Ppassword -ddb_cra, where password is the password for the SA log in to 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.     

  These are some examples:

     
  • Truncate the log files for both db_cra and db_cra_ccdr to 10 MB:             

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

• Diagnosing and Correcting Cisco CRA Problems      
• Cisco IPCC Error Codes      

[Hythim Ali El Hadad]

Hi TTC,

It is good to meet your DOC here

I have an error in SQL log in my CRS 4 as shown

crs could not allocate space for object FCRascalllogToday in database FCRasSvr

Error: 1105 severity 17 state 2

Also for FCRasStatelogToday

I decided to shrink as you said and need to confirm 3-things

1. Will I shrink only the log files as you said above or I'll shrink  FCRasSvr  DB itself and will this affect the CRS performance

2. If the customer don't know the sa password, is there any method to check it

3. will I use DB name FCRasSvr instead of db_cra as mentioned above or it is better to do shrink for both ?

Thanks a lot and waiting your feddback

Regards