BCM400 4.0 with Reporting for Call Center

[techguy74]

Good Afternoon,

My client blew up their reporting for call center Windows XP machine and asked me to reload the software onto a new machine. Prior to doing so, I decided to update their switch with all of the latest patches. My customer (IT Manager), had written some software to detect if the Reporting stopped working as they bill using the software (Scary)

Anyways, I doubt if anyone has the answer (except the developer, but I will throw it out there.

" I need to confirm that the new installation of the call centre reporting has migrated the database from MYSQL to Microsoft SQL Server and what is the “sa” password? "

Any thoughts? The reporting is back up and running fine, he just wants his software to monitor the Reporting for Call Center again.

Cheers

 

[pkellow]

hi techguy74,

I'm a little lost.

If the old machine blew up with RCC (presumably RCC 2.4.xxx based on mysql), then you applied the latest patches to the BCM, and downloaded and installed RCC 2.45.xxx (based on Microsoft SQL), how did you recover the database on mysql4 first? If you simply downloaded and installed RCC 2.45.xxx on a new PC, without recovering the old mysql4 (or ccrdb directory), then effectively you have a new installation of RCC, which would download a maximum of 16000 calls from the BCM....perhaps significantly less on a BCM 4.0 (due to performance issues could be 4000-5000).

Within RCC, under Maintenance, there is a purge utility, which will report on the oldest data in the database, albeit this could be any data, not just the oldest call.

From command line:

C:\WINNT\SYSTEM32> cd \
c:\cd "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
sqlcmd -S.\RCCSQLEXPR
>use ccrdb
>go
>select count(*) from rptcalldata where StartTime<'2007-09-20 09:05:00.000';

to determine if there is a record count (i.e. any records) changing the date to determine the first calls in the database. Does this include the time frame and includes the old database, or meet customer requirement? Otherwise do you still have a backup of the CCRDB directory from the PC that 'blew up'? If no, you have no way or recovering further data.

PS I do know the sa password, however not appropriate to post it to a forum.

Hope this helps.

 

[techguy74]

Good Evening pkellow,

I was able to download enough records from the BCM when I re-installed the Reporting for Call Center to keep the client happy.

Being the IT Managerof this company, he has written some software to manage the Call Center to ensure it is receiving data. To be honest, I have no clue what the SA password is used for or why he requires it.

He just notices something would not work with his software program once I uploaded the latest patches.

Anyways, I understand that you cannot post the password here, so I will continue to search!

Thanks

 

[Quirkafleeg]

The sa user account stands for superadmin. It is used to do the administrative and editing operations on databases.
Alternatively, users can be created with certain rights that allow such operations. RCC does not create any users that do more than reading and backing up of the database.

Through past experiences, it is unwise for anyone but those with intimate knowledge of RCC to know the sa password. Those without such knowledge have been known to break the entire RCC software by "tinkering".

 

[bbanea]

Pkellow, I'm trying to use your guide to restoring the encryption keys on a broken RCC Reporting Service. I don't know the sa password of the RCC installation.. the scripts create it on its own. How can you contact me in private with the sa password.

Thanks