Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Unable to import solution from On-Premise to Online.

(1) ShareShare
ReportReport
Posted on by 490

 I received following error while solution import. 

FetchXml (<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="businessemailtemplate"><attribute name="name" /><order attribute="name" descending="false" /><filter type="and"><condition attribute="templatetype" operator="in"><value>8</value><value>1</value></condition></filter><attribute name="templatetype" /><attribute name="businessemailtemplateid" /></entity></fetch>) is invalid.  Failure while calculating dependencies for SavedQuery (Id="Guid").

Categories:
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to import solution from On-Premise to Online.

    Hey - so I'm no perfect expert either but I was almost in your exact situation, but you have even fewer users (I got about 35). I got a quote from my MSP on a migration and they came back with something like $4000 including Skykick licensing. I was basically like "Nah" and did a bunch of research on my own. Now, some would say get a partner to buy the licensing through and you will get more help with the migration for free. I bought direct from Microsoft

    I eventually migrated using the native migration that Microsoft offers, using "Outlook Anywhere" to pull all the e-mails over to O365. It also pulled distribution groups, but I had to re-create public folders manually. Not a big deal since we have like 10. Our biggest mailbox had 10gb and migrated just fine. Not sure what your sizes look like.

    For now I have opted to not ADsync, and will look at that again in the future.

    As for our on-prem Exchange server, I buckled and will be paying our MSP to properly decommission it, as there are mixed recommendations as to how to do that to not leave junk in AD. For now it is literally just sitting turned off.

    I currently use MSP mail for filtering, which then passes the e-mail to O365. However, Mimecast gets good reviews around r/sysadmin and if I weren't in a contract with MSP I'd be re-evaluating, because they don't have great syncing options.

    Only "gotcha" I can think of is the internal Outlook clients still got confused and checking for the internal exchange server, even after I wiped the outlook profiles.

  • Suggested answer
    gdas Profile Picture
    gdas 50,089 on at
    RE: Unable to import solution from On-Premise to Online.

    Hi Vishal  ,

    Can you please exclude the view from the solution and export the solution. Try to import new solution again.

  • Suggested answer
    StefanS365 Profile Picture
    StefanS365 3,573 Most Valuable Professional on at
    RE: Unable to import solution from On-Premise to Online.

    The error is related to a view in your solution that is referring to a email template record which unique id (guid) is saved in the view (query). This guid can't be resolved on import in the target org. Be sure you migrate the email template records before importing the solution. You could use a XrmToolBox plugin or Configuration migration tool from the SDK:

    [View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/manage-configuration-data]

  • vishal bagadia_crm Profile Picture
    vishal bagadia_crm 490 on at
    RE: Unable to import solution from On-Premise to Online.

    Hi Stefan,

    My sloution contains all the entities from the source organization(including Email Template). Online Organization(Target organization) also has the Email Template entity by default. 

    Do I need to overwrite the Email template of target organization from the source organization first? and then try the import?

    And also how to change the Views?

    Thanks. 

  • Suggested answer
    StefanS365 Profile Picture
    StefanS365 3,573 Most Valuable Professional on at
    RE: Unable to import solution from On-Premise to Online.

    Hi Vishal,

    You're missing an Email Template in your target organisation. Be sure that you change the view in your solution or migrate the email template to the target organisation.

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 Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans