Resource Manager times out when loading data from Processor data class

book

Article ID: 158754

calendar_today

Updated On:

Products

Inventory Solution

Issue/Introduction

Processor data class view is very slow and it times out  when navigating to Resource Manager -> View -> Inventory -> Data Classes -> Inventory -> Hardware -> Processor and loading data


 

"12/11/2013 1:29:11 PM","Failure running Report 'HW Processor Report'. Please check the configuration of the query.
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8400.0&language=en&module=Hy+df8wKJOJcgiLHVJhOjGYEIbnf5KDRR1f+LebWGRM=&error=-379705652&build=**CEDUrlEnd**


( Exception Details: Altiris.DataSource.Exceptions.DataSourceRunException: An error occurred attempting to run the raw SQL DataSource. ---> System.Threading.ThreadAbortException: Thread was being aborted.
   at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 )
   at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   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, Int32 startRecord, Int32 maxRecords, String srcTable)
   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.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, 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.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.ProcessRequest(HttpContext context)
   at Altiris.NS.UI.VirtualControlHandler.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.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
   at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
   at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
 )
( Extra Details:  Type=Altiris.DataSource.Exceptions.DataSourceRunException Src=Altiris.Reporting.DataSource

  Inner Extra Details:  Type=System.Threading.ThreadAbortException Src=System.Data )","Altiris.Reporting.UI.ReportViewControl.OnLoad","w3wp","23"
 

AND

 

"12/11/2013 1:29:11 PM","Unhandled exception.  Type=System.Web.HttpException Msg=Request timed out.
StackTrace=

**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8400.0&language=en&module=0wXZ+dbwnK6i5ne1iXT8/3ZC57DlFoAbEnKjDhXZCCgbMQXeP0kvmoy4CGk8/Gak&error=1052612286&build=**CEDUrlEnd**
","global.asax","w3wp","23"
 

Cause

Defect

Resolution

This has been fixed in 7.1 SP2 MP1 v9.


Applies To

Inventory Solution 7.1 SP2
Inventory Solution 7.1 SP2 MP1

Attachments