Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Migrating CRM 8.2 onprem to CRM 9.0 cloud. Importing old solution causes sql error.

Posted on by Microsoft Employee

Hey everyone,

I have a solution from onprem CRM 8.2. When I try to import the solution into the cloud version of CRM 9.0 I get an SQL error.

I read online that this issue is unpredictable and I wasn't able to find any information to help me successfully import my old solution. I tried to break the main solution into parts

but it causes issues with dependencies. So I want to try and figure out how to get the main solution into the cloud CRM. Any information on how to solve my issue

, how to debug the problem, how to go about this, or anything else would be greatly appreciated.

Screen-Shot-2020_2D00_05_2D00_05-at-10.52.35-PM.png

This is the output from power apps website history when I tried to import the main solution.

Error code
Exception message
Import failed: Object reference not set to an instance of an object.
Total operation time
1 m 23 sec
Patch
No
Managed
No
Overwrite customizations
No

Thank you,

Steven.

PS. Please see the attached log file downloaded when the solution failed.

[View:/cfs-file/__key/communityserver-discussions-components-files/117/importlog_5F00_Main_5F00_1_5F00_1_5F00_0_5F00_0.xml]

  • Suggested answer
    Wei Xiong Profile Picture
    Wei Xiong on at
    RE: Migrating CRM 8.2 onprem to CRM 9.0 cloud. Importing old solution causes sql error.

    Hi,

    This issue should be the recent product issue. Please submit the support ticket to ms support. The engineer will help you to solve this issue. Or you may have to wait MS to release the final fix for this issue.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans