Views:

Applies to Product – Dynamics 365 Lifecycle Services


What’s happening?
Customers are experiencing issues with the Excel Add-On in Microsoft Dynamics, receiving error messages related to "HTTP request" or "Request from user to call administrator."
 

Reason:

  • The error may occur due to a custom data entity having a field that does not extend an EDT (Extended Data Type).
  • Issues with ADFS (Active Directory Federation Services) configuration, such as using capital letters in the ADFS redirect settings.
  • The API owner may need to change settings to allow Power Automate to parse the input correctly.
  • The local agent configuration may not be set correctly, affecting the functionality of the add-on.

 

Resolution:

  1. For Custom Data Entity Issues:
  2. Ensure that all fields in the custom data entity extend an EDT. If not, modify the entity accordingly.
  3. For ADFS Configuration:
  4. Run the ADFS test configuration script to verify settings. Ensure that capital letters are not used in the ADFS redirect.
  5. Restart the ADFS service after making any changes.
  6. For API Parsing Issues:
  7. The API owner should adjust the settings to enable Power Automate to parse the input correctly.
  8. For Local Agent Configuration:
  9. Uninstall the Local Agent using the command: .\LocalAgentCLI.exe.
  10. Clean up the configuration file: .\localagent-config.json.
  11. Change the local agent configuration to set the Office365AdfsCompatibility to false.
  12. Reinstall the Local Agent.
  13. Perform servicing in LCS (Lifecycle Services) by maintaining, updating settings, preparing, and updating.
  14. If issues persist, run the following command against the AXDB to straighten the Admin user and restart all AOS: Import-Module <ModulePath> -DatabaseServer '<FQDN of the SQL server>' -DatabaseName '<AX database name>'
  15. If the Issue Persists:
  16. If the problem continues after following the above steps, it may be necessary to contact the support team for further assistance.