Error while click on standard reports in NAV 2018 AU CU9

ravishah

Deal All,

Recently we have migrated one DB from NAV 2013R2 to NAV 2018. After migration everything works fine but having strange issue for random users for random standard reports (Ex.: Detail Trail Balance, Trial Balance etc..). when user clicks on reports, below error occur. However, from server it's works fine.



Error is also not consistent. sometimes user able to open and sometimes not. Also some users can able to access reports and some users can not.

I have tried below activities but could not get success:
1) Un-Install and Install NAV 2018 Client again
2) Update OS in users Machine & check .Net framework
3) Compiled all objects and build server application Objects
4) Delete user personalization and Delete User metadata
5) There was no customization in reports even though i have imported all reports from Cronus Database.
6) Give users to super permission

Below is the details i have found in Event Viewer (from Server):
Server instance: DynamicsNAV110_MCST
Category: Runtime
ClientSessionId: {13a1bbde-963c-4aad-b35a-c3013b03c012}
ClientActivityId: {8d01766e-c998-4109-8664-051810cdf56e}
ServerSessionUniqueId: {0eb8c1c9-e65b-44bc-898f-9a07acf39142}
ServerActivityId: {04442db1-9a71-49dc-8018-ef5a4856ee6b}
EventTime: ‎2018‎-‎11‎-‎26T05:48:53.839538400Z
Message (NavSerializationException): Exception: NavSerializationException
The assembly or type cannot be deserialized, Assembly: Microsoft.Dynamics.Nav.Types, Version=7.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, Type; Microsoft.Dynamics.Nav.Types.NavFilterGroup
ExceptionStackTrace:
at Microsoft.Dynamics.Nav.Service.ServiceCall.GetClientReturnValue(Action invokeCallback)
at Microsoft.Dynamics.Nav.Service.NSClientCallback.FormRunModal(NavForm form, NavFormRuntimeParameters parameters)
at Microsoft.Dynamics.Nav.Runtime.NavForm.RunModal(NavRecord record, Int32 fieldNo)
at Microsoft.Dynamics.Nav.Runtime.NavReport.InternalRunRequestPage()
at Microsoft.Dynamics.Nav.Runtime.NavReport.RunReportInternal(NavRecord record, Boolean displayResult)
at Microsoft.Dynamics.Nav.Runtime.NavReport.RunReport(Nullable`1 requestWindow, Nullable`1 systemPrinter, Boolean runReportModal, NavRecord record, IList`1 reportTextualFilters, RunMode mode)
at Microsoft.Dynamics.Nav.Runtime.NavReport.RunReport(Int32 reportId, Nullable`1 requestWindow, Nullable`1 systemPrinter, Boolean isRunningAsModal, NavRecord record, IList`1 textualFilters, RunMode runMode)
at Microsoft.Dynamics.Nav.Runtime.NavReport.Run(Int32 reportId)
at Microsoft.Dynamics.Nav.Service.NSService.RunReport(ApplicationMethodRequest applicationMethodRequest)
at SyncInvokeRunReport(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.RunInTransactionCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass25_1.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.TransientErrorRetryCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass25_1.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.ErrorMappingCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs)

ProcessId: 5272
Tag: 00000HC
ThreadId: 9
CounterInformation:

Kindly help me to solve it.

Regards,
Ravi Shah

Arimator

In my case the problem was related to the "PersonalizationStore.xml" file stored in %AppData%\Roaming\Microsoft\Microsoft Dynamics NAV". In this file, the saved report filters are stored (together with other information about user personalization).

Two options:

1. Either delete this file

2. Remove all "Report"-Related nodes from the Xml. (make sure that the NAV client is not running when tampering with the file). The report-related nodes can be identified with the PersonalizationObjectId="NAV.ReportID... attrribute (for example NAV.ReportID50002 for report with ID 50002).

Ravi_Thakkar

Hi Ravi,

Did you get any solution to this ?

I am facing the same issue and also on the same Version of NAV 2018 CU9.

Please, advise.