EV 11 Upgrade- EVDatabaseUpgrader failed

[Chris_Burke]

Has anyone had an issue with the EVDatabaseUpgrader failing? I am going from 10.4 to 11 and ran the EVDatabaseUpgrader and recieved an event id 41533

• event output is below
• The Full log file is attached

EVDatabaseUpgrader failed.

Failed to upgrade Directory database. Database:[EnterpriseVaultDirectory] .

Failed to execute command. Script: [D:\Program Files (x86)\Enterprise Vault\DirectoryDB_11_Migrate.sql] Line: [163] Command: [/*****************************

-- Update the Statistics in PstComputer and PstExchangeMailboxAggregate table by looking up PstFile table.

-- We need this to be done when Upgrade happenes. This includes following steps...

-- 1.  Check if any record exist in the Mailbox Aggregate table. We expect some record in this table if following SQL was run sometime in past.

-- 2.  We do not want to run the following SQL in build-to-build upgrade. It should run just once in a lifetime.

-- 3.  Calculate the PstComputer stats by looking up the PstFile table and update the PstComputer table.

-- 4.  Calculate the PstExchangeMailboxAggregate stats by looking up the PstFile table and insert fresh records in PstExchangeMailboxAggregate table.

************** Start **********/

-- STEP 1: Check if any record exist in the Mailbox Aggregate table. We expect some record in this table if following SQL was run sometime in past.

IF NOT EXISTS (SELECT TOP (1) 1 FROM PstExchangeMailboxAggregate)

BEGIN

                -- STEP 2: Calculate the stats by looking up the PstFile table and update the PstComputer table.

                UPDATE PSTComputer

                SET AllPSTsCount = p.TotalFileCount,

                                MigrationCompletedPSTsCount = p.SuccessFileCount,

                                MigrationFailedPSTsCount = p.FailedFileCount,

                                AllPSTsFileSize = p.TotalFileSize

                FROM

                (SELECT

                                PstFile.PstComputerIdentity PID,

                                COUNT(1) AS TotalFileCount,                                                                                                                                                                                             -- Total file count associated with a computer

                                SUM(FileSize) AS TotalFileSize,                                                                                                                                                                           -- Total file size associated with a computer

                                COUNT(CASE MigrationStatus WHEN 1000 THEN 1 END) AS FailedFileCount,          -- Migration failed file count associated with a computer

                                COUNT(CASE MigrationStatus WHEN 1400 THEN 1 END) AS SuccessFileCount       -- Migration successful file count associated with a computer

                                FROM PstFile

                                JOIN PstComputer ON PstComputer.PstComputerIdentity = PstFile.PstComputerIdentity

                                GROUP BY PstFile.PstComputerIdentity) as P

                WHERE PstComputer.PstComputerIdentity = P.PID

                -- STEP 3: Calculate the PstExchangeMailboxAggregate stats by looking up the PstFile table and insert fresh records in PstExchangeMailboxAggregate table.

                INSERT INTO PstExchangeMailboxAggregate

                SELECT

                                ex.MbxIdentity,

                                COUNT(1) AS TotalFileCount,                                                                                                                                                                                                                             -- Total file count associated with a mailbox

                                COUNT(CASE MigrationStatus WHEN 1400 THEN 1 END) AS SuccessFileCount,                                      -- Migration successful file count associated with a mailbox

                                COUNT(CASE MigrationStatus WHEN 1000 THEN 1 END) AS FailedFileCount,                                          -- Migration failed file count associated with a mailbox

                                SUM(CASE MigrationStatus WHEN 1400 THEN FileSize ELSE 0 END) AS SuccessFileSize,-- Migration successful file size associated with a mailbox

                                SUM(FileSize) AS TotalFileSize                                                                                                                                                                                                            -- Total file size associated with a mailbox

                                FROM PstFile

                                JOIN ExchangeMailboxEntry ex ON ex.MbxIdentity = PstFile.MbxIdentity

                                GROUP BY ex.MbxIdentity            

END].

[JimmyNeutron]

I had the same issue this past weekend and this technote helped get past the issue. 

https://www.veritas.com/support/en_US/article.000024824