Call Pilot 150 with Enhanced Call Center Reporting

[blues5209]

This Call Center reporting has been running for years, suddenly real time reporting works but no call data is being collected. In mid August it stopped. Now all reports show 0's. Pre August reports show call stats?

 

[allworxguy]

Was the PC updated? Do a system restore back to the date it stopped working.

Marv ccna

http://www.telemarv.ca

Sales, Installation & Service for Norstar, BCM, Samsung & Allworx Serving Ottawa and Eastern Ontario since 1990

 

[blues5209]

I tried that, it had no effect on the problem. I re-booted the voicemail and the reporting pc multiple times with no effect.

 

[cook1082]

There is a problem in the SQL database the date needs to be bumped forward. Try this.

RCC / Contact Center data stopped downloading at a specific date. Need to bump Enddate. (BCM, CallPilot 150)
Rate this Page


Doc ID: SOLN217915
Version: 5.0
Status: Published
Published date: 08 Jan 2013
Updated: 03 Mar 2014
Author: Marcel Comeau


Details

• Reporting for Contact Center (RCC) reporting frozen on date.
• BCM400/BCM200/BCM1000 4.0, BCM50, BCM450 or CallPilot 150 using RCC 2.45+
________________________________________

Problem Clarification
Contact Center data status is green but no data is being downloaded past a certain date.

Cause
Call Detail Recording (CDR) data corruption.
Solution
Moved pass corrupted data / Contact Center data download resumed.

Please contact your business partner or Avaya support to resolve.
Restricted Solutions Elements
How to Bump Enddate for RCC through Command Prompt.
Open a command line and run each of those commands

1. cd Program Files\Microsoft SQL Server\90\Tools\Binn
2. Use one of these command. If it gives an error, try another.
o sqlcmd –S.\SQLEXPRESS –E
o sqlcmd –S.\RCCSQLEXPR –E
o sqlcmd -S.\SQLEXPRESS -dmaster -Usa -PYR46L43!
o sqlcmd -S.\RCCSQLEXPR -dmaster -Usa -PYR46L43!
3. use ccrdb
4. go
5. select * from rptrequesttimes
6. go
Have a look at the enddat, it is probably wrong. Resent the end date/time to a value later than the stuck date/time.
7. update rptrequesttimes set enddate=’2010-01-02 15:00:00’
8. go
Then, refresh the request times by doing:
9. select * from rptrequesttimes
10. go
==> do 9 and 10 over and over to see that the endtime is progressing, untilthe enddate is at the

 

[CarlinIT]

Verify all the host addresses on each callpilot are configured as well as the callpilot reporter, update to the latest 5.1 SU03 to keep things working the best, plus support gets handled more easily if you're up to date.