Failure running Report 'Summary of Symantec Endpoint Protection Client content versions'.

Article:TECH127318  |  Created: 2010-04-09  |  Updated: 2013-03-26  |  Article URL http://www.symantec.com/docs/TECH127318
Article Type
Technical Solution


Issue



Failure running Report 'Summary of Symantec Endpoint Protection Client content versions'.

Module: w3wp.exe
Source: Altiris.Reporting.UI.ReportViewControl.OnLoad
Description: Failure running Report 'Summary of Symantec Endpoint Protection Client content versions'. Please check the configuration of the query.

( Exception Details: Altiris.DataSource.Exceptions.DataSourceRunException: An unexpected SQL error occurred when running the RawSqlDataSource. ---> System.Data.SqlClient.SqlException: Invalid length parameter passed to the SUBSTRING function.
   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.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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 Altiris.Reporting.DataSource.RawSqlDataSource.Run()
   --- End of inner exception stack trace ---
   at Altiris.Reporting.DataSource.RawSqlDataSource.Run()
   at Altiris.Reporting.Report.Run()
   at Altiris.Reporting.UI.ReportViewControl.DataBind(Boolean raiseOnDataBinding, DataBindMode mode)
   at Altiris.Reporting.Controls.StandardReportViewControl.DataBind(Boolean raiseOnDataBinding, DataBindMode mode)
   at Altiris.Reporting.Controls.StandardReportViewControl.DataBind(DataBindMode mode)
   at Altiris.Reporting.UI.ReportViewControl.OnLoad(EventArgs e) )
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.Diagnostics.Logging.EventLog.ReportException(String strMessage, String category, Exception exception)
   at Altiris.NS.Logging.EventLog.ReportException(String strMessage, Exception exception)
   at Altiris.Reporting.UI.ReportViewControl.OnLoad(EventArgs e)
   at Altiris.Reporting.Controls.StandardReportViewControl.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.report_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.ResumeStepsFromThreadPoolThread(Exception error)
   at System.Web.HttpApplication.AsyncEventExecutionStep.ResumeStepsWithAssert(Exception error)
   at System.Web.HttpApplication.AsyncEventExecutionStep.OnAsyncEventCompletion(IAsyncResult ar)
   at System.Web.HttpAsyncResult.Complete(Boolean synchronous, Object result, Exception error, RequestNotificationStatus status)
   at System.Web.SessionState.SessionStateModule.PollLockedSessionCallback(Object state)
   at System.Threading._TimerCallback.TimerCallback_Context(Object state)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading._TimerCallback.PerformTimerCallback(Object state)
 )
( Extra Details:  Type=Altiris.DataSource.Exceptions.DataSourceRunException Src=Altiris.Reporting.DataSource

  Inner Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient Data Provider )

 


Environment



SEP IC 7.0 Sp1


Cause



The Inv_SW_Antivirus table [Virus Definition File Version] column contains an unexpected format of data. The Report expect an x.x.x data format.

 

Verification query:

SELECT DISTINCT _ResourceGuid
,[Virus Definition File Version]
FROM Inv_SW_Antivirus
WHERE [Virus Definition File Version] IS NOT NULL


Solution



The following is provided as a quick temporary workaround at your responsibility to make a complete backup of the Symantec_CMDB database:

UPDATE [Symantec_CMDB].[dbo].[Inv_SW_Antivirus]
   SET [Virus Definition File Version] = '0.'+[Virus Definition File Version]+'.0'
 WHERE  [Virus Definition File Version] IS NOT NULL AND [Virus Definition File Version] NOT LIKE '%.%.%'

Try running the problematic report and dashboard again.

There will be a permanent fix available for this issue in the 7.5 Orion release.



Legacy ID



52345


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


Terms of use for this information are found in Legal Notices