ā08-17-2011 11:28 AM - edited ā03-14-2019 08:23 AM
The FCRasSVR database filled up (2048 MB) a couple of days ago in this UCCE deployment, which is causing issues such as agent statistics not populating in Supervisor Desktop. I am not able to find anything about this anywhere in any CAD documentation. Is it ok to just allocate more space to the DB, or does it need to stay 2048 MB? If it needs to stay, what can be done to free up space?
Solved! Go to Solution.
ā08-20-2011 12:45 PM
I think you are hitting the 2GB size limit of MSDE which is used by the FCRasSVR db
You can shrink the db from SQL Enterprise Manager, right click on the āfcrassvrā (RASCAL) database, and select āShrink Databaseā¦ā under āAll Tasksā.
After clicking the āFilesā¦ā button, select the appropriate file that needs to be shrunk (either the data file or the transaction log) and click āOKā
You can see the respective size of both the database and the transaction log by right-clicking the database and selecting āPropertiesā (Data Files and Transaction Log tabs, respectively).
Truncate the below table to freeup all the data
truncate table FcRasStateLogToday
truncate table FcRasRecordLog
truncate table FcRasCallLogWeek
truncate table FcRasCallLogToday
MSmerge_tombstone (this one will clear up most of the data)
You should check that that all CAD jobs specially the cleanup one are running correctly(unders sql server agent) these jobs help to purge the db automatically. Check agent jobs on both servers to make sure theyāre running. If jobs do not run successfully, change their credentials to run under ā
Check that the RASCAL replication is working
use select count * from fcrascalllogweek" on both systems databases. This should now return the same number of rows if replication is set up correctly if the system is live this might not exactly matchup as it takes some time for the two db's to replicate.
Hope this helps.
Shirish.
ā08-20-2011 12:45 PM
I think you are hitting the 2GB size limit of MSDE which is used by the FCRasSVR db
You can shrink the db from SQL Enterprise Manager, right click on the āfcrassvrā (RASCAL) database, and select āShrink Databaseā¦ā under āAll Tasksā.
After clicking the āFilesā¦ā button, select the appropriate file that needs to be shrunk (either the data file or the transaction log) and click āOKā
You can see the respective size of both the database and the transaction log by right-clicking the database and selecting āPropertiesā (Data Files and Transaction Log tabs, respectively).
Truncate the below table to freeup all the data
truncate table FcRasStateLogToday
truncate table FcRasRecordLog
truncate table FcRasCallLogWeek
truncate table FcRasCallLogToday
MSmerge_tombstone (this one will clear up most of the data)
You should check that that all CAD jobs specially the cleanup one are running correctly(unders sql server agent) these jobs help to purge the db automatically. Check agent jobs on both servers to make sure theyāre running. If jobs do not run successfully, change their credentials to run under ā
Check that the RASCAL replication is working
use select count * from fcrascalllogweek" on both systems databases. This should now return the same number of rows if replication is set up correctly if the system is live this might not exactly matchup as it takes some time for the two db's to replicate.
Hope this helps.
Shirish.
ā08-20-2011 01:45 PM
A well known problem and Shirish provided excellent advice. Just connect to the MSDE CADSQL database from another box where you have SQL Enterprise running. Go to the SQL server registration wizard and add
Under certain conditions the FACRasSvr can become "overfull" and FACRasSvr DB will show as "(Suspect)". This is a much harder problem to solve, but you can fix it. Post back if this is the case and I'll help you.
Regards,
Geoff
ā09-06-2011 11:11 PM
Well, FACRasSvr became overfull, but it does not show as "Suspect" anywhere that I can see. If I try to connect from SQL Enterprise, it says that it cannot connect to the database due to the file being full, or it is out of memory. If you wouldn't mind, I would appreciate hearing how to solve this, because I have a TAC case open but they haven't been able to solve it yet. They had me copy the database over to a full SQL instance, truncate it, then copy it back to the PG (shutting down MSDE SQL at the appropriate times, of course). I did this, as instructed, but still can't connect to the database.
ā09-07-2011 05:04 AM
Send me an email to geoff AT hp DOT com and I'll send you the document I wrote regarding this. Perhaps it will help you. I am very surprised that the method TAC provided did not work. When you copied the DB to a full SQL instance you were certainly able to connect to it - since you truncated it.
Regards,
Geoff
ā10-12-2011 10:58 AM
I have a similar problem.
FCRasSvr_Data.mdf size of about 7GB
Biggest table MSmerge_tombstone 41 million records
What should I do?
ā10-14-2011 06:49 AM
Follow the excellent advice above from Shirish and truncate that table. It's the culprit.
Regards,
Geoff
ā10-14-2011 01:59 PM
Thank you. So did
1. Stop replication between CAD sides
2. Delete replication on Mssql
3. Truncate
4. Shrink
5. Start replication between CAD sides
FCRasSvr_Data.mdf size 460Mb
ā10-15-2011 04:49 PM
Yep, that'll fix it.
Regards,
Geoff
ā01-16-2012 01:27 AM
Hi,
I have this error in my IPCC Express not Enterprise
CRS could not allocate space for object FCRascalllogToday in database FCRasSvr
Error: 1105 severity 17 state 2
Also for FCRasStatelogToday
So there is no free space in FCRasSvr
I need to confirm the method I should follow from these three:
1. Right click the FCRasSvr DB > shrink > then choose the transaction log files
or
2. shrink the log files by running the batch file runTruncateHistDBLogs.bat in wfavid
or
3. or use this method:
osql -Usa -Ppassword -ddb_cra
USE database_name
GO
DBCC SHRINKFILE (database_name_log.mdf), where database_name is FCRasSvr
GO
Also Can I TRUNCATE these tables as advised above without affecting the call center health
truncate table FcRasStateLogToday
truncate table FcRasRecordLog
truncate table FcRasCallLogWeek
truncate table FcRasCallLogToday
MSmerge_tombstone (this one will clear up most of the data)
Regards
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide