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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cloud Host environment...
Finance | Project Operations, Human Resources, ...
Answered

Cloud Host environment data and code refresh Error

(0) ShareShare
ReportReport
Posted on by SimonLiu22

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? 

I have the same question (0)
  • babalalex Profile Picture
    babalalex 411 on at

    Can you share the error log exactly ?

    And how are you deploying the package through powershell ?

  • SimonLiu22 Profile Picture
    SimonLiu22 on at

    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'.

  • babalalex Profile Picture
    babalalex 411 on at

    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.

  • SimonLiu22 Profile Picture
    SimonLiu22 on at

    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.

  • Verified answer
    babalalex Profile Picture
    babalalex 411 on at

    You are welcome.

    Please mark the answer as verified if it helped you.

  • AnithaEswaran Profile Picture
    AnithaEswaran 2,032 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans