[cisco-voip] UCCX CUIC Lost Data

[Brian Meade]

Try "show uccx dbreplication tables" then look at the contactcalldetail
table:

REPLICATE:        template_db_cra_g_uccx106sub_uccx_1_3_contactcalldetail
STATE:            Active ON:g_uccx106pub_uccx
CONFLICT:         Timestamp
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      db_cra:informix.contactcalldetail
OPTIONS:          transaction,ris,ats,fullrow
REPLID:           131076 / 0x20004
REPLMODE:         PRIMARY  ON:g_uccx106pub_uccx
APPLY-AS:         INFORMIX ON:g_uccx106pub_uccx
REPLTYPE:         Master


On Wed, Sep 28, 2016 at 7:58 AM, Ed Leatherman <ealeatherman at gmail.com>
wrote:

> 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/5b918b93/attachment.html>