Enterprise Vault 12.1 Database Upgrade Fails with DF_AuditTrail_info is Not a Constraint
Article ID: 100033745
Updated On:
Description
Error Message
Log Name: Symantec Enterprise VaultSource: Enterprise VaultDate: 09/11/2016 16:53:13Event ID: 41533Task Category: Database UpgraderLevel: ErrorKeywords: ClassicUser: N/AComputer: FFM30EMMC01Description:The database upgrader running on 'FFM30EMMC01' server failed. Failed to upgrade 'Auditing' database. Database:'EnterpriseVaultAudit' server:'ffm30dbac10'. '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. For more information, see Help and Support Center at http://telemetry.community.veritas.com/entt?product=ev&language=english&version=12.1.0.0&build=12.1.0.1424&error=V-437-41533Event Xml: |
Cause
The problem occurs because in past versions the constraints were auto named. An example of the constraint may look similar to DF__AuditTrail__info__7D78A4E7 in SQL for the dbo.Audit table and the database upgrader is looking for DF_AuditTrail_info which causes the process to fail.
Resolution
Workaround:
Contact Veritas support and reference this article for workaround/solution.
Veritas has acknowledged that the above-mentioned issue is present in the version(s) of the product(s) referenced in this article.
Veritas currently plans to address this issue by way of a cumulative hotfix to the current version of the software. Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here. A link to the cumulative hotfix download will be added to this document when it becomes available. Please note that Veritas reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests. Veritas’s plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.
Contact Veritas support and reference this article for workaround/solution.
Veritas has acknowledged that the above-mentioned issue is present in the version(s) of the product(s) referenced in this article.
Veritas currently plans to address this issue by way of a cumulative hotfix to the current version of the software. Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here. A link to the cumulative hotfix download will be added to this document when it becomes available. Please note that Veritas reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests. Veritas’s plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.
Issue/Introduction
When running Start-EVDatabaseUpgrade to upgrade the Enterprise Vault (EV) databases the process fails with ' DF_AuditTrail_info is Not a Constraint', could not drop constraint.
The database upgrade does not complete.
The database upgrade does not complete.
Was this article helpful?
Yes
No
Powered by
