Failover Wizard fails on backup server (rel 4.0(4)SR1)

[jshapura]

Recently we rebuilt our Unity environment to use Active Directory and Exchange 2003/Exchange 5.5 (mixed mode). We have a single server running in non-failover mode that is working with no problems, clean database, etc. We built the failover server per the 4.0(4) install instructions and then ran the failover wizard on both the primary and new failover machines. The failover wizard appeared to run with no problems on the primary machine; however when we ran the wizard on the new failover machine we got the following error message during the 'Configuring SQL Replication' step:

Failed to configure SQL replication for Cisco Unity failover - 0x80043708

The wizard had the message 'Creating replication article for conflict_UnityDBPublication_Handler' showing when the failure message occurred.

We confirmed that the IDs we are using for the failover process are the same on both machines and have the required access (can run as part of the operating system, have local admin ability and can run services).

Are there any logs created by the Failover Wizard that would give us more detail as to what is occurring? Anyone else run into this? Thanks in advance for your help.

[jshapura]

Found the Failover wizard logs - heres the error messages we see when running the wizard on the failover server:

FailoverConfig,10,Creating the SQL articles for 'UnityDbPublication'

FailoverConfig,10,Error [0x80043708] : [Microsoft][ODBC SQL Server Driver][SQL Server]The table '[dbo].[conflict_UnityDbPublication_Handler]' must have a primary key to be published using the transaction-based method.

FailoverConfig,10,Creating the SQL trans subscription 'UNITYCHIBK'

18:05:35:894,AvDiagnostics_MC,642,1580,-1,,FailoverConfig,10,Error [0x800436ba] : [Microsoft][ODBC SQL Server Driver][SQL Server]The remote server is not defined as a subscription server.

Any ideas? As mentioned earlier, the IDs we are using for Failover Wizard have all of the required access as listed in the documentation, and the wizard ran with no problems on the primary server.

[jeff.singh_2]

Hi, did you get a resolution to this - I've got a similar problem at the same stage 'cannot delete duplicate default unity objects'.

thanks

Jeff

[jshapura]

Yes we did. As mentioned we saw in the failover wizard log that we were failing on the table 'conflict_UnityDbPublication_Handler' not having a primary key. We deleted the table in question (per level 2 TAC) and reran FCW, and everything worked correctly.

[maratimer_2]

When I run failover on the secondary server, it is failing during the last part SQL Replication. The error in the log file is:

Error [0x80044833] : [Microsoft][ODBC SQL Server Driver][SQL Server]Could not connect to server 'USMDLSTAGEUM1' because 'distributor_admin' is not defined as a remote login at the server.

Does anyone know how to resolve this? Thanks.