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) <pavd...@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: pavd...@cisco.com > > Phone: +1 (972) 204-8212 > > Hours: M-F, 10:00AM-6:00PM CDT (GMT-5) > > > > *From:* cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] *On Behalf > Of *Max Harmony > *Sent:* Wednesday, May 18, 2016 11:47 AM > *To:* Ed Leatherman <ealeather...@gmail.com> > *Cc:* Cisco VOIP <cisco-voip@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 <ealeather...@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 <bmaxi...@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@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.”*
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
