Saving a New Record in a Leveled Application Returns the Error "This page can't be displayed"

[KB-Sync1]

Article Number

000036214

Applies To

Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises/AWS Hosted/AWS SaaS

---

Description

• Saving a new record in a leveled application returns the error: This page can't be displayed.
• This error happened with a specific application when you try to save a new record under a specific level.
• When tested on the Web server, the record doesn't get added and it gives http error: This page cannot be displayed.
• When tested from outside the webserver, sometimes it gives proxy error.

0EMVM000005CTMk.jpg

Below is an example of the W3wp error:

<DataItem>
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>Engine</TraceIdentifier>
                    <Description>Value is not a valid number: B83 Parameter name: serialDate</Description>
                    <AppDomain>/LM/W3SVC/1/ROOT/Archer</AppDomain>
                    <Exception>
                        <ExceptionType>System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=a3b6c464621d074</ExceptionType>
                        <Message>Value is not a valid number: B83 Parameter name: serialDate</Message>
                        <Source>ArcherTech.Services.Providers</Source>
                        <StackTrace>   at Syncfusion.Calculate.CalcEngine.ComputedValue(String formula)
   at Syncfusion.Calculate.CalcEngine.GetValueFromArg(String arg)
   at ArcherTech.Services.Providers.CalculationProviders.SyncFusion.CustomFunctions.SystemCustomFunctions.If(String parameters)</StackTrace>
                    </Exception>

Cause

• The error is from Syncfusion calc Engine. The application crashes when trying to save because of a Fatal Exception which can't be handled.
• The error happens when a calculated field is updated with applying a formula.
• Engineering was able to identify that if a calculation field contains a Formula that includes more than 14 nested IF conditions it gives this error. 
• If the nested conditions are 14 it works. It crashes the application when it exceeds this limit. 

Workaround

• First, to test, you should either delete the field if possible or remove the formula anywhere outside and save the field with empty formula. Inactivating the field will not make any difference and the issue will continue to occur. 
• After confirming you can now save the record added successfully. Divide the formula on a number of calculated fields to max 14 nested IF conditions under each calculated field.

Defect ID

CE-6748