Error Message

Error message in the Info pane of the Customer's Properties in EVBAAdmin:

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fx_IsParentCaseClosed", or the name is ambiguous.

Corresponding EV Event Log entries:

Event ID 64 Description:

APP ATM - Error upgrading a Customer.
Install Thread - worker thread (1)
Customer ID: X
Number of tries: 1
Cause: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fx_IsParentCaseClosed", or the name is ambiguous.

V-437-64

Event ID 59 Description:

APP ATM - Failed to update database. System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fx_IsParentCaseClosed", or the name is ambiguous.
at Veritas.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
at Veritas.EnterpriseVault.DatabaseAccess.EVSqlCommand.ExecuteNonQuery()
at KVS.Accelerator.Application.Install.RunScript(String ScriptName, EVSqlCommand CMD, Int32 CustomerID)
at KVS.Accelerator.Application.Install.UpdateDatabase(CustomerRow theCustomerRow, String configDSN)
ClientConnectionId:a1847f7f-709f-4407-9e5b-50e2923115ec
Error Number:4121,State:1,Class:16

V-437-59

Event ID 49 Description:

APP ATM - Error Executing : C:\Program Files (x86)\Enterprise Vault Business Accelerator\AcceleratorDatabaseViews.sql
Line: X
Failed to Execute the following command:
...
. System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fx_IsParentCaseClosed", or the name is ambiguous.
at Veritas.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
at Veritas.EnterpriseVault.DatabaseAccess.EVSqlCommand.ExecuteNonQuery()
at KVS.Accelerator.Application.Install.RunScript(String ScriptName, EVSqlCommand CMD, Int32 CustomerID)
ClientConnectionId:a1847f7f-709f-4407-9e5b-50e2923115ec
Error Number:4121,State:1,Class:16

V-437-49

All Accelerator databases use the default schema of dbo. The issue is caused by an incorrect default schema listed for the database in the SQL user for the Vault Service Account (VSA)

The default schema can be edited in SQL Server Manager Studio (SSMS) as follows:

1. Log on to SSMS with an account having system admin (SA) rights.
2. Connect to the Database Engine servicing the affected Customer database.
3. In Object Explorer, expand Security | Logins | Right-click the VSA account | Properties | User Mapping.
4. Check the Default Schema for all databases mapped to the login.
5. Edit all non-dbo Default Schema entries to dbo by clicking on the kebab menu (also known as ellipses), finding and selecting the dbo schema and saving the change.

If an error similar to the following is seen, this change will need to be made by the SQL team responsible for the SQL Server:

Msg 15151, Level 16, State 1, Line X
Cannot alter the user '', because it does not exist or you do not have permission.