[cisco-voip] UCCX CUIC Lost Data

[Ed Leatherman]

I'm troubleshooting UCCX/CUIC issue with lost data (and assorted weird
things), and I ran across this gem of a thread that helped me get a
fingerhold on the issue...

I ran Brian's query "select count(*) from contactcalldetail blahblah for
yesterday. Primary node has records, secondary has 0. I rebooted both last
night, and no magic this morning so I'm assuming still a replication
problem... is there a special set of commands for CUIC data replication? My
google-fu is failing me on this one. The normal utils dbreplication
runtimestate reports that everything is happy but i have a suspicion thats
just for the other ccx datastores.

Issue was triggered by vmotioning primary node off of a host that needed
repair... really strange issue as it also made the CUIC console think it
was October already (including all the scheduled reports) until we reset
that service. system clock was fine though.

I have a TAC case open also but engineer doesn't start till later so i'm
just trying to get a leg up on the issue before the townsfolk show up at my
lair with torches and pitchforks.




On Thu, Jan 28, 2016 at 5:39 PM, Brian Meade <bmeade90 at vt.edu> wrote:

> So overnight this fixed itself and now all of the data is showing in
> CUIC.  There must be some sort of process that runs at night to fix these
> kinds of things.
>
> On Wed, Jan 27, 2016 at 5:48 PM, Brian Meade <bmeade90 at vt.edu> wrote:
>
>> Hey everyone,
>>
>> I'm seeing an issue with UCCX 10.6(1)10000.39 where database replication
>> between the 2 UCCX nodes was having issues resulting in no new call data
>> being populated in the CUIC Historical Reports such as the Detailed Call by
>> Call CCDR report.
>>
>> We fixed the replication issue and now new calls are showing in the CUIC
>> report successfully but we still have a gap of missing data in the reports.
>>
>> The actual call records look to be in the database:
>>
>> admin:run uccx sql db_cra select count(*) from contactcalldetail where
>> startDateTime >= '2016-01-27 00:00:01'
>> (COUNT(*))
>> ----------
>> 20519
>>
>> But CUIC is only pulling in the new calls.  Any ideas how to fix this?
>>
>> Thanks,
>>
>> Brian
>>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>


-- 
Ed Leatherman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160928/53d96369/attachment.html>