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

Sun Sep 21 09:32:13 EDT 2008

Pat,

ran the query..... Turns out the server was indeed renamed !"£$!"£%)@#!

Thanks again for the link - not sure why I couldn't find anything myself on CCO (nor tac/htts)

Thank you soooo much :)
T

PS: note to self, do more homework on SQL

> -----Original Message-----
> From: pat at wcyv.com [mailto:pat at wcyv.com] On Behalf Of Pat Hayes
> Sent: Saturday, September 20, 2008 8:11 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
> 
> The SQL replication is two way, that's how (among other 
> things) you can add new users when active on the failover, 
> and have it show up on the primary when you fail back. That's 
> why you saw the same problems in the location tables on both servers.
> 
> I'm assuming that since you keep mentioning 
> sp_subscription_cleanup and the queue reader that you're 
> getting the ole'
> 
> "ODBC Error:Could not change the Publisher because the 
> subscription has been dropped. Use sp_subscription_cleanup to 
> clean up the triggers."
> 
> from the queue reader? If so, most likely cause is that one 
> of the server's hostnames was changed after SQL was 
> installed. Compare the output from the 'hostname' command to 
> running the SQL query 'select @@servername' on each server. 
> If they don't match, see the workaround
> for:
> 
> http://www.cisco.com/en/US/products/sw/voicesw/ps2237/products
> _tech_note09186a0080837de4.shtml#k2
> 
> Note that one way or another, you're probably going to end up 
> needing to re-run the failover config wizard, which does 
> involve a brief service outage.
> 
> On Sat, Sep 20, 2008 at 2:48 PM,  
> <Thorsten.Mayr at barclayscapital.com> wrote:
> > 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.
> > _______________________________________________
> >
> 
_______________________________________________

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