[cisco-voip] CCX 10.6 (HA) CUIC Missing Queue Report after Failover

[Max Harmony]

Hi Pavan,

Thanks for the advice, I contacted TAC and the issue was resolved,

The data on the servers was never compromised or lost.  This has been an
issue with the external server to connect to the data which resides on the
CCX servers.  The data replication between secondary and primary CCX data
stores was also always good.

The HRC user which was being used was *uccxhrcuser* which could only fetch
certain tables for the secondary.  Cisco TAC had to be engaged to get the
password for user *UCCXHRC *which is the Informix user account and only
available with TAC.  On 16th May, the secondary server was added as standby
data source on CUIC.  Please be aware that irrespective of whether the
server roles switch, this data resides at all times on both servers
irrespective of the server being queried unless it’s down.  Uccxhrcuser is
used for external fetching of data.


On Wed, May 18, 2016 at 1:34 PM, Pavan Dave (pavdave) <pavdave at cisco.com>
wrote:

> Max,
>
>
> In regards to reporting, when you go to “CCX Administration -> Tools ->
> Historical Reporting -> File Restore” on either node, do you seen a message
> similar to “** - Either there are no files to restore or restore is in
> progress.”?  If you do not see a message, it is because UCCX was having
> trouble talking to the database and wrote to flat files, which is why it is
> not showing up reporting. Restore this and try running reports again. If
> you do see the message it means that the data was not written to flat files.
>
>
>
> Based on the response and the fix, you may want to reach out to TAC to
> look into getting both nodes up as well as seeing if data may need to be
> restored.
>
>
> Regards,
>
>
>
> Pavan Davé
>
> Unified Communications TAC Engineer
>
> Cisco Systems – Richardson, TX, USA
>
> -------------------------------
>
> Email: pavdave at cisco.com
>
> Phone: +1 (972) 204-8212
>
> Hours: M-F, 10:00AM-6:00PM CDT (GMT-5)
>
>
>
> *From:* cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] *On Behalf
> Of *Max Harmony
> *Sent:* Wednesday, May 18, 2016 11:47 AM
> *To:* Ed Leatherman <ealeatherman at gmail.com>
> *Cc:* Cisco VOIP <cisco-voip at puck.nether.net>
> *Subject:* Re: [cisco-voip] CCX 10.6 (HA) CUIC Missing Queue Report after
> Failover
>
>
>
> Hi Ed,
>
>
>
> Thanks for your response, this just gets weirder by the day, currently we
> are still in Fail over mode, the initial issue was resolved, and that was
> when the fail over initially occurred, we lost our Wallboard Live data,
> then to resolve this we added the secondary server now (M) as a secondary
> Data source in CUIC, so the Live data came back but HR for Queueing was
> missing in the Custom reports. Some tables have data but just the Queue
> data is missing, I was wondering why just the Queueing data field is empty,
> is there something in Failback that prevents this from being available from
> Datasource of the secondary UCCX server?
>
>
>
> On Wed, May 18, 2016 at 8:41 AM, Ed Leatherman <ealeatherman at gmail.com>
> wrote:
>
> So if you manually re-run those reports, is the data there? Are both nodes
> back online or is primary still off line - perhaps the data in question
> hadn't replicate when the failure occurred. If they are both back online,
> is the replication OK?
>
>
>
> On Tue, May 17, 2016 at 12:29 PM, Max Harmony <bmaxim88 at gmail.com> wrote:
>
>
>
> I need guidance on an issue that I am running into on CUIC.
>
>
>
> Our UCCX cluster is HA, we failed from P to S and now missing some reports
> that get generated nightly via a data source, specifically the
> ContactQueueDetail table is missing in our reports, can anyone guide me in
> the right direction, I want to check and see if the data exist in UCCX, or
> was actually generated but just not passed over to the datasource
>
> Where do I begin?
>
>
>
>
>
> --
>
> --
> Grace Maximuangu
>
>
>
> CloudPOP/InvictaCloud
>
> www.cloudpop.com
>
>
>
>  *“Go beyond your limits, push yourself, be the best you can be.*
>
> *Experience new cultures, broaden your horizons, stay connected.”*
>
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
>
> --
>
> Ed Leatherman
>
>
>
>
>
> --
>
> --
> Grace Maximuangu
>
>
>
> CloudPOP/InvictaCloud
>
> www.cloudpop.com
>
>
>
>  *“Go beyond your limits, push yourself, be the best you can be.*
>
> *Experience new cultures, broaden your horizons, stay connected.”*
>
>
>



-- 
-- 
Grace Maximuangu

CloudPOP/InvictaCloud
www.cloudpop.com

 *“Go beyond your limits, push yourself, be the best you can be.*
*Experience new cultures, broaden your horizons, stay connected.”*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160519/8e4246d7/attachment.html>