I am currently unable to generate any reports from the RCC server. This was previously working fine and their has been no configuration changes on the BCM but then suddenly I can't generate any reports. After selecting the report I want to generated and clicking view it immediately dumps me back to the report page without launching the report viewer. This is happening no matter what report I select, even system configuration report. I turned logging on and this is the error I see in my report_exception_error.log:
INFO: Error in writeCallData
EXCEPTION: Duplicate key or integrity constraint violation message from server: "Duplicate entry '{01257db5-a5d0-4800-b889-9fb5d6099507}' for key 2"
------------------
I've been working on this for a couple of day and so far I've tried the following:
1. I tried starting and stopping the services, but given that this is a data error I wasn't expecting an effect.
2. Purged the database.
3. Uninstalled and installed RCC server and MySQL.
4. Purge the database.
5. When configuring the BCM connection I only selected call data from 1/1/2014
6. Ran the dbfixutil (dbfixutil says no errors)...However, this runs the MySQL "repair table" command which does not catch duplicate key errors so no surprise their.
7. Rebuilt the MySQL database multiple times.
None of these seemed to have an effect. At this point I'm pretty sure it's the BCM that's sending me invalid data, but I can't figure out what or how to fix it. I've gone through my BCM Element Manager and CallPiolet Manager to make sure the configuration is still good. I'd like to go into MySQL and delete the duplicate key, but I'm not even sure what table this is in or what data it is from the BCM that's causing the duplicate.
Any help would be appreciated.
INFO: Error in writeCallData
EXCEPTION: Duplicate key or integrity constraint violation message from server: "Duplicate entry '{01257db5-a5d0-4800-b889-9fb5d6099507}' for key 2"
------------------
I've been working on this for a couple of day and so far I've tried the following:
1. I tried starting and stopping the services, but given that this is a data error I wasn't expecting an effect.
2. Purged the database.
3. Uninstalled and installed RCC server and MySQL.
4. Purge the database.
5. When configuring the BCM connection I only selected call data from 1/1/2014
6. Ran the dbfixutil (dbfixutil says no errors)...However, this runs the MySQL "repair table" command which does not catch duplicate key errors so no surprise their.
7. Rebuilt the MySQL database multiple times.
None of these seemed to have an effect. At this point I'm pretty sure it's the BCM that's sending me invalid data, but I can't figure out what or how to fix it. I've gone through my BCM Element Manager and CallPiolet Manager to make sure the configuration is still good. I'd like to go into MySQL and delete the duplicate key, but I'm not even sure what table this is in or what data it is from the BCM that's causing the duplicate.
Any help would be appreciated.
