NAV client crashes when opening a page based on a SQL View

rsaritzky

Hi all,

I have a "Worksheet" type page based on a SQL View. The worksheet has a series of filters on the page when are then applied to the view.

When I try to open the page, the NAV client immediately crashes. I found an exception file that says the following:

Type: System.FormatException
Message: Input string was not in a correct format.
StackTrace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at Microsoft.Dynamics.Nav.Client.DataBinder.FilterConverter.CreateNavFilterFromExpressionNode(ExpressionNode node, NavFilter[]& filters)
at Microsoft.Dynamics.Nav.Client.DataBinder.FilterConverter.CreateNavFilterFromExpressionNode(ExpressionNode node, NavFilter[]& filters)
at Microsoft.Dynamics.Nav.Client.DataBinder.FilterConverter.CreateNavFilterFromExpressionNode(ExpressionNode node, NavFilter[]& filters)
at Microsoft.Dynamics.Nav.Client.DataBinder.NavFilterHelper.GetUserFilters()
at Microsoft.Dynamics.Nav.Client.DataBinder.NavFilterHelper.UpdateFilterGroupManager()
at Microsoft.Dynamics.Nav.Client.DataBinder.NavRecordStateHandler.CreateRecordState(Boolean includeServerFormState, Boolean includeSubFormSelectionStates, NavRecord record)
at Microsoft.Dynamics.Nav.Client.DataBinder.NstDataAccess.InitializeOpenFormArguments(LogicalForm mainForm, ICollection`1 subForms, NavOpenFormArguments& mainFormOpen, NavOpenFormArguments[]& subFormsOpen)
at Microsoft.Dynamics.Nav.Client.DataBinder.NstDataAccess.OpenForm(LogicalForm mainForm, Collection`1 subForms)
at Microsoft.Dynamics.Nav.Client.UIPatterns.OnFormOpeningPattern.OpenForm(LogicalForm form)
at Microsoft.Dynamics.Framework.UI.LogicalForm.OnFormBuilt(EventArgs e)
at Microsoft.Dynamics.Framework.UI.LogicalForm.BuildForm()
at Microsoft.Dynamics.Nav.Client.Builder.NavSessionHelper.BuildForm(LogicalForm form)
at Microsoft.Dynamics.Nav.Client.FormBuilder.PageBuilder.Build(MasterPage definition, BindingManager bindingManager, UIBuilderContext context)
at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.CreateLogicalForm(MasterPage metadata, FormState formState)
at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.CreateLogicalForm(Int32 formId, FormState formState, Int32 retryCounter)
at Microsoft.Dynamics.Nav.Client.Actions.NavOpenTaskPageAction.CreateForm(UISession uiSession, NavBindingManager parentBindingManager, FormState formState)
at Microsoft.Dynamics.Nav.Client.Actions.NavOpenTaskPageAction.InvokeCore(LogicalControl logicalControl, Object state, UISession uiSession)
at Microsoft.Dynamics.Framework.UI.LogicalAction.InvokeCoreWithErrorHandling(LogicalControl logicalControl, Object state, UISession uiSession)
at Microsoft.Dynamics.Framework.UI.LogicalAction.DoInvoke(LogicalControl logicalControl, UISession uiSession)
at Microsoft.Dynamics.Framework.UI.UX2006.NavigationService.NavigateToNode(LogicalControl logicalControl, NavigationNode node)
at Microsoft.Dynamics.Framework.UI.UX2006.WinForms.PageSearchBar.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Source: mscorlib
HResult: -2146233033


Apparently there is data-format conversion issue. However, it gets strange. This page has been working OK. AND, if I save the page as a different object number, then run the NEW page, the page opens and behaves fine. I've tried deleting the Object Metadata record from table 2000000071, but that didn't prevent the problem.

Has anyone seen this? The SQL view is relatively simple, joining Item Ledger Entry, Warehouse Entry and Serial No. information - the view isn't simple enough however to be created in a Query.

Thanks

Ron

Juhl

Delete Profile and User Metadata for the page as well.

lynge

If Juhls answer does not work, make sure that your primary key in NAV is actually unique when running the view. I've seen all kind of strange behavior if it is not...

Juhl

Delete Profile and User Metadata for the page as well.

lynge

If Juhls answer does not work, make sure that your primary key in NAV is actually unique when running the view. I've seen all kind of strange behavior if it is not...

rsaritzky

Thanks, lynge. Primary key is Item Ledger Entry "Entry No." so it is unique. I deleted personalizationstore.xml on my local drive (It can be in various locations. Mine was stored in
C:\Users\<Username>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV.

Deleting this file did the trick.