Hello Business Central community!
I've recently attempted adding the Excel Add-in to multiple server instances in on-prem v21.0.53597.53794 and came across an error I'd never seen in the multiple installations I've done. Even after following the setup guide multiple times.
The issue is: any time we select "Edit in Excel" everything appears normal but then when signing into the Add-in, it will either freeze Excel completely or throw this error:
Error Loading Metadata
Details:
Please check server connection, verify the current user has proper access, and try again. Error message: ''
I've verified every user we've attempted this with is configured with their appropriate AAD login in the Authentication Email field of their user record. All OData settings look correct with SSL set to true where it needs to be.
What we see in the event log is the same three messages thrown a few times:
Event Log 1
Server instance: <Redacted> Category: Security ClientSessionId: 00000000-0000-0000-0000-000000000000 ClientActivityId: 00000000-0000-0000-0000-000000000000 ServerSessionUniqueId: 00000000-0000-0000-0000-000000000000 ServerActivityId: f293f26e-d309-461f-a74f-acff3c44c8db EventTime: 05/25/2023 15:27:57 Message No user authentication object was created from authorization value. ProcessId: 11920 Tag: 00001KM ThreadId: 3 CounterInformation: CustomParameters: { } GatewayCorrelationId: |
Event Log 2
Server instance: <Redacted> Tenant ID: Environment Name: Environment Type: The received security token could be validated but does not give access to Dynamics 365 Business Central. Token Details : Issuer: login.microsoftonline.com/.../v2.0 Expiry (UTC): 05/26/2023 04:31:58 TenantId: <Redacted> Version: 2.0 |
Event Log 3
Server instance: <Redacted> Category: Security ClientSessionId: 00000000-0000-0000-0000-000000000000 ClientActivityId: 00000000-0000-0000-0000-000000000000 ServerSessionUniqueId: ad09043a-fdf3-4cb9-a370-53e5c004797b ServerActivityId: 1ffbd60a-a1d2-481b-a42a-1802fce89803 EventTime: 05/25/2023 15:27:57 Message A security token was received that is associated with an unknown or disabled user account in Business Central. ProcessId: 11920 Tag: 00009QY ThreadId: 3 CounterInformation: CustomParameters: { } GatewayCorrelationId: |
The third of which is very strange since the user records all line up appropriately.
Anyone have any ideas out there?