web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
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:
I have the same question (0)
  • Yahya Al-Zahabi Profile Picture
    13 on at
    Hi Vamshi,
     
    Were you able to find a solution for this ?
    I am facing the same issue.
     
    Thank you in advance.
    Regards,
     
  • Suggested answer
    Workflow Approvals Profile Picture
    2 on at
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans