Core Issue
When running the Cisco Unity failover configuration wizard in Cisco Unity 4.0(4), the user receives this error message:
The SQL snapshot agent failed to complete in a reasonable amount of time. As a result, the Cisco Unity Failover will not work properly. Disable all Cisco Unity replication using the SQL Enterprise Manager and run this wizard again.
The user may also receive Structured Query Language (SQL) replication errors in Enterprise Manager such as this:
"The process could not bulk copy out of table '[dbo].syncobj_xxx]"
"Details: Invalid time format (Source: ODBC SQL Server Driver (ODBC);
Error number: 0)
Resolution
This is a defect which results from negative values in the Last Modified column of the configuration table. The workaround for the defect is to change the fields to NULL with this command from command line:
osql -E -d UnityDb -Q "update Configuration set LastModifiedTime=NULL"
After you have done this, re-run the Cisco Unity failover configuration wizard.
For more information on the defect, refer to Cisco bug ID CSCef60341 - Unitydb SQL Configuration table lastmodifiedtime value is negative.
Unity Version
Unity 4.x