Enterprise Vault (EV) Reports not working after upgrading

Article:TECH165208  |  Created: 2011-07-21  |  Updated: 2014-12-18  |  Article URL http://www.symantec.com/docs/TECH165208
Article Type
Technical Solution


Issue



After upgrading to EV9, EV9.0.1, EV9.0.2 or 10.0 the following EV reports no longer function:

  • Vault Store Usage Summary
  • Mailbox Archiving Status

Error



Mailbox Archiving Status displays the error: An error has occurred during report processing. (rsProcessingAborted)


Vault Store Usage Summary displays - "There is no data available to display"



Cause



Running a DTRACE of the W3WP process on the reporting server will give the following information for each EV Vault Store:

(w3wp)  <5828>  EV-H        {ARCHIVESUMMARYREPORTDATAREGION.EN_US} Failed to get vault store information
(w3wp)  <5828>  EV-H        {ARCHIVESUMMARYREPORTDATAREGION.EN_US} Exception: The SELECT permission was denied on the object 'view_WatchFile2', database 'DBNAME', schema 'dbo'. Info: Diag:Num:229 State:5 Sev:14 Svr:SQLSERVERNAME Proc: Line:1 Type:System.Data.SqlClient.SqlException ST:   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)|   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)|   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)|   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)|   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()|   at System.Data.SqlClient.SqlDataReader.get_MetaData()|   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)|   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)|   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)|   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)|   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)|   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)|   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)|   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)|   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)|   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)|   at Symantec.EnterpriseVault.Reports.EVReports.ArchiveSummaryReportDataRegion.GetVaultStoreInfo(String sqlServer, String databaseName)
(w3wp)  <5828>  EV-M        {ARCHIVESUMMARYREPORTDATAREGION.EN_US} Leaving ArchiveSummaryReportDataRegion::GetVaultStoreInfo
(w3wp)  <5828>  EV-H        {ARCHIVESUMMARYREPORTDATAREGION.EN_US} Exception: Cannot find table 0. Info: Diag: Type:System.IndexOutOfRangeException ST:   at System.Data.DataTableCollection.get_Item(Int32 index)|   at Symantec.EnterpriseVault.Reports.EVReports.ArchiveSummaryReportDataRegion.GetDataSet(String connectionString, ArrayList parameterCollection)
(w3wp)  <5828>  EV-H        {ARCHIVESUMMARYREPORTDATAREGION.EN_US} vaultStoreDS does not contain any row. Continue with next VaultStores entry
 


Solution



This issue has been addressed as part of the following release:


Enterprise Vault 9.0.3 - Release Details
http://www.symantec.com/docs/TECH147782

Enterprise Vault 10.0.1 - Release Details
http://www.symantec.com/docs/TECH147787



Run the following SQL query against every Vault Store database:

GRANT SELECT ON [dbo].[view_WatchFile2] TO [EVReportingRole]


Supplemental Materials

SourceETrack
Value2423467
Description

Two EV Reports not working after upgrade from EV8 SP4 to EV 9 SP2



Article URL http://www.symantec.com/docs/TECH165208


Terms of use for this information are found in Legal Notices