After going through a 19-hour session of anguish in getting 4.0(5) upgraded to 5.0(1), I thought I'd share the particular solution in my case. After four failures - each occurring at the very end of the upgrade process, the TAC case was requeued to a very talented TAC engineer named Vladimir. After reviewing the log files I sent, via WebEx he went to Enterprise Manager - Management - SQL Server Agent - Jobs - and saw that SQLNightlyBackupJob showed a failed icon. Then he went to the Commserver directory and renamed UnityDb.bak (which had a Last Updated time stamp over three years old) to UnityDb.bak.old. Next he started SQLServerAgent service, and manually ran the SQLNightlyBackup job, which recreated a fresh UnityDb.bak. The upgrade was started via CUICA for the fifth time, and this time it worked.
Looking back now, knowing the source of the problem, I found clues in two places: In each failure the THIRD-to-the-last OqlDump file - NOT the last one - shows these messages:
The backup data in 'UnityDbDump' is incorrectly formatted. Backups
cannot be appended, but existing backup sets may still be usable.
Msg 3013, Level 16, State 1, Server zzzzzzz, Line 4
BACKUP DATABASE is terminating abnormally.
This particular OsqlDump log has "Running UnitydbEx.sql" as its first line.
Also, the Windows Application log has the following two entries:
3041 :BACKUP failed to complete the command
IF EXISTS(select * from master.dbo.sysdevices where name = 'UnityDbDump')
BACKUP DATABASE UnityDb TO UnityDbDump WITH DESCRIPTION='First Backup, UnityDb', INIT
Cisco Unity Setup encountered an error while running configuration SQL script 'C:\CommServer\Localize\DefaultConfiguration\ENU\UnityDbEx.sql' [Error 0x80004005]
Finally, for any Unity Product Manager reading this - - For a product so well documented and supported, these failures with a generic message are a real anomaly. The causes documented on NetPro could easily be overcome within the upgrade process via scripting.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...