Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

GP On-Prem to BC Online Cloud Migration Setup fails ErrorCode=-2146232060

Posted on by
Hello,
 
I'm migrating a GP on-prem sample database (created using GP Utilities) to Business Central Online using Cloud Migration Setup on BC online.
I'm currently having a Dynamics 365 Business Central for IWs license assigned to my login with SUPER access unrestricted to a company.
 
I've also checked another step-by-step article posted by YUN ZHU https://yzhums.com/6646/ and was unable to proceed beyond Step 14... Working on it.... as per the article.
 
I've checked the troubleshooting steps mentioned in the microsoft article https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migration-troubleshooting but was unable to fix the issue.
Below is the error for your reference. Any help on this is highly appreciated.

 
If requesting support, please provide the following details to help troubleshooting:
Failed to enable your replication. Make sure your integration runtime is successfully connected and try again.
The call to prepare servers failed. Run id='0aa6932e-d1c1-4235-af0e-9315fb068cf5', Name='msft1a6720t09678743_GP_Preparation', ErrorMessage='Operation on target CreateGPCompanyList failed: Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Invalid object name 'SY01500'.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Invalid object name 'SY01500'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=208,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=208,State=1,Message=Invalid object name 'SY01500'.,},],''
Internal session ID: 
eb462b31-61b7-4174-91a1-6c10576e99e4
Application Insights session ID: 
ec109d1e-019b-4e88-a37b-12308e985528
Client activity id: 
062aaa64-fefb-4eb3-a8a6-5493ecf49353
Time stamp on error: 
2023-09-07T10:07:33.8302838Z
AL call stack: 
/Hybrid Deployment/(CodeUnit 6060).RetryGetStatus line 22 - Base Application by Microsoft
/Hybrid Deployment/(CodeUnit 6060).RetryGetStatus line 2 - Base Application by Microsoft
/Hybrid Deployment/(CodeUnit 6060).EnableReplication line 23 - Base Application by Microsoft
/Hybrid Cloud Management/(CodeUnit 4001).EnableReplication line 8 - Intelligent Cloud Base by Microsoft
/Hybrid Cloud Management/(CodeUnit 4001).HandleShowCompanySelectionStep line 8 - Intelligent Cloud Base by Microsoft
/Hybrid Cloud Setup Wizard/(Page 4000).ShowCompanySelectionStep line 5 - Intelligent Cloud Base by Microsoft
/Hybrid Cloud Setup Wizard/(Page 4000).NextStep line 40 - Intelligent Cloud Base by Microsoft
/Hybrid Cloud Setup Wizard/(Page 4000).NextStep line 30 - Intelligent Cloud Base by Microsoft
/Hybrid Cloud Setup Wizard/(Page 4000)./ActionNext - OnAction/(Trigger) line 35 - Intelligent Cloud Base by Microsoft

 
Categories:
  • Suggested answer
    GP On-Prem to BC Online Cloud Migration Setup fails ErrorCode=-2146232060
    I had this same error.
    Just make sure that in the SQL connection string you use the DYNAMICS database instead of the company database.
    Once I changed this it worked perfectly.

    Humberto
  • Yahya Al-Zahabi Profile Picture
    Yahya Al-Zahabi 11 on at
    GP On-Prem to BC Online Cloud Migration Setup fails ErrorCode=-2146232060
    Hi Vamshi,
     
    Were you able to find a solution for this ?
    I am facing the same issue.
     
    Thank you in advance.
    Regards,
     

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans