RCC - no activity codes selected for period 1

[Takst3r]

Hi All,

My RCC database file in SQL was over 2.5 gigs big and slowly started giving issues when trying to pull reports. I then performed a shrink of the database using SQL Management Studio . Also performed a purge. The purge dates were as follows 16-02-2010 until 28-02-2010.There after I was able to pull reports successfully and at a reasonable time. However I am not able to pull activity code reports from the day I shrunk the DB which was 5th auagust 2011. Any activity reports before this date is gone anything after this date is there. Is there a way to fix. Not sure if the shinking deleted this information but then would assume that the other data would also be gone.

 

[pkellow]

It looks like the purge has wiped the activity code tables in the database in error due to a bug (I hope you took a backup of the RCC database before the purge). I seem to recall a bug from the past which did the same. Don't know your version of RCC or how old/new it is. Assuming it's based on Microsoft SQL, do this in command line:

C:\WINNT\SYSTEM32> cd \
c:\cd "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
sqlcmd -S.\RCCSQLEXPR

>use ccrdb
>go
>C:\WINNT\SYSTEM32> cd \
c:\cd "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
sqlcmd -S.\RCCSQLEXPR

>use ccrdb
>go
>select count(*) from rptcalldataactivitycode where PegTimeStart < '2007-09-20 09:05:00.000'
>go


The quotes are specific and the date I gave here is a sample. In your case this would be 2011-08-05 00:00:01. Meaning "give me the record count of all activiy codes entered before the date you purged". If zero, indeed the purge has wiped them or screwed a table up. You can also:

select count(*) from rptcalldataactivitycode where PegTimeStart > '2011-08-05 09:05:00.000'

meaning give you the record count after the day you purged. This will probably be a positive value, meaning the data is now being collected after the purge.

If the record count is positive before the purge date, it might just be a bug presenting the data, however I suspect it will be a zero record count and it's wiped it.

 

[Takst3r]

Thanks Pkellow,

I will try and engage your recommendation. Its a bit rough here so I just need to fine the right time. Will let you know the outcome.Im crossing my fingers