Error Message

Source:        Enterprise Vault 
Date:          3/16/2016 8:54:09 AM
Event ID:      13404
Task Category: Admin Service
Level:         Error
Computer:      EVserver1.ev.local
Description:
A Schema inconsistency error was detected while accessing the Vault Database 'Provider=SQLOLEDB;Server=evsql;Database=EnterpriseVaultAudit;Trusted_Connection=yes' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines {1317,1319,1338,1361}, built Nov 19 15:44:06 2014]): 

Description:  
Could not find stored procedure 'GetDatabaseFileInfo'.
 
SQL Command: 
 GetDatabaseFileInfo
 
Additional Microsoft supplied information:
 
Source:       Microsoft OLE DB Provider for SQL Server 
Number:       0x80040e14 
SQL State:    42000 
Native Error: 00002812 
HRESULT        0x80040e14
V-437-13404

The Stored Procedure referenced in the error is missing from the Enterprise Vault Audit Database

1. Confirm there is a good backup copy of the EnterpriseVaultAudit database. 
2. Stop all the Enterprise Vault services on all Enterprise Vault servers. 
3. On the EV server, browse to the installation folder (typically C:\Program Files (x86)\Enterprise Vault)
4. Find the file named Audit_Schema_Upgrade.sql and copy it to the SQL server
5. Start SQL Server Management Studio. In the left pane under Databases, select the EnterpriseVaultAudit database. 
6. From the File menu, click Open > File. 
7. Navigate to the folder where the file  Audit_Schema_Upgrade.sql is located.
8. Click Open. (Note: Simply copy that script to the SQL server and drop it into the query window)
9. From the Query menu, click the Execute button.
10. After the script has completed successfully, exit from SQL Server Management Studio and start all EV services.