Custom Report returns error "An error occurred!Control(40042): Protocol Summary Stacked Trend Chart - In A Unknown error was returned: Input string was not in a correct format." for Trend Chart and Stacked Trend Charts only.

Document ID : KB000003918
Last Modified Date : 14/02/2018
Show Technical Document Details

When running a Custom Report in ReporterAnalyzer on Protocol Summary, the Trend Chart and/or Stacked Trend Chart fail to display properly and show one of the errors below.

"An error occurred!
Control(40042): Protocol Summary Stacked Trend Chart - In A Unknown error was returned: Input string was not in a correct format. at
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at
System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Double.Parse(String s, NumberStyles style,
NumberFormatInfo info) at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.CustomReportsTrendDataDc.Fill(AddRowDelegate addRow, Object itemId, String path, Object targetContainer,
DataMeasurement measurement, Boolean isConversation) in d:\Builds\RA\Current\REPORTER\NetQoS.ReporterAnalyzer.Data\ReporterAnalyzer\Cu
stomReportsTrendDataDc.cs:line 341 at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.CustomReportsTrendDataDc.GetProt
ocolStackedTrend(UInt32 reportId, DataDirection direction, DataMeasurement measurement, UInt32 limit) in
d:\Builds\RA\Current\REPORTER\NetQoS.ReporterAnalyzer.Data\ReporterAnalyzer\CustomReportsTrendDataDc.cs:line 180 at
NetQoS.ReporterAnalyzer.Business.Report.CustomReportStackedTrendReport(UInt32 reportId, CustomReportSummaryTypes summaryType, DataDirection direction,
DataMeasurement measurement, UInt32 limit) in d:\Builds\RA\Current\REPORTER\NetQoS.ReporterAnalyzer.Business\Report.cs:line
4204 at NetQoS.ReporterAnalyzer.WebService.ReporterAnalyzer.GetCustomReportStackedTren
dReport(UInt32 reportId, RACustomReportSummaryTypes summaryType, RADataDirection direction, RADataMeasurement measurement, UInt32 limit,
Nullable`1& metaData, Nullable`1& error, String customReportCacheAdditionaKey) in d:\Builds\RA\Current\REPORTER\NetQoS.ReporterAnalyzer.WebService\ReporterAnaly
zer.cs:line 3349 nqPortal at nqPortal.Views.DataSources.ReporterViewDataSource.HandleRAError(RAErrorType
errorType, Nullable`1 error) at nqPortal.Views.DataSources.ReporterViewDataSource.EndGetData() at
nqPortal.Views.ViewBase.RetrieveAsyncData() at NetQoS.Ajax.AjaxUserControl.OnPreRender(EventArgs e)"




Improper regional settings on server.


Check all of the Regional settings as per the Regional Settings Technical document TEC573085.

Also you will need to search the registry for all instances of "sDecimal" and make sure all values are set to "." and not "," by following the steps below.

  1. Start -> Run -> RegEdit

  2. Go to Edit -> Find

    Figure 2

  3. Search for "sDecimal"

    Figure 3

  4. Verify if the correct value of "." is the value for all instances of sDecimal and NOT ","

    If necessary change the value and hit OK.

    Figure 4

  5. Use the "F3" key or "Edit -> Find Next" to search for instances of sDecimal and verify the correct values.

  6. Run the custom report and verify if the error has been resolved. It may be necessary to run IISRESET and/or recycle NetQos ReporterAnalyzer Services after making the changes to the registry.