Jet Service Tier & Jet Hub were installed in a non AD environment, chose to use basic authentication. Data source is D365 BC.
A few questions:
1. How to upload data sourcing settings to jet hub?
Jet Admin Console was not installed as it requires AD and this environment is not AD ready yet.
2. If users import data source setting XML file directly through Excel add-on, will that be the same as putting the data source file on Hub? Not lots of users so while it's not ideal, it's manageable.
3. Jet Service Tier is behind a firewall. In consideration of potential cloud migration, I still used a FQDN for the server (i.e.: jet.company.com). I manually changed Windows hosts file, such that jet.company.com always points to an internal IP, accessible via VPN.
But the issue is, in Excel's Jet add-on's Settings Location -> Where data source settings are stored -> if choosing Jet Service Tier and Sign in with different Authentication Method, I always got this error
The Jet Hub Url 'https://jet.company.com/' may be incorrect; the following error occurred: Error connecting to https://jet.company.com. An error occurred while sending the request..
I can visit https://jet.company.com/ (when on VPN) and it returns a correct XML file.
I have Excel installed on the server too. On the server, for the same setting ( Sign in with different Authentication Method), I can sign in without error (after clicking the button, a Jet Hub login page shows up).
I thought it was because certain firewall issue. Did a Wireshark capture, but didn't see the error.
Any advice?
Thanks!
I enabled log and the detailed error is:
2023-05-07 22.11.06.217 Thread1 JetTools.WpfWindow_UnhandledException: A Jet Reports error has occurred:
The Jet Hub Url 'https://jet.company.com/' may be incorrect; the following error occurred: Error connecting to https://jet.company.com/identity/.well-known/openid-configuration. An error occurred while sending the request..
Jet.Shared.JetReportsException
at Jet.Services.Client.IdentityServerClient.GetDiscoveryResponse(String jetHubUri)
at Jet.Common.UI.Views.ServiceLoginWindow..ctor(IServiceClientProviderConfigurator configurator)
at Jet.Common.UI.Controls.ServiceConnectionControl.SignInOut()
at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
at System.Windows.Controls.Primitives.ButtonBase.OnClick()
at System.Windows.Controls.Button.OnClick()
at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)