EV11CHF1 - EVDatabaseUpgraded fails
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.
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=1To:
EXEC Util_AddColumn @TableName='PstMigrationHistory', @ColumnName='MbxIdentity', @Type='int', @Nullable=1, @Default=-1That way if the mailbox has gone, you still get to keep your PST Migration records, which for some customers are critical.
