SQL Server Collation has failed

[Leonardo_Fern1]

The database with mixed collation is the vault directory not the vault store, could this cause a problem? I was able to successfully upgrade from 8.0.2 to 9.0.0 and recently to 9.0.1.

Deplayment Scanner returned the following:

Failed
At least one test for the SQL server collation has failed. SQL databases (shown below) contain entities with mixed collations. If they are Enterprise Vault Vault Store databases then they will prevent a successful upgrade. Please go to http://seer.entsupport.symantec.com/docs/293475.htm for more details.

 
USATL01MQ224: Database: EnterpriseVaultDirectory, Table: MQUpgrade , Column: AgentType ; - mixed SQL collation found.

 
USATL01MQ224: Database: EnterpriseVaultMonitoring - no mixed collations found. 
USATL01MQ224: Database: EVATL01MAILVAULTSTORE01 - no mixed collations found. 
USATL01MQ224: Database: EVATL01PFVAULTSTORE01 - no mixed collations found. 
USATL01MQ224: Database: EVConfiguration - no mixed collations found. 
USATL01MQ224: Database: EVVSGDefaultUpgradeGroup_1_1 - no mixed collations found

[JesusWept3 · Accepted solution]

Based on that you're not really going to have an issue, if you can fix it, great, if you can't wouldn't worry about it

[Leonardo_Fern1]

That's what I figured based on what I had read, but I wasn't too sure. Thanks for the quick resposne.

[GertjanA]

Hello Leonardo,

We had the same, and 'fixed' it by manually changing the collation on that specific field:

Database: EnterpriseVaultDirectory, Table: MQUpgrade , Column: AgentType

That did not cause any problems, and will ensure a clean deployment scanner.