Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Excel Add-in Not Working in BC On-Prem 21.0.53597.53794

Posted on by 5

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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans