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.

book

Article ID: 3918

calendar_today

Updated On:

Products

APPLICATION DELIVERY ANALYSIS SUPERAGENT CA Infrastructure Performance

Issue/Introduction

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)"

 

 

Cause

Improper regional settings on server.

Environment

Release:
Component: NQRACO

Resolution

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


    src="/servlet/servlet.FileDownload?file=0150c000004AKSlAAO" alt="Figure 2" width="245" height="239">

  3. Search for "sDecimal"


    src="/servlet/servlet.FileDownload?file=0150c000004AKSmAAO" alt="Figure 3" width="412" height="194">

  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.

    src="/servlet/servlet.FileDownload?file=0150c000004AKSnAAO" alt="Figure 4" width="650" height="206">

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

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.

Attachments

1558708342383000003918_sktwi1f5rjvs16r1u.gif get_app
1558708339450000003918_sktwi1f5rjvs16r1t.gif get_app
1558708337409000003918_sktwi1f5rjvs16r1s.gif get_app