Test Findings from PxWebComparer

This document includes findings from the compare test performed with the PxWebComparer application

Test performed on saved queries

• SQ id ce19dae4-5fcd-413c-afae-917de3345db4. Format PX. Difference in the NOTE part. There is an extra # in the result generated from the netstandard api.
• Running the following saved query: http://pxwebstandardtest.scb.intra/sq/69725 will produce the following error in the Excel serializer:

2020-09-08 10:29:08,325 [63] ERROR PXWeb.Modules.PXWebHttpModule - PX-Web Application Error ---> Offending URL: http://pxwebstandardtest.scb.intra/sq/69725 -- Source: ClosedXML -- Message: Cannot set data type to Number because '238,7' is not recognized as a number. Parameter name: value -- Stack trace: at ClosedXML.Excel.XLCell.set_DataType(XLDataType value) at PCAxis.Excel.XlsxSerializer.<>c__DisplayClass19_0.b__2(IXLCell c) at PCAxis.Excel.XlsxSerializer.SetCellFormat(IXLCell cell, CellContentType type, Object value, FormatCellDescription changes) at PCAxis.Excel.XlsxSerializer.CreateWorkbook(PXModel model) at PCAxis.Excel.XlsxSerializer.serialize(PXModel model, Object output) at PXWeb.Views.FileViewSerializer.Render(String format, SavedQuery query, PXModel model, Boolean safe, String fileExtension, String mimeType) in E:\RMAgents\Agent1-A299_work\265\s\PXWeb\Code\Views\FileViewSerializer.cs:line 82 at PXWeb.Views.FileViewSerializer.Render(String format, SavedQuery query, PXModel model, Boolean safe) in E:\RMAgents\Agent1-A299_work\265\s\PXWeb\Code\Views\FileViewSerializer.cs:line 57 at PXWeb.SavedQueryHandler.ProcessRequest(HttpContext context) in E:\RMAgents\Agent1-A299_work\265\s\PXWeb\SavedQueryHandler.ashx.cs:line 281 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 2020-09-08 10:29:08,325 [63] ERROR Global - System.ArgumentException: Cannot set data type to Number because '238,7' is not recognized as a number. Parameter name: value at ClosedXML.Excel.XLCell.set_DataType(XLDataType value) at PCAxis.Excel.XlsxSerializer.<>c__DisplayClass19_0.b__2(IXLCell c) at PCAxis.Excel.XlsxSerializer.SetCellFormat(IXLCell cell, CellContentType type, Object value, FormatCellDescription changes) at PCAxis.Excel.XlsxSerializer.CreateWorkbook(PXModel model) at PCAxis.Excel.XlsxSerializer.serialize(PXModel model, Object output) at PXWeb.Views.FileViewSerializer.Render(String format, SavedQuery query, PXModel model, Boolean safe, String fileExtension, String mimeType) in E:\RMAgents\Agent1-A299_work\265\s\PXWeb\Code\Views\FileViewSerializer.cs:line 82 at PXWeb.Views.FileViewSerializer.Render(String format, SavedQuery query, PXModel model, Boolean safe) in E:\RMAgents\Agent1-A299_work\265\s\PXWeb\Code\Views\FileViewSerializer.cs:line 57 at PXWeb.SavedQueryHandler.ProcessRequest(HttpContext context) in E:\RMAgents\Agent1-A299_work\265\s\PXWeb\SavedQueryHandler.ashx.cs:line 281 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Possible solution: Set the culture to handle commas.