EV 2007 to 8.0 upgrade and the SQL Collation error

This issue has been solved. See solution.
Erick Magnuson's picture

I'm upgrading from Enterprise Vault 2007 to 8.0.  When I run the deployment scanner I get a SQL Collation error on my VaultDirectory database.

I've seen http://seer.entsupport.symantec.com/docs/293475.htm as the method for fixing this.  However, I think that the method outlined in that article is a little overboard consider what's actually wrong with my specific database.  I have a single field in a single table with the incorrect collation.  It's EnterpriseVaultDirectory. MQUpgrade.AgentType.  First of all, the table is empty, the field AgentType has a custom collation, everything else has the default.   I know how to change the collation for this field.  I do it and run the Deployment Scanner and all it well.  My concern is that I'm missing something.  Can it really be that easy?

Wayne Humphrey's picture

Yip as log as you corrected

Solution

Yip as log as you corrected the relevant table and Deployment Scanner now says there are no issues, you good to go ;)

evdiscuss.net - bringing it all together
www.evtools.net - All your EV Tools

biosphere's picture

Most overboard indeed

The 293475 article is in my experience seriously overkill, and may even introduce new (and much more dire) issues if done improperly.

In most cases, opening the offending tables in design mode and changing their collations to db_default (or a specific one, if you really want to be on the safe side) is more than enough.

AndrewB's picture

Eric, Do you remember what

Eric,
Do you remember what you did exactly? I have the collation error with the same table, MQUpgrade,  in my test environment.

AndrewB's picture

Nevermind. A few more clicks

Nevermind. A few more clicks into it and I found what I needed.