Re: Attempt to generate aggregate reports consistently failing (159 Views)
Reply
Regular Advisor
whips04r
Posts: 111
Registered: ‎01-10-2008
Message 1 of 6 (375 Views)

Attempt to generate aggregate reports consistently failing

Am trying to generate Aggregate, Executive Summary (aggregated), False Positive, and Compliance reports for 6x scans however each attempt yeilds only the cover page for each report and a lengthy dump to the Output Console. Howe3ver, if I only generate the Aggregate Report (i.e. 1 report at a time) I mostly (*) get a desirable outcome (i.e. a full report!), though this makes the reporting process rather time expensive experience.


*see below this Output Console dump for Error Details of a WI crash after attempting to close an aggregated Executive Summary report.


The Output Console dump is along the lines of:


 


: Report Failed System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at gy.a(IDbConnection A_0, String A_1)
   at gy.a(String A_0, Int32 A_1)
   at HP.AppSec.Reporting.ReportsDB.b(ReportsDB A_0, SqlCeConnection A_1)
   at HP.AppSec.Reporting.ReportsDB.UpdateCache()
   at HP.AppSec.Reporting.DataProviders.ScanDataProvider.GetData(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
   at HP.AppSec.Reporting.ReportDataSource.getReportData(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
   at HP.AppSec.Reporting.ReportDataSource.GetReportData(IQuery queryDescriptor, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
   at HP.AppSec.Reporting.ReportDescriptor.getReportRunInstance(ActiveReport3 clonedReport, ReportDescriptor mainReport)
   at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.a(SubReport A_0, Section A_1)
   at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.d(Object A_0, EventArgs A_1)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at DataDynamics.ActiveReports.Section.#7kf()
   at DataDynamics.ActiveReports.Section.#Clf(ActiveReport3 report)
   at #kyd.#TD.#1mf(Section section)
   at #kyd.#TD.#Nqf()
   at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
   at DataDynamics.ActiveReports.Section.#wlf(ActiveReport3 parentReport, #Oaf rData)
   at #kyd.#Haf.#Ukf(Int32 pieceIndex)
   at #kyd.#Haf.#Skf()
   at #kyd.#Haf.#lW(Section section, Int32 insPos)
   at #kyd.#Haf.#lW(Section section)
   at #kyd.#TD.#Nqf()
   at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
   at DataDynamics.ActiveReports.ActiveReport3.#Smf()
   at DataDynamics.ActiveReports.ActiveReport3.Run(Boolean syncDocument)
   at HP.AppSec.Reporting.ReportDescriptor.runReport(Boolean syncDocument)


 


WebInspect crashed with following Error Details after I'd generated a solo Aggregate Report, saved and closed that report, then generated an aggregated Executive Summary report:


System.Threading.Thread
Build:8.1.524.2

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

   at System.Collections.CollectionBase.System.Collections.IList.get_Item(Int32 index)
   at #gwd.#nAd.get_Item(Int32 index)
   at DataDynamics.ActiveReports.Document.Page.Draw(Graphics graphics, RectangleF bounds, TextRenderingHint textRenderHint, Single scaleFactorX, Single scaleFactorY, Boolean printing)
   at DataDynamics.ActiveReports.Document.Page.Draw(Graphics graphics, RectangleF bounds, Single scaleFactorX, Single scaleFactorY)
   at DataDynamics.ActiveReports.Document.Page.Draw(Graphics graphics, RectangleF bounds)
   at #Cwd.#oAd.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)
   at System.Windows.Forms.Control.WmPaint(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at #Cwd.#oAd.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


...resulting in WI closing. And immediately another Error was reported with following Error Details:


System.ArgumentOutOfRangeException

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

   at SPI.UI.ErrorForm.a(Object A_0, Exception A_1)
   at SPI.UI.ErrorForm.a(Object A_0, ThreadExceptionEventArgs A_1)
   at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)
   at System.Windows.Forms.Control.WndProcException(Exception e)
   at System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.Run(Form mainForm)
   at aba.h()

Please use plain text.
Occasional Visitor
ScottOrban
Posts: 2
Registered: ‎06-29-2009
Message 2 of 6 (375 Views)

Re: Attempt to generate aggregate reports consistently failing

I just emailed you on this issue.  Please let me know if that addresses your issue.


 

Please use plain text.
Occasional Visitor
GaryMalk
Posts: 1
Registered: ‎02-10-2011
Message 3 of 6 (375 Views)

Re: Attempt to generate aggregate reports consistently failing

I have the same problem.  Could you please post the solution publicly?  Where can I change the timeout value?  I was able to generate a report once.  Everytime since I either get a very short report (1 or 2 pages) or a timeout crash.

 

[2/10/2011 5:16:54 PM]: Report Failed System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   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.ExecuteReader(CommandBehavior behavior)
   at HP.AppSec.Reporting.DataProviders.ScanDataProvider.a(SqlCommand A_0, CommandBehavior A_1)
   at HP.AppSec.Reporting.DataProviders.ScanDataProvider.d(IQuery A_0, Boolean A_1, IRtfFontToFieldMapper A_2, IPropertyToFieldMapper A_3)
   at HP.AppSec.Reporting.DataProviders.ScanDataProvider.GetData(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
   at HP.AppSec.Reporting.ReportDataSource.getReportData(IQuery queryDescriptor, Boolean topZeroFlag, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
   at HP.AppSec.Reporting.ReportDataSource.GetReportData(IQuery queryDescriptor, IRtfFontToFieldMapper rtfFontMapper, IPropertyToFieldMapper propertyMapper)
   at HP.AppSec.Reporting.ReportDescriptor.getReportRunInstance(ActiveReport3 clonedReport, ReportDescriptor mainReport)
   at HP.AppSec.Reporting.ReportDescriptor.getLinkedReportRunInstance(ActiveReport3 clonedReport, ReportDescriptor parentReport, ReportDescriptor mainReport, Dictionary`2 dynamicMapping)
   at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.a(LinkedSubReportModel A_0, Section A_1)
   at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.a(SubReport A_0, Section A_1)
   at HP.AppSec.Reporting.ReportEventHandlers.SubReportFormatHandler.d(Object A_0, EventArgs A_1)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at DataDynamics.ActiveReports.Section.#7kf()
   at DataDynamics.ActiveReports.Section.#Clf(ActiveReport3 report)
   at #kyd.#TD.#1mf(Section section)
   at #kyd.#TD.#Nqf()
   at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
   at DataDynamics.ActiveReports.Section.#wlf(ActiveReport3 parentReport, #Oaf rData)
   at #kyd.#Haf.#Ukf(Int32 pieceIndex)
   at #kyd.#Haf.#Skf()
   at #kyd.#TD.#Nqf()
   at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
   at DataDynamics.ActiveReports.Section.#wlf(ActiveReport3 parentReport, #Oaf rData)
   at #kyd.#Haf.#Ukf(Int32 pieceIndex)
   at #kyd.#Haf.#Skf()
   at #kyd.#TD.#Nqf()
   at #kyd.#TD.#Iqf(Page newPage, Single left, Single top, Single right, Single bottom, UInt32 flags, UInt32& status)
   at DataDynamics.ActiveReports.ActiveReport3.#Smf()
   at DataDynamics.ActiveReports.ActiveReport3.Run(Boolean syncDocument)
   at HP.AppSec.Reporting.ReportDescriptor.runReport(Boolean syncDocument)
[2/10/2011 5:16:55 PM]: Exception in Viewer doWork: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Please use plain text.
Respected Contributor
HansEnders
Posts: 593
Registered: ‎07-01-2008
Message 4 of 6 (375 Views)

Re: Attempt to generate aggregate reports consistently failing

You might be able to force it via the following Timeout setting.  This entry defaults to 300 seconds (5 minutes), and used to drop an error for any higher values.  I verified today in WebInspect 8.1 that a value as high as "1300" was acceptable to generate the Vulnerability Summary.  You will probably want to restart WebInspect after modifying this report value, and ensure you have no other scans open on-screen in order to save on memory load during a large or combined report run.

 

    * Actual Setting = ReportDatabaseTimeout e.g. <ReportDatabaseTimeout>300</ReportDatabaseTimeout>

 

    * configuration file =
          o Win7: C:\Users\All Users\Application Data\SPI Dynamics\WebInspect\7.0\ReportSettings.config
          o XP: C:\Documents and Settings\All Users\Application Data\SPI Dynamics\WebInspect\7.0\ReportSettings.config



 

 

Otherwise, I will ask Scott to drop by and advise on the prior fix.


-- Habeas Data
Please use plain text.
Occasional Visitor
Deepaktechie
Posts: 1
Registered: ‎03-08-2014
Message 5 of 6 (166 Views)

Re: Attempt to generate aggregate reports consistently failing

I am also getting the same exception described below while generating report. Please advise how to resolve it...

 

 


: Report Failed System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlExc

eption 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

Please use plain text.
Respected Contributor
HansEnders
Posts: 593
Registered: ‎07-01-2008
Message 6 of 6 (159 Views)

Re: Attempt to generate aggregate reports consistently failing

Update for WebInspect 10.10:   In Windows 7 x64, the path to this ReportSettings.config file is at-

 

C:\Users\All Users\HP\HP WebInspect\ReportSettings.config

 

 

You may have better resolution by contacting HP Fortify Support directly.  Check http://support.fortify.com for details.


-- Habeas Data
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation