Cloud Host environment data and code refresh Error

(0) Share

Report

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)

All responses (6)

Answers (1)

babalalex 411 on at

Like (0)

Report

Can you share the error log exactly ?

And how are you deploying the package through powershell ?

Was this reply helpful? Yes No
SimonLiu22 on at

Like (0)

Report

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

Was this reply helpful? Yes No
babalalex 411 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SimonLiu22 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

babalalex 411 on at

Like (1)

Report

You are welcome.

Please mark the answer as verified if it helped you.

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (1)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Cloud Host environment data and code refresh Error

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Cloud Host environment data and code refresh Error

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates