Clickonce won't open after Windows update for some users

christophersvensson

Background specs:

NAV version: NAV 2017 (11.0.23019.0)
Client Windows version: 21H1 (19043.1415)

Since our customer updated their computer to the new Windows version, their clickonce stopped working. We click the icon and nothing happens.



Error messages that occur in the log:

Tillämpningsprogram: Microsoft.Dynamics.Nav.Client.exe
Framework-version: v4.0.30319
Beskrivning: Processen avslutades på grund av ett ohanterat undantag.
Undantagsinformation: System.NullReferenceException
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindMajorVersion(Microsoft.Win32.RegistryKey)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.<.ctor>b__8_0(Microsoft.Win32.RegistryKey)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindRegistryKey(Microsoft.Win32.RegistryHive, System.String, System.Action`1<Microsoft.Win32.RegistryKey>)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindFirstRegistryKey(System.String, System.Action`1<Microsoft.Win32.RegistryKey>)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService..ctor(Microsoft.Dynamics.Framework.UI.UISession)
vid Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession+<>c.<AddServices>b__22_6(Microsoft.Dynamics.Framework.UI.UISession)
vid Microsoft.Dynamics.Framework.UI.ClientSessionCore.AddUIService(System.Func`2<Microsoft.Dynamics.Framework.UI.UISession,Microsoft.Dynamics.Framework.UI.IUIService>)
vid Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.AddServices()
vid Microsoft.Dynamics.Framework.UI.ClientSessionCore.Prepare()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.SetupClientSession()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.RunCore()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.Run(Boolean)
vid Microsoft.Dynamics.Nav.Client.Program.Main(System.String[])

________________


Beskrivningen för händelse-ID 0 från källan Application kan inte hittas. Antingen är komponenten som skapat händelsen inte installerad på den här datorn eller så är installationen skadad. Installera eller återställ komponenten på datorn.

Om händelsen skapades från en annan dator behövde visningsinformationen sparas med händelsen.

Följande information inkluderades med händelsen:

Type: Microsoft.Dynamics.Nav.Types.Exceptions.WatsonReportException
Message: <ii>Watson report failure</ii>
StackTrace:
vid Microsoft.Dynamics.Nav.Watson.WatsonHandler.SendWatsonReport(Exception exception, Boolean showUI, Assembly assembly, String applicationName)
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.HandleWatson(Exception exception, Int32& runCore)
Source: Microsoft.Dynamics.Nav.Watson
HResult: -2146233088

---

Type: System.NullReferenceException
Message: <ii>Objektreferensen har inte angetts till en instans av ett objekt.</ii>
StackTrace:
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindMajorVersion(RegistryKey registryKey)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.<.ctor>b__8_0(RegistryKey regKey)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindRegistryKey(RegistryHive hive, String keyName, Action`1 action)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindFirstRegistryKey(String keyName, Action`1 action)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService..ctor(UISession uiSession)
vid Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.<>c.<AddServices>b__22_6(UISession uis)
vid Microsoft.Dynamics.Framework.UI.ClientSessionCore.AddUIService(Func`2 addService)
vid Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.AddServices()
vid Microsoft.Dynamics.Framework.UI.ClientSessionCore.Prepare()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.SetupClientSession()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.RunCore()
Source: Microsoft.Dynamics.Nav.Client.WinClient
HResult: -2147467261


Meddelanderesursen finns men det gick inte att hitta meddelandet i meddelandetabellen


________________


Fel-bucket 1379334118430748553, typ 5
Händelsenamn: CLR20r3
Svar: Inte tillgänglig
Kabinett-ID: 0

Problemsignatur:
P1: Microsoft.Dynamics.Nav.Client
P2: 11.0.23019.0
P3: 5b353f3d
P4: Microsoft.Dynamics.Nav.Client.WinClient
P5: 11.0.23019.0
P6: 5b353f6b
P7: 2b
P8: 0
P9: System.NullReferenceException
P10:

Bifogade filer:
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERA7D2.tmp.dmp
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERAB9C.tmp.WERInternalMetadata.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERABDC.tmp.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERABEB.tmp.csv
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERAC4A.tmp.txt

Filerna kan vara tillgängliga här:
\\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_Microsoft.Dynami_4a488ab667b03db037d6de39e929c1b14ec9ad3_43cbc636_6bdbde95-754b-4393-99f7-59a635a881a2

Analyssymbol:
Kontrollerar lösning igen: 0
Rapport-ID: cfd13f8e-dd9f-41b4-8e9b-5059d6582524
Rapportstatus: 268435456
Hash-bucket: 3190466fd3f44223132461129ba42f89
Cab-GUID: 0

________________


Type: Microsoft.Dynamics.Nav.Types.Exceptions.WatsonReportException
Message: <ii>Watson report failure</ii>
StackTrace:
vid Microsoft.Dynamics.Nav.Watson.WatsonHandler.SendWatsonReport(Exception exception, Boolean showUI, Assembly assembly, String applicationName)
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.HandleWatson(Exception exception, Int32& runCore)
Source: Microsoft.Dynamics.Nav.Watson
HResult: -2146233088

---

Type: System.NullReferenceException
Message: <ii>Objektreferensen har inte angetts till en instans av ett objekt.</ii>
StackTrace:
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindMajorVersion(RegistryKey registryKey)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.<.ctor>b__8_0(RegistryKey regKey)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindRegistryKey(RegistryHive hive, String keyName, Action`1 action)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.FindFirstRegistryKey(String keyName, Action`1 action)
vid Microsoft.Dynamics.Nav.Client.WinClientExcelExportService..ctor(UISession uiSession)
vid Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.<>c.<AddServices>b__22_6(UISession uis)
vid Microsoft.Dynamics.Framework.UI.ClientSessionCore.AddUIService(Func`2 addService)
vid Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.AddServices()
vid Microsoft.Dynamics.Framework.UI.ClientSessionCore.Prepare()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.SetupClientSession()
vid Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.RunCore()
Source: Microsoft.Dynamics.Nav.Client.WinClient
HResult: -2147467261
[/i][/i]


What I've tried:

1) Reinstalled Clickonce and cleaned temp
2) Run the program from appdata/local/apps/2.0/.../.../
3) Added installation site to trusted sites in IE
4) Turn off smartscreen

Any ideas what to try? The problem only occurs for some of those who have updated their Windows (atm 3 ppl).

Kindest regards,
Christopher

Benterettogslett

Hi, I'm experiencing the same after windows update last night. Surface PC, windows 10, have both NAV 2016 Client and BC 14 OnPrem spring client installed. The development environment is working, but not the windows clients. I'm getting the same error as you are reporting. Everything was working fine yesterday.

Hope someone has a solution

Kindest regards,
Bente

Lec11

Hi,

Same issue here.
Windows 11 PRO, 21H2, 22000.434
NAV version: 14.0.29530.0

NAV is does not open at all. Dev environment working fine.
Did you guys find out the root cause for this?

Thanks!

Lec11

Found the reason in the meantime.
Excel key is missing from Registry Editor. Just add it under HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\App Paths.

Benterettogslett

Oh my!! It worked!! Thank you! You just made my day .

I added a app path Excel.exe, and then added at key Path, with the path to my excel.exe.: C:\Program Files (x86)\Microsoft Office\root\Office16\. In the key Standard, I added this: C:\Program Files (x86)\Microsoft Office\root\Office16\Excel.exe.

RockWithNAV

Sometimes changing the computer name/domain impacts the .exe file to execute, I also faced something like this and on connecting string I passed the IP instead of Computer Name.

Martijn

Hi Thx for your help everyone, this post helped us out tremendously.
We've paused windows updates last week, and for some users we added the registry key as a temp fix. But now we're not sure whether we should do this for all users, or await some kind of fix from MS...
Does anyone know why this has changed and if there will be a fix from MS?

christophersvensson

Worked for us also, super thanks!

scottjones@gemmanova.co.uk

Very useful thank you so much! I was just trying to install BC140 on new laptop and windows client was crashing as could not find Excel.

AitorEG

Hi everyone,
Glad to see that you have the same problem as me. Now my problem is that I don't have any idea of how how to add the path, the key, or wathever...
How do I have to do it?

Tomigs

Thanks everyone for the useful tips, it helped us to resolve the issue as well. It remains a mystery to me why this branch is now required all of a sudden after Windows updates, but it works anyways.

@AitorEG , in case it helps, below is what we added on the Regedit:
A new folder Excel.exe, and inside two string registers, (one default and one "Path"), and the value of both containing the path to the Excel exectuable in the computer.