[cisco-voip] UCCX CUIC Lost Data

[Ed Leatherman]

Thanks Brian, that helped. We ended up having to stop replication and
re-create it to get it working again.

On Wed, Sep 28, 2016 at 11:24 AM, Brian Meade <bmeade90 at vt.edu> wrote:

> 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
>>
>
>


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