I've been facing an issue with a Master Data Services (MDS) derived hierarchies. At first the hierarchy worked fine but after some time (do not know how long) I am not able to load the MDS data via Excel with MDS 2019 Add-in. I am receiving an error "Exception from HRESULT: 0x800A03EC". If an attribute which is filtered by the derived hierarchy is excluded from the load, the data is loaded just fine.
I believe that that the issue will not be related to MDS since it's working fine via Web Application. Moreover, two of my colleagues does not have this issue.
Results from tracing:
MDS Warning and Error tracing on the server:
11/11/2021 16:42:18,00000000-0000-0000-0000-000000000000,Unknown,Start,"Service started successfully, Assembly version: 18.104.22.168, file version: 15.0.4178.1"
11/11/2021 16:42:18,00000000-0000-0000-0000-000000000000,Unknown,Error,"ApiContractVersion: 8000"
Excel Add-in MDS log:
Attached in txt file.
Microsoft SQL Server 2019 MDS Add-in for Excel 15.0.2000.5
Microsoft® Excel® for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20234) 64-bit
MDS database located on Microsoft SQL Server 2016 (SP2-CU17) (KB5001092) - 13.0.5888.11 (X64) Enterprise - Server A
MDS 2019 service - Server B
I also tried to reinstall the whole Office 365 and MDS Add-in for Excel but the issue still persists. I've also compare app versions with my colleagues and the versions are the same. I would be grateful for your opinion and potential solution.