[cisco-voip] Unity 10.5.2 "promote" subscriber

[Natambu Obleton]

I have run into an issue where my publisher was shutdown because of an issue 
with the VM Host and I have been running on the subscribe for about two weeks. 
I took snapshots first, then tried to do the split brain recovery, but after 
running the 12 hours.. it wasn't done so rolled back to my snapshots. It seems 
the longer I wait to recover the longer the recovery will take. Is there a way 
to promote the subscriber to be my new publisher and then add new subscriber 
for redundancy? Thanks.

?


--

Natambu Obleton
CISSP #370414 CCIE #38491
Network Architect
FastTrack Communications, Inc.
970.828.1009
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Additional historical reports available on CCO

[Abhiram Kramadhati (akramadh)]

Hi Ed,

After the upgrade, all the reports will be moved into the Stock folder and the 
SP’s will be loaded as the Informix user – who has permission over the Temp 
tables, hence you won’t have issues.

Thank you, Anthony, for confirming the same.

Regards,
Abhiram Kramadhati
Technical Solutions Manager, CCBU
CCIE Collaboration # 40065

From: Ed Leatherman >
Date: Tuesday, 12 April 2016 at 9:02 PM
To: akramadh >
Cc: Kevin Przybylowski >, 
Anthony Holloway 
>, 
Justin Steinberg >, 
"cisco-voip@puck.nether.net" 
>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi Abhiram,

Thanks for all the background info, and the heads up about SU2 (i've been 
waiting on that one for another bug fix)

Since the new reports are pre-bundled in SU2, do you foresee any problems 
applying SU2 if we've added or tried to add one or more of the new reports 
already? I am mainly thinking of SP's that have been added already.

Ed

On Mon, Apr 11, 2016 at 9:57 PM, Abhiram Kramadhati (akramadh) 
> wrote:
Hi all,

We had a quick discussion yesterday to address this and here is the summary:

  1.  CUIC currently executes the SP’s as (uccxhrc user) - this is a problem 
due to an Informix defect, corrected in the next release. Why is this a 
problem? According to Informix, for a user to delete the temp tables the user 
has to be the owner of the same. The owner of the temp table is usually 
designated to be the same as the owner of the SP – uccxhruser in our case. Now, 
since the execution is happening as uccxhrc user and the owner is uccxhruser, 
there is a conflict and hence the errors. Refreshing the CUIC datasource fixes 
this temporarily because temp tables are cleared out. The permanent fix is to 
import the SP as the uccxhrc user. Since the uccxhrc user does not have default 
privileges to create SP’s, please call into TAC and they can run the commands 
for you from the root. This is the defect CSCul06940
  2.  We have pre-bundled these reports in 10.6(1)SU2 and the same has been 
released yesterday. Since they are pre-bundled, you will not have this problem.
  3.  11.0(1) currently does not have this pre-bundled, since it was released a 
few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1), you will lose 
these reports – you will have to reimport them. So please be mindful of point 
1. Tentatively, we will pre-bundle them on SU’s on 11.0(1). So you should be 
able to upgrade to that from 10.6(1)SU2 and still have the reports.

The defect CSCul06940 will affect other custom reports as well (because of 
point1). However, in 11.5 the user uccxhrc has been deleted. That is the long 
term fix. It is an informix fix, hence the challenges to back port.

Updated release notes for the reports will be uploaded soon. Please let me know 
if you have any questions.

Regards,
Abhiram Kramadhati
Technical Solutions Manager, CCBU
CCIE Collaboration # 40065

From: cisco-voip 
> 
on behalf of akramadh >
Date: Monday, 11 April 2016 at 10:41 AM
To: Kevin Przybylowski >, 
Ed Leatherman >, Anthony 
Holloway 
>, 
Justin Steinberg >

Cc: "cisco-voip@puck.nether.net" 
>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi all,

Let me find more details on the issue you are facing. We introduced these 
reports over the last quarter and more will be available as well; and all of 
them have undergone the regular testing cycle. But let me see how best to 
address this.

