CODEWITHSUNDEEP
acumatica
Andrew
Andrew

Reputation: 135

An error while processing the validating sql scripts(ACUMATICA UPGRADE 18.217.002 to 19.207.0026)

I am trying to upgrade acumatica from 18.217 to 19.207. There is a customization which depended on FSCause and FSResolution Data Access Class which have been removed from 19.207 and the user data fields moved to attributes section. I have decided to delete those user defined fields from the customization and when I publish it it generates a validation error:

     Validating Binary Files
    Validating Sql Scripts
    **An error while processing the validating sql scripts**
    **Validation failed.**```
    The trace error is 


29/02/2020 11:59:19 AM Information:
Redirect7:/ScienceScope/(W(10))/frames/projectbrowser.aspx$target=ServiceOrder17JUNE2019

   at PX.Web.UI.PXBaseDataSource.ExecuteSelect(String viewName, DataSourceSelectArguments arguments, PXDSSelectArguments pxarguments)
   at PX.Web.UI.PXDataSource.ExecuteSelect(String viewName, DataSourceSelectArguments arguments, PXDSSelectArguments pxarguments)
   at PX.Web.UI.PXDataSourceView.Select(DataSourceSelectArguments arguments, PXDSSelectArguments swarguments, DataSourceViewSelectCallback callback)
   at PX.Web.UI.PXGrid.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
   at PX.Web.UI.PXGrid.PX.Web.UI.IPXDataBoundControl.EnsureDataBoundInternal()
   at PX.Web.UI.PXCallbackManager.a(Dictionary`2 A_0, List`1 A_1)
   at PX.Web.UI.PXCallbackManager.a(PXCallbackResultMethod A_0, XmlWriter A_1)
   at PX.Web.UI.PXCallbackManager.a(PXCallbackResultMethod A_0)

How can I resolve this issue ?

Upvotes: 0

Views: 153

Answers (1)

Andrew
Andrew

Reputation: 135

Sometimes after an upgrade inappropriate errors can be shown which force validation can be enforced to ignore the error by creating a CstValidationIgnore.txt file in visual studio and adding it to your project. To learn more about it visit acumatica 2019R2 documentation at To Use an Ignore List for the Validation Errors

Upvotes: 1

Related Questions