[cisco-voip] Unity 4.2 missing default location for license in unitydb on failover

Sat Sep 20 14:48:00 EDT 2008

Thanks Pat,
unfortunately for the was nothing in the location table at all - just
blank!?.... I didn't check in the registry (didn't know it was there -
could have searched for it but brain was fried already it seems).

I did a rebuild of the database (advised by HTTS). Ended up redoing the
integration as well for some reason... (!?)
Now the really interesting thing is, that afterwards the ID in the
global location table in the SQL database on the primary server got
screwed! So had to copy and paste the id from the location table into
the global location table which fixed (credits go to HTTS again - thx
guys).

I am still seeing errors on the  queue reader - but I won't do another
type of 
[exec sp_subscription_cleanup @publisher =
"<primary-servername", at publisher_db = "UnityDb", @publication =
"unityDbPublication"]
Until HTTS confirms a million times that it won't screw the secondary
over again (despite the fact that this time we will have the right
entries to quickly fix it if needed)

I have no idea though how the ID for the primary got screwed over when
the failover partner came online (online as in replication SQL) - the
SQL replication is one way...

Anyway, so far so good - I can failover and even MWI is working
instantly now after the failover ;)

Thanks for your 2cents, I'll remember this one for sure ;) If wanted I
can post if the second attempt of the sp_subscription_cleanup worked.
Even though I can call it doesn't show up when searching for it under
the stored procedures (!?)

Cheers
Thorsten

> -----Original Message-----
> From: pat at wcyv.com [mailto:pat at wcyv.com] On Behalf Of Pat Hayes
> Sent: Saturday, September 20, 2008 7:38 PM
> To: Mayr, Thorsten: IT (LDN)
> Cc: cisco-voip at puck.nether.net
> Subject: Re: [cisco-voip] Unity 4.2 missing default location 
> for license in unitydb on failover
> 
> Check the Locations table in SQL, verify whether there is a 
> row in there with an alias of 'default'. Assuming there is, 
> you likely just need to fix the value for that row's 'Uid'. 
> It should be set to 'default' followed by the system id. The 
> system id can be found in the registry from:
> 
> HKLM\Software\Active Voice\Doh\1.0\System ID
> 
> Be sure to use the hex version, not the decimal. For example, 
> my lab server's system id is 380f2c89, so the Uid is 
> 'default380f2c89'. You may also need to make the same change 
> in the GlobalLocation table. If you have multiple unity 
> servers in your AD, you'll need to note the LocationObjectId 
> from the location table to know which is the correct row to 
> update in the GlobalLocation table.
> 
> On Sat, Sep 20, 2008 at 12:14 PM,  
> <Thorsten.Mayr at barclayscapital.com> wrote:
> > To keep it short.. On a failover server where Unity won't start any 
> > more
> >
> > Application log errors:
> >
> > Error:
> > (Unexpected result in CAvLic::QueryS. 0x800a0bcd Either BOF 
> or EOF is 
> > True, or the current record has been deleted. Requested operation 
> > requires a current record)
> >
> > Error:
> > Media component (Miu) initialize failed. Unable to read 
> data from the 
> > license server.  To troubleshoot this problem, open the Cisco Unity 
> > Licensing snap-in and examine the alerts. (internal failure 
> > code=0x8004330f).
> >
> > Error:
> > AvCsMgr: Component Miu initialize failed.  Turn on diagnostics for 
> > component Miu to troubleshoot.  Technical Details:
> > IAvCsComponent::Initialize failed with error [0x8004330F; ??]
> >
> > Error:
> > AvCsMgr service failed to initialize the component manager.
> >
> >
> > When I follow the suggestions from the lic manager and do:
> >
> > exec sp_finddefaultlocation the results is empty .... 
> (state / dtmf...
> > Etc.. No values)
> >
> >
> > Any idea on how to fix it apart from reinstalling Unity?
> > No backup of the database on the failover box unfortunately.
> >
> > Thanks
> > T
> > _______________________________________________
> >
> > This e-mail may contain information that is confidential, 
> privileged 
> > or otherwise protected from disclosure. If you are not an intended 
> > recipient of this e-mail, do not duplicate or redistribute 
> it by any 
> > means. Please delete it and any attachments and notify the 
> sender that 
> > you have received it in error. Unless specifically indicated, this 
> > e-mail is not an offer to buy or sell or a solicitation to 
> buy or sell 
> > any securities, investment products or other financial product or 
> > service, an official confirmation of any transaction, or an 
> official 
> > statement of Barclays. Any views or opinions presented are solely 
> > those of the author and do not necessarily represent those of 
> > Barclays. This e-mail is subject to terms available at the 
> following 
> > link: www.barcap.com/emaildisclaimer. By messaging with 
> Barclays you 
> > consent to the foregoing.  Barclays Capital is the 
> investment banking 
> > division of Barclays Bank PLC, a company registered in 
> England (number 
> > 1026167) with its registered off
>  i!
> >  ce at 1 Churchill Place, London, E14 5HP.  This email may 
> relate to or be sent from other members of the Barclays Group.
> > _______________________________________________
> > _______________________________________________
> > cisco-voip mailing list
> > cisco-voip at puck.nether.net
> > https://puck.nether.net/mailman/listinfo/cisco-voip
> >
> 
_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________