problem with post upgrade v11 to v12

[noamda]

I upgraded ev 11 to 12.1, after the upgrade I ran the Start-EVDatabaseUpgrade command.

This command failed with the error 

Start-EVDatabaseUpgrade : 'DF_AuditTrail_info' is not a constraint.
Could not drop constraint. See previous errors.
Database upgrader has encountered an unrecoverable SQL fault while upgrading
the database. If you cannot solve this issue, contact your support
representative.
At line:1 char:1
+ Start-EVDatabaseUpgrade
+ ~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (EnterpriseVaultAudit:String)
[Start-EVDatabaseUpgrade], UpgraderException
+ FullyQualifiedErrorId : UnknownError,Symantec.EnterpriseVault.Database.D
BUpgraderPowerShell.PSUpgraderLog

 I saw this KB https://www.veritas.com/support/en_US/article.000125935

But it says to contact support, currently due to technical issues I cannot contact veritas support

I need urgent assitent with this issue as my server is down.

Thanks in advanced

[plaudone1 · Accepted solution]

Hi noamda,

You could do the following after backing up the DB. 

1. Open SQL Server Management Server (SSMS)
2. Expand Databases / EnterpriseVaultAudit / Tables / dbo.AuditTrail / Constraints
3. Right-click on the constraint with name similar to DF__AuditTrail__info__########
4. Select Rename, and then type in DF_AuditTrail_info

There should only be one underscore between each section and no trailing characters after info. 

Regards,

Patrick 

[noamda]

Hi Patrick

Thanks for your quick replay, it solved my problem!!!