Cisco Unity Failover Wizard Fails

[mwcodd]

Anyone any ideas on this one.

I have a cisco unity voicemail only solution with failover with the secondary hosting AD and Exchange 2003.

The same error has occurred twice after a total rebuild.

Scenario

Both servers build ok with identical features and drive locations.

UTIM runs succesfully on both servers.

Failover wizard runs succesfully on the Primary

Failover wizard fails on the secondary

Failed to verify SQL Configuration Table

Detailed information

Method Iavrdbconnection::Execute(KYNUDCSVM002,CSP_ConfigurationCleanupLastModifiedTime) returned [0x80040e37]

CCO is not much help, there are a few things in the general area which are all known bugs with SQL workarounds but not my specific one.

Google comes up with a few 0x80040e37 errors which are related to AD and Exchange which point to the following registry keys missing, but I don't want to go mucking about with that without cisco intervention.

[HKEY_CLASSES_ROOT\LDAPNamespace\Clsid]

@="{228D9A82-C302-11cf-9AA4-00AA004A5691}"

[HKEY_CLASSES_ROOT\LDAP\Clsid]

@="{228D9A81-C302-11cf-9AA4-00AA004A5691}"

I have attached the Failover config log file from both servers

Cheers

Martin

[pjweppner]

Sound like this bug CSCsi64012

http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCsi64012

ES95 fixes it or copy the failoverconfigwizard.exe from Unity 5.0 disk. Are you running Unity 4.2?

[mwcodd]

Hi

Thanks for your response, I am actually running Unity 5.0, so have the latest wizard. I did look at that bug, and it is similar but not the same.

Martin

[pjweppner]

And you're running the same build or later of 5.x as indicated in the bug notes? Run the Gather Unity System Info (GUSI) to verify. It sounds bug related to occur twice after a rebuild.

[mwcodd]

i'm running 5.0(1.0) so shouldn't be seeing that bug. I agree it is probaly bug related, possibly a new one?

[Trent Hurt]

We recently upgraded to Unity 5 and had same problem with the failover wizard not completing on the backup server. We opened a TAC case and the engineer was able to fix with these steps.

1. The engineer added entries for the primary and failover servers to the hosts and LmHosts files on both servers.

2. He then created a unique account for the MSSQLSERVER service and the SQLSERVERAGENT to log on as. He stated that this was just his personal preference. Doing this will stop and start Unity services. (Needs to be member of domain users and also a member of local admins group)

3. He then went into SQL enterprise manager and deleted all SQL server registrations, and then created new SQL server registrations and picked the primary server and then added another for the backup server. He did this on both servers.

4. He then reran the wizard on both servers successfully.

Hope this helps

[mwcodd]

Thanks

Just tried that and still no joy. Were you getting exactly the same error as me or just a general replication error

[Trent Hurt]

This was the error I was getting.

MethodIAvRdbConnection::Initilize(secondaryserver)returned [0x80048807]

I would open a Tac case. Sorry that couldn't be more help.

[Tommer Catlin]

It's actually a 4.x problem also. I ran into this the other week. You have to change around the named pipes in the SQL manager, then it starts to work go through the Failover WIzard.

http://www.cisco.com/en/US/docs/voice_ip_comm/unity/41/release/notes/cu411rn.html

Check this link out.

cheers

[cuevas]

I followed all the steps in that Link, and I'm still getting the same errors. Anything else??!!

[cuevas]

Hey Martin,

I'm getting the same exact error, the only difference is the Server names.

I'm running Unity 5.0.1 ES30.

The FCW runs fine on the Primary Server, but on the Secondary Server it fails, and now i can't start Unity Services on the Secondary Server.

[dandrools]

I have run into the exact same problem on a Unity 4.0(3) to Unity 5.0(1) upgrade I am working on. Doing everything in the lab first and this is happening with every attempt.

I have followed the above procedures to try to fix the problem, and have even made the point to do them before ever attempting to run the failover wizard and am still running into it.

Has anyone with this problem had luck getting past it?

[rwilkinson]

Hi,

I exactly the same problem with Unity 5.0.1:-

Failed to verify SQL Confuration table.

DETAILED INFORMATION:

MethodIAvRdbConnection::Execute(LONLDCCCMU02, csp_ConfiurationCleanupLastModifedTime) returned [0x80040e37]:

I logged a support call and they said it was related to Bug ID 'CSCef60341'. Here is how I worked around this issue.

On the primary server open a 'cmd' prompt and execute the following command:

osql -E -d UnityDb -Q "update Configuration set LastModifiedTime=NULL"

Then, Re-run the FailoverConfig wizard on the primary server.

Then, Re-run the FailoverConfig wizard on the Secondary server.

This sequence of events gave me a successful failover configuration on Unity 5.0.1 after 3 days of getting the same error.

[smithsera1]

super solution, i came across the same problem and issued the command above and the wizard completed on secondary server with no problems.

Cheers

Paul

[Tommer Catlin]

Not sure if the cmd paste worked for me, but I used it anyways. Another 5.x failover not working.

Ran the fix, but then replication was not working. Turns out the Unity DBs in SQL have to be in the exact same location also or it will not work. bah!