The issue I encountered was during the import process when the wizard was performing schema version validation checks against the Enterprise Vault databases. In my scenario the wizard was failing on the validation of the <\/span>EnterpriseVaultAudit<\/em><\/strong> <\/span>database. Just a tad annoying as the wizard will not allow you to continue the import process until you fix the issue.<\/p>\n So, what is the problem? The wizard has these checks in place to mitigate the risk of an unsuccessful or unsupported upgrade from occurring. Well in my case I needed to somehow by-pass this check as the <\/span>EnterpriseVaultAudit<\/em><\/strong> <\/span>database schema version was at version <\/span>3<\/strong> <\/span>which is the <\/span>correct<\/strong> <\/span>level for EV 11.0.1 CH5.<\/p>\n IMPORTANT: <\/span><\/strong>I cannot stress this enough. Do not attempt to perform the \u201chackery\u201d outlined in this blog unless you:<\/p>\n So, how to verify the schema level of your Enterprise Vault databases? Easy, run the following SQL Queries:<\/p>\n For the EV Directory database schema version run the following:<\/p>\n USE <\/span>EnterpriseVaultDirectory <\/span><\/p>\n SELECT<\/span> SchemaVersion <\/span> For the EV VaultStore database schema version run the following:<\/p>\n USE <\/span> <\/span>EnterpriseVaultDirectory<\/span><\/p>\n SELECT <\/span>SchemaVersion <\/span> For the EV Fingerprint database schema version run the following:<\/p>\n USE <\/span>EnterpriseVaultDirectory <\/span><\/p>\n SELECT<\/span> SchemaVersion <\/span> For the EV FSAReportingDatabase schema version run the following:<\/p>\n USE <\/span>EnterpriseVaultDirectory <\/span><\/p>\n SELECT <\/span>SchemaVersion <\/span> For the EV Monitoring database schema version run the following:<\/p>\n USE <\/span>EnterpriseVaultDirectory<\/span><\/p>\n SELECT<\/span> SchemaVersion<\/span> For the EV Audit database schema version run the following:<\/p>\n USE <\/span>EnterpriseVaultAudit<\/span><\/p>\n SELECT <\/span>SchemaVersion<\/span> Once you\u2019ve obtained the schema version for all the EV databases, cross-reference your results using the tables found in the following Veritas Technote <\/span>article<\/a>.<\/p>\n So now, let the hackery begin\u2026<\/p>\n Contained within the installation folder of the Enterprise Vault Server Settings Migration Wizard is an XML file named <\/span>ServerMigration.exe.config<\/em><\/strong>. In this file you will see a bunch of keys you can use to override certain checks performed by the wizard during the import process. For example:<\/p>\n To override all the EV database schema checks, you would add the following key in the <\/span><appSettings><\/strong>section of the ServerMigration.exe.config XML file:<\/p>\n <add key=\u201dOverrideDatabaseSchemaChecks\u201d value=\u201dtrue\u201d\/><\/em><\/strong><\/p>\n If you needed to override the EV version check, you would add:<\/p>\n <add key=\u201dOverrideEVVersionCheck\u201d value=\u201dtrue\u201d\/><\/em><\/strong><\/p>\n Lastly, to override the Operating System version check, you would add:<\/p>\n <add key=\u201dOverrideOperatingSystemCheck\u201d value=\u201dtrue\u201d\/><\/em><\/strong><\/p>\n Now, I imagine you would need to be in a fairly desperate situation if you needed to by-pass <\/span>all<\/strong> <\/span>EV database schema checks, the EV version check or OS version check. I definitely wouldn\u2019t do it unless I had no other choice and had the full blessing of Veritas Technical Support as misuse of these keys could potentially place your EV environment in an unstable and unsupported state.<\/p>\n The less riskier approach is to override an individual EV database schema check which is what I needed to do during my upgrade. The key I needed to add was:<\/p>\n <add key=\u201dAcceptedAuditSchemaVersions\u201d value=\u201d<\/em><\/strong>3\u2033\/><\/em><\/strong><\/p>\n Now for the moment of truth. Go ahead and restart the Enterprise Vault Server Settings Migration Wizard in import mode and follow the bouncing ball. There you go. You\u2019re back on track with your EV migration and upgrade. Happy days.<\/p>\n\n\n I recently came across an unexpected issue when performing a migration and upgrade from EV 11.0.1 to a newly built EV 12.2 server on Windows 2012 R2 using the Enterprise Vault 12.3 Server Settings Migration Wizard. Now, I\u2019m not going to talk about the step-by-step process to migrate and upgrade Enterprise Vault using the Server… Continue reading Enterprise Vault Server Settings Migration Wizard \u2013 A Handy Tip You Didn\u2019t Know\u2026<\/span><\/a><\/p>\n","protected":false},"author":89,"featured_media":1912,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[22],"tags":[],"class_list":["post-1911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-migrations","entry"],"_links":{"self":[{"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/posts\/1911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/users\/89"}],"replies":[{"embeddable":true,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/comments?post=1911"}],"version-history":[{"count":1,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/posts\/1911\/revisions"}],"predecessor-version":[{"id":11030,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/posts\/1911\/revisions\/11030"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/media\/1912"}],"wp:attachment":[{"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/media?parent=1911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/categories?post=1911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.insentragroup.com\/nz\/wp-json\/wp\/v2\/tags?post=1911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
FROM<\/span> DirectoryEntry<\/span><\/p>\n
FROM <\/span>VaultStoreEntry<\/span><\/p>\n
FROM <\/span> FingerPrintCatalogueDatabase<\/span><\/p>\n
FROM <\/span>FSAReportingDatabase<\/span><\/p>\n
FROM <\/span> MonitoringSettings<\/span><\/p>\n
FROM <\/span>Audit<\/span><\/p>\n![\"\"](\"https:\/\/www.insentragroup.com\/nz\/wp-content\/uploads\/sites\/18\/2022\/08\/email_archive_migration_banner_2022.png\")
<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"