[http://www.cisco.com/c/dam/assets/email-signature-tool/logo_07.png?ct=1421802598153]

Abhiram Kramadhati
Technical Solutions Manager
Customer Solutions Success team, CCBU
akram...@cisco.com
Phone: +61 2 8446 6257

CCIE Collaboration  - 40065


Cisco Systems Australia Pty Limited
The Forum
201 Pacific Highway
2065
St Leonards
Australia
Cisco.com


[http://www.cisco.com/assets/social_media_icons/linkedin-16x16.png]


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif] Think 

Re: [cisco-voip] Additional historical reports available on CCO

[Anthony Holloway]

I took my broken 10.6.(1)SU1 system, upgraded it to 10.6(1)SU2 today, and
the reports I imported are now showing up under Stock reports, and they
work.

On Mon, Apr 11, 2016 at 8:57 PM, Abhiram Kramadhati (akramadh) <
akram...@cisco.com> wrote:

> Hi all,
>
> We had a quick discussion yesterday to address this and here is the
> summary:
>
>1. CUIC currently executes the SP’s as (uccxhrc user) - this is a
>problem due to an Informix defect, corrected in the next release. Why is
>this a problem? According to Informix, for a user to delete the temp tables
>the user has to be the owner of the same. The owner of the temp table is
>usually designated to be the same as the owner of the SP – *uccxhruser*
>in our case. Now, since the execution is happening as *uccxhrc* user
>and the owner is *uccxhruser*, there is a conflict and hence the
>errors. Refreshing the CUIC datasource fixes this temporarily because temp
>tables are cleared out. The permanent fix is to import the SP as the
>*uccxhrc* user. Since the *uccxhrc* user does not have default
>privileges to create SP’s, please call into TAC and they can run the
>commands for you from the root. This is the defect CSCul06940
>2. We have pre-bundled these reports in 10.6(1)SU2 and the same has
>been released yesterday. Since they are pre-bundled, you will not have this
>problem.
>3. 11.0(1) currently does not have this pre-bundled, since it was
>released a few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1),
>you will lose these reports – you will have to reimport them. So please be
>mindful of point 1. Tentatively, we will pre-bundle them on SU’s on
>11.0(1). So you should be able to upgrade to that from 10.6(1)SU2 and still
>have the reports.
>
>
> The defect CSCul06940 will affect other custom reports as well (because of
> point1). However, in 11.5 the user *uccxhrc* has been deleted. That is
> the long term fix. It is an informix fix, hence the challenges to back
> port.
>
> Updated release notes for the reports will be uploaded soon. Please let me
> know if you have any questions.
>
> Regards,
> Abhiram Kramadhati
> Technical Solutions Manager, CCBU
> CCIE Collaboration # 40065
>
> From: cisco-voip  on behalf of
> akramadh 
> Date: Monday, 11 April 2016 at 10:41 AM
> To: Kevin Przybylowski , Ed Leatherman <
> ealeather...@gmail.com>, Anthony Holloway ,
> Justin Steinberg 
>
> Cc: "cisco-voip@puck.nether.net" 
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> Hi all,
>
> Let me find more details on the issue you are facing. We introduced these
> reports over the last quarter and more will be available as well; and all
> of them have undergone the regular testing cycle. But let me see how best
> to address this.
>
> *Abhiram Kramadhati*
> Technical Solutions Manager
> Customer Solutions Success team, CCBU
> akram...@cisco.com
> Phone: *+61 2 8446 6257 <%2B61%202%208446%206257>*
>
> CCIE Collaboration  - 40065
>
> *Cisco Systems Australia Pty Limited*
> The Forum
> 201 Pacific Highway
> 2065
> St Leonards
> Australia
> Cisco.com 
>
> 
>
> Think before you print.
>
> This email may contain confidential and privileged material for the sole
> use of the intended recipient. Any review, use, distribution or disclosure
> by others is strictly prohibited. If you are not the intended recipient (or
> authorized to receive for the recipient), please contact the sender by
> reply email and delete all copies of this message.
>
> Please click here
>  for
> Company Registration Information.
>
> From: cisco-voip  on behalf of Kevin
> Przybylowski 
> Date: Saturday, 9 April 2016 at 1:45 AM
> To: Ed Leatherman , Anthony Holloway <
> avholloway+cisco-v...@gmail.com>, Justin Steinberg 
> Cc: "cisco-voip@puck.nether.net" 
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> You also have to put together that Cisco’s official new ccx reports would
> fall under the ‘custom’ umbrella!
>
>
>
> *From:* cisco-voip [mailto:cisco-voip-boun...@puck.nether.net
> ] *On Behalf Of *Ed Leatherman
> *Sent:* Friday, April 8, 2016 11:37 AM
> *To:* Anthony Holloway ; Justin
> Steinberg 
> *Cc:* Cisco VOIP 
> *Subject:* Re: [cisco-voip] Additional historical reports available on CCO
>
>
>
> Hours ago actually lol, I never looked through 

Re: [cisco-voip] Additional historical reports available on CCO

[Ed Leatherman]

Hi Abhiram,

Thanks for all the background info, and the heads up about SU2 (i've been
waiting on that one for another bug fix)

Since the new reports are pre-bundled in SU2, do you foresee any problems
applying SU2 if we've added or tried to add one or more of the new reports
already? I am mainly thinking of SP's that have been added already.

Ed

On Mon, Apr 11, 2016 at 9:57 PM, Abhiram Kramadhati (akramadh) <
akram...@cisco.com> wrote:

> Hi all,
>
> We had a quick discussion yesterday to address this and here is the
> summary:
>
>1. CUIC currently executes the SP’s as (uccxhrc user) - this is a
>problem due to an Informix defect, corrected in the next release. Why is
>this a problem? According to Informix, for a user to delete the temp tables
>the user has to be the owner of the same. The owner of the temp table is
>usually designated to be the same as the owner of the SP – *uccxhruser*
>in our case. Now, since the execution is happening as *uccxhrc* user
>and the owner is *uccxhruser*, there is a conflict and hence the
>errors. Refreshing the CUIC datasource fixes this temporarily because temp
>tables are cleared out. The permanent fix is to import the SP as the
>*uccxhrc* user. Since the *uccxhrc* user does not have default
>privileges to create SP’s, please call into TAC and they can run the
>commands for you from the root. This is the defect CSCul06940
>2. We have pre-bundled these reports in 10.6(1)SU2 and the same has
>been released yesterday. Since they are pre-bundled, you will not have this
>problem.
>3. 11.0(1) currently does not have this pre-bundled, since it was
>released a few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1),
>you will lose these reports – you will have to reimport them. So please be
>mindful of point 1. Tentatively, we will pre-bundle them on SU’s on
>11.0(1). So you should be able to upgrade to that from 10.6(1)SU2 and still
>have the reports.
>
>
> The defect CSCul06940 will affect other custom reports as well (because of
> point1). However, in 11.5 the user *uccxhrc* has been deleted. That is
> the long term fix. It is an informix fix, hence the challenges to back
> port.
>
> Updated release notes for the reports will be uploaded soon. Please let me
> know if you have any questions.
>
> Regards,
> Abhiram Kramadhati
> Technical Solutions Manager, CCBU
> CCIE Collaboration # 40065
>
> From: cisco-voip  on behalf of
> akramadh 
> Date: Monday, 11 April 2016 at 10:41 AM
> To: Kevin Przybylowski , Ed Leatherman <
> ealeather...@gmail.com>, Anthony Holloway ,
> Justin Steinberg 
>
> Cc: "cisco-voip@puck.nether.net" 
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> Hi all,
>
> Let me find more details on the issue you are facing. We introduced these
> reports over the last quarter and more will be available as well; and all
> of them have undergone the regular testing cycle. But let me see how best
> to address this.
>
> *Abhiram Kramadhati*
> Technical Solutions Manager
> Customer Solutions Success team, CCBU
> akram...@cisco.com
> Phone: *+61 2 8446 6257 <%2B61%202%208446%206257>*
>
> CCIE Collaboration  - 40065
>
> *Cisco Systems Australia Pty Limited*
> The Forum
> 201 Pacific Highway
> 2065
> St Leonards
> Australia
> Cisco.com 
>
> 
>
> Think before you print.
>
> This email may contain confidential and privileged material for the sole
> use of the intended recipient. Any review, use, distribution or disclosure
> by others is strictly prohibited. If you are not the intended recipient (or
> authorized to receive for the recipient), please contact the sender by
> reply email and delete all copies of this message.
>
> Please click here
>  for
> Company Registration Information.
>
> From: cisco-voip  on behalf of Kevin
> Przybylowski 
> Date: Saturday, 9 April 2016 at 1:45 AM
> To: Ed Leatherman , Anthony Holloway <
> avholloway+cisco-v...@gmail.com>, Justin Steinberg 
> Cc: "cisco-voip@puck.nether.net" 
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> You also have to put together that Cisco’s official new ccx reports would
> fall under the ‘custom’ umbrella!
>
>
>
> *From:* cisco-voip [mailto:cisco-voip-boun...@puck.nether.net
> ] *On Behalf Of *Ed Leatherman
> *Sent:* Friday, April 8, 2016 11:37 AM
> *To:* Anthony Holloway ; Justin
> Steinberg