You’re offline. This is a read only version of the page.
Announcements
Hello all
I just created a cloud host D365FO environment (10.0.26) with Contoso database inside, it works fine I can login D365FO front end and also can RDP to the cloud server.
we also have UAT sandbox backup (bacpac file format) and our own D365FO customization (deployment package) , they both are in LCS assets library.
Now I'd like to refresh the cloud host D365FO environment using the following steps
1. move the bacpac file into the cloud host D365FO environment
2. stop D365 related service
3. Restore bacpac to a new database
4. Switch this new database into AXDB
5. in LCS->Cloud host environment-> Maintain ->Apply Update, then select our customization package
in the step5 , it failed in step 12, DB sync issue. how can I solve this issue?
Hi Simon,
Best way is to first apply your package followed by DB refresh.
Package brings the customized objects(like new fields/tables). Thus restoring db after deployment would make the process smooth.
If it is the other way , these errors are expected as db refresh would not have found your field.
Thanks.
I think I figure out the reason. the database and code package version is not match.
I ma using the Feb DB backup and the latest deployment package which is May.
FMPAYMENTINFORMATION, is it your custom element ?
Don't you think customization should be applied before DB refresh ?
I feel it is DB is conflicting with the existing DB structure and your DB seems to be aligned with new customization.
Hello
I use LCS to deploy the package, not the powershell command
in LCS->Cloud host environment-> Maintain ->Apply Update, then select our customization package
The error like this
05/31/2022 03:46:41: Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'PaymentInformation(15021)' Exception: System.InvalidOperationException: Database execution failed: Invalid object name 'FMPAYMENTINFORMATION'.
CREATE VIEW [DBO].[PAYMENTINFORMATION] AS SELECT T1.ADDRESSID AS ADDRESSID, T1.CCN AS CCN, T1.CUSTOMERID AS CUSTOMERID, T1.CVV AS CVV, T1.EXPIRATIONMONTH AS EXPIRATIONMONTH, T1.EXPIRATIONYEAR AS EXPIRATIONYEAR, T1.NAME AS NAME, T1.STATE AS STATE, T1.ISPRIMARY AS ISPRIMARY, T1.PARTITION AS PARTITION, T1.RECID AS RECID FROM FMPAYMENTINFORMATION T1 ---> System.Data.SqlClient.SqlException: Invalid object name 'FMPAYMENTINFORMATION'.
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
