Enterprise Vault SQL scripts fail when the Vault Service Account login's Default Schema is not set to dbo

book

Article ID: 100046002

calendar_today

Updated On:

Description

Error Message

This error is logged by the Start-EVDatabaseUpgrade cmdlet:

[12:22] Database '...' on server '... ': Running script CommonDB_Utils.sql. Start-EVDatabaseUpgrade : There is already an object named 'Util_DropProcedure' in the database. 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: (..:String) [Start-EVDatabaseUpgrade], UpgraderException + FullyQualifiedErrorId : UnknownError,Symantec.EnterpriseVault.Database.DBUpgraderPowerShell.PSUpgraderLog Start-EVDatabaseUpgrade : There is already an object named 'Util_DropProcedure' in the database. 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: (...:String) [Start-EVDatabaseUpgrade], UpgraderException + FullyQualifiedErrorId : UnknownError,Symantec.EnterpriseVault.Database.DBUpgraderPowerShell.PSUpgraderLog Start-EVDatabaseUpgrade : One of the dependent databases failed. At line:1 char:1 + Start-EVDatabaseUpgrade + ~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo  : InvalidOperation: (...:String) [Start-EVDatabaseUpgrade], UpgraderException + FullyQualifiedErrorId : DependantDBFailed,Symantec.EnterpriseVault.Database.DBUpgraderPowerShell.PSUpgraderLog [12:22] Upgrade completed with errors. [12:22] Database upgrader stopped.

Cause

The SQL scripts are written with the presumption that the Default Schema for the Vault Service Account's SQL login will be set to the default value of dbo. Setting the Vault Service Account's login to use a different Default Schema is not supported.

Resolution

Change the Default Schema of the Vault Service Account login to dbo.
If Vault Service Account login does not exist, please ensure one is created under SQL logins with default schema as dbo.

Issue/Introduction

The Enterprise Vault SQL scripts that run during an upgrade will fail if the Vault Service Account's SQL login does not have its Default Schema set to dbo.

Additional Information

JIRA: CFT-1976
Powered by Wolken Software