EV11CHF1 - EVDatabaseUpgraded fails

[GertjanA]

See http://www.symantec.com/docs/TECH228970

Error you will see is :

Cannot insert the value NULL into column 'MbxIdentity', table 'EnterpriseVaultDirectory.dbo.PstMigrationHistory'

To 'workaround' perform following:

Run the query in the KB-article. If the number is not 0, run the below:

USE EnterpriseVaultDirectory
Select PSTMigrationHistoryEntryId FROM PSTMigrationHistory
WHERE ExchangeMailboxEntryId NOT IN (SELECT ExchangeMailboxEntryId FROM
ExchangeMailboxEntry)

Then delete the rows with the PSTMigrationHistoryEntryID fond above:

Delete from PSTMigrationHistory where PSTMigrationHistoryEntryID = 'value found in query above'

This might not be the official solution, but it works for us. For the upgrades to come, we run the query from the KB-article, and fix when the number returned is not 0.

[JesusWept3 · Accepted solution]

The official solution is after you upgrade and before you run the Database Upgrade utility, find the following file in your install directory: DirectoryDB_11_SchemaUpdates.sql

Change this line from:
EXEC Util_AddColumn  @TableName='PstMigrationHistory', @ColumnName='MbxIdentity', @Type='int', @Nullable=1

To:
EXEC Util_AddColumn  @TableName='PstMigrationHistory', @ColumnName='MbxIdentity', @Type='int', @Nullable=1, @Default=-1

That way if the mailbox has gone, you still get to keep your PST Migration records, which for some customers are critical.