Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 324 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Error in cloud migration when defining SQL database connection
apquintas
Member Posts: 5
We would like to know the reason of getting this error sometimes in the 1st steps of the Cloud Migration Setup
,when trying to establish connection to origin DB, after providing the SQL Connection String and the Integration Runtime Name.
It seems to be completely random and related to the failure of some cloud resources, but we don't know. We get the error for a few hours and then (or the next day) it works... or not.
This unpredictability is very dangerous specially in the case of a Production related cloud migration.
Images
1 - Step: Define SQL database connection
2 - ERROR: Failed to prepare the systems for replication. The call to prepare servers failed. Run id='6a38640f-503a-423e-9508-d81a137565fe', Name='msweuaxxxxtxxxxxxxx_BC_Preparation', ErrorMessage='Operation on target NotifyBusinessCentral failed: Invoking endpoint failed with HttpStatusCode - '401 : Unauthorized', message - 'Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url).''
Error Details:
If requesting support, please provide the following details to help troubleshooting:
Error message:
Failed to prepare the systems for replication.
The call to prepare servers failed. Run id='0e6bf361-45e2-40d7-b4cd-a4ba747a8502', Name='msweuaxxxxtxxxxxxxx_BC_Preparation', ErrorMessage='Operation on target NotifyBusinessCentral failed: Invoking endpoint failed with HttpStatusCode - '401 : Unauthorized', message - 'Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url).''
Internal session ID:
62ab6560-bdea-47d0-9df1-ef5675b5e1fc
Application Insights session ID:
43e9d737-a2b9-4a52-a16a-d017913b955e
Client activity id:
62184e72-64b6-43f5-a1ad-651011cd1739
Time stamp on error:
2025-03-27T07:47:30.8257598Z
User telemetry id:
6f63730f-2a2d-4a88-9f4b-0206fd7c6bb3
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
We would really appreciate if someone could give us some input to help us understand this error
,when trying to establish connection to origin DB, after providing the SQL Connection String and the Integration Runtime Name.
It seems to be completely random and related to the failure of some cloud resources, but we don't know. We get the error for a few hours and then (or the next day) it works... or not.
This unpredictability is very dangerous specially in the case of a Production related cloud migration.
Images
1 - Step: Define SQL database connection
2 - ERROR: Failed to prepare the systems for replication. The call to prepare servers failed. Run id='6a38640f-503a-423e-9508-d81a137565fe', Name='msweuaxxxxtxxxxxxxx_BC_Preparation', ErrorMessage='Operation on target NotifyBusinessCentral failed: Invoking endpoint failed with HttpStatusCode - '401 : Unauthorized', message - 'Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url).''
Error Details:
If requesting support, please provide the following details to help troubleshooting:
Error message:
Failed to prepare the systems for replication.
The call to prepare servers failed. Run id='0e6bf361-45e2-40d7-b4cd-a4ba747a8502', Name='msweuaxxxxtxxxxxxxx_BC_Preparation', ErrorMessage='Operation on target NotifyBusinessCentral failed: Invoking endpoint failed with HttpStatusCode - '401 : Unauthorized', message - 'Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url).''
Internal session ID:
62ab6560-bdea-47d0-9df1-ef5675b5e1fc
Application Insights session ID:
43e9d737-a2b9-4a52-a16a-d017913b955e
Client activity id:
62184e72-64b6-43f5-a1ad-651011cd1739
Time stamp on error:
2025-03-27T07:47:30.8257598Z
User telemetry id:
6f63730f-2a2d-4a88-9f4b-0206fd7c6bb3
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
We would really appreciate if someone could give us some input to help us understand this error
0
Answers
Revoke and Grant again delegated admin consent for cloud migration.