EV 11 Upgrade- EVDatabaseUpgrader failed
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].
Tried to re-add an EV server into ev site
Hi Long story short: I'm installing a brand new EV 12 solution consisting of 2 x EV servers and EV SQL server - all vms running Windows 2012 r2. I installed and configured both servers into a new EVsite and created all the archive and index locations, ALL firewalls are OFF and everything was looking good. Then patched both servers to EV12.0.1 Before I got as far as adding any targets I noticed that I had installed the EV binaries onto the wrong volume for one of the EV servers. I wanted to install it on the D:\ but had left the default c:\ location without realising. It all worked fine but being a bit OCD I decided to remove the EV server from the site and reinstall on the correct volume. Did this by following the tech note on removing an EV server from an EV site and this worked fine - I removed all tasks (there weren't any), index locations, partitions, vault stores and finally the EV server itself. The remaining EV server is fine and not showing any errors. I then went into Add and Remove programs and unistalled EV itself from the server. This went smoothly and also uninstalled the patch - it didn't ask me to, but I rebooted the server and then manually deleted the Enterprise Vault folder that was still on the C:\ drive. I did a reinstall (this time making sure I selected the correct volume) and proceeded to run the EV configuration to add the server to the existing EV site. This failed with the ) "Failed to read sites for organization" error when I entered in the EV alias of the remaining EV server. I also get these DCOM errors: DCOM got error "2147942405" from the computer EVSERVER01 when attempting to activate the server: The application-specific permission settings do not grant Remote Launch permission for the COM Server application with CLSID {F4D3EB5B-C7C5-11D1-90DB-0000F879BE6A} and APPID {95DCB63F-C982-11D1-90E0-0000F879BE6A} to the user MyDomain\svc_evservice SID (S-1-5-21-1454471165-2049760794-839522115-22560) from address 10.10.10.10 running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool. Just to confirm - ALL FIREWALLS ARE OFF - but I'm not sure what I could have done to suddenly create this error. This is yet to go into production and it's only about 1Hrs work to delete the EV site entirely and re-install EV on both servers. So probably won't spend too long on this. I did try adding the 12.0.1 patch to the server but this still gave the same error However, a little bit mindful that the above error looks like an OS issue and so deleting the EVsite entirely and starting again should work, but not 100% certain and even though it's not a big job for me to start again someone might have had this before and can guide me to a 10 mins fix. So I thought I'd just through it out there to you kindly people :o) Also - there might come a day when I need to do this in a full production system so also keen to know if there is a more convenient fix than a rebuild :o) many thanks PS - couple of other things perhaps ot note: Previously the server that I'm re-installing was the server I first built and therefore the one that I initially used to create the EV site - perhaps this means that something in SQL remains pointing to this server name\alias? This server also has EV DA installed on it which I did not uninstall as part of this rebuild activity - as I couldn't see how it would help,
Exchange 2016 OWA support for accessing archived items
Hi everyone, I have some customers moving to Exchange 2016 and are looking to upgrade EV and need the access to archived items via OWA. I see that the EV Office Mail App still isn't supported with Exchange 2016 as of July 14, 2016 as per the latest compatibility charts. Anyone know where I can find out when it will be supported (or at least get an estimate that I can relay to our customer)? Any advice is appreciated! Thanks DanEnterprise Vault Podcast
Yes - that's right....a Podcast about Enterprise Vault. Perhaps it's surprising we've not thought do do these before but this is hopefully the first of many. It's a nice bite size way to consume information on the go, yes you can now listen and learn about EV whilst on the go, whether that's on the train, on your bike or even on a lunch time run. This first Podcast is about EV SMTP archiving, listen to Dan Strydom talk about why it's such a useful addition to your archiving armory and get a better understanding about what it can do. All done in 10 minutes. There's various ways to consume the podcast - with iTunes this is as easy as feeding in the URL as shown below, of course other Podcast clients are available and you can use the link as needed for those. Open iTunes Click File > Subscribe to Podcast… Enter this url https://veritas.box.com/shared/static/hnpy22299b58qo2b6l3s00x7wljo60kd.xml Hope you all enjoy this, please let us know if you'd like more topics covered, obviously once you've subscribed you'll automatically see any new ones as they're made available, but it would be good to get your input. Enjoy.Enterprise Vault FSA task
Hi I have an EV11.0.1 environment thatis used for File System Archiving. It's a new deployment and has a large backlog of file to churn through. The task runs for several hours each night and I;ve been reviewing the logs over the last couple of weeks. My understanding was that EV creates a checkpoint file so it can continue where it left off the following night, but I'm finding that this isn;t the case. If I import the all FSA reports into Excel (one report per worksheet) and the select a file from the first day's report I can successfully find the same file has been processed on another day (eg the same file appears in more several reports and some files are evident in every report since the FSA task has been enabled. If EV has yet to churn through the entire volume (it's multiple TB's in size) how can the same file be processed every day? Is there perhaps something wrong with the checkpoint file? Or am I perhaps misunderstanding the reports? thanks
