MRB6754
3 years agoLevel 2
Database Upgrade problem when updating EV 14.2.1 to 14.2.2
When executing the Start-EVDatabaseUpgrade script after upgrading from 14.2.1 to 14.2.2 we are getting the following error message. Obviously, the StoreIdentifier column is missing in MemberTable_000.
Any idea how to fix that issue?
PS C:\Program Files (x86)\Enterprise Vault> Start-EVDatabaseUpgrade
[14:26] Loading configuration.
[14:26] Checking user permissions.
[14:26] Permissions OK.
[14:26] Database 'Directory' on server 'mrsql01.MRBau.local': The database is up to date. The version is '14.30.5.411.0'.
[14:26] Database 'Upgrader (EnterpriseVaultDirectory)' on server 'mrsql01.MRBau.local': The database is up to date. The version is '12.0.14.0.0'.
[14:26] Database 'Upgrader (EnterpriseVaultDirectory)' on server 'mrsql01.MRBau.local': The database is up to date. The version is '12.0.14.0.0'.
[14:26] Database 'Directory' on server 'mrsql01.MRBau.local': The database is up to date. The version is '14.30.5.411.0'.
[14:26] Database 'EnterpriseVaultMonitoring' on server 'mrsql01': The database is up to date. The version is '12.3.0.9.0'.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': The database needs to be upgraded from '12.8.3.12.0' to '12.8.3.12.4'.
[14:26] Database 'EVStore1' on server 'mrsql01': The database is up to date. The version is '14.0.15.200.4'.
[14:26] Upgrade started.
[14:26] Starting upgrade.
[14:26] Database 'Directory' on server 'mrsql01.MRBau.local': The database is up to date. The version is '14.30.5.411.0'.
[14:26] Database 'EnterpriseVaultMonitoring' on server 'mrsql01': The database is up to date. The version is '12.3.0.9.0'.
[14:26] Database 'EVStore1' on server 'mrsql01': The database is up to date. The version is '14.0.15.200.4'.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Checking permissions on database.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Checking that database version is compatible.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Checking current connection.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Upgrade started.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Running script CommonDB_Utils.sql.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Script 'CommonDB_Utils.sql' completed.
[14:26] Database 'VaultStoreGroup1_2' on server 'mrsql01': Running script FingerprintDB_ApplyPatch.sql.
Start-EVDatabaseUpgrade : Fehler bei ALTER TABLE ALTER COLUMN, da die "StoreIdentifier"-Spalte in der MemberTable_000-Tabelle nicht vorhanden ist.
Database upgrader has encountered an unrecoverable SQL fault while upgrading the database. If you cannot solve this issue, contact your support representative.
In Zeile:1 Zeichen:1
+ Start-EVDatabaseUpgrade
+ ~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (EVVSGVaultStoreGroup1_2_2:String) [Start-EVDatabaseUpgrade], UpgraderException
+ FullyQualifiedErrorId : UnknownError,Symantec.EnterpriseVault.Database.DBUpgraderPowerShell.PSUpgraderLog
[14:26] Upgrade completed with errors.
[14:26] Database upgrader stopped.
WARNUNG: Some databases could not be upgraded:
EnterpriseVaultDirectory: The database is up to date. The version is '14.30.5.411.0'.
EnterpriseVaultMonitoring: The database is up to date. The version is '12.3.0.9.0'.
EVVSGVaultStoreGroup1_2_2: Could not be upgraded. Database remains on version'12.8.3.12.0'. Fehler bei ALTER TABLE ALTER COLUMN, da die "StoreIdentifier"-Spalte in der MemberTable_
000-Tabelle nicht vorhanden ist.
EVVSEVStore1_2: The database is up to date. The version is '14.0.15.200.4'.
PS C:\Program Files (x86)\Enterprise Vault>
Hi,
Engineering has identified an issue with one of the checks during the upgrade. This is being corrected and an update should be available within a day or two.
Regards,
Patrick