Database Syncing Errors D365 F&O

(1) Share

Report

Posted on by Community Member

hello Experts , i am getting below error while syncing database on Build keeping true. with Rebuilding there is no error so there is nothing wrong with the code. Please advise, i have tried below link few steps of SQL (Link) but not answered .

Error:

I have the same question (0)

All responses (8)

Answers (3)

Blue Wang on at

Like (0)

Report

Hi Sachin,

Form your screenshot, The error come from your field type, have you check that ?

community.dynamics.com/.../synchronize-failed-when-change-field-data-type

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Sachin,

Looks like you are trying to change the data type of LineNumber2 in table ISO_BoardReferenceDetails from int to Real. The field is already present in the SQL database as an int field and the DB synch is unable to convert it to Real.

if you want to make this change and assuming that you have this change only on the Dev environment, you can log into SQL server, go to AXDB database and delete the field LineNumber2 from ISO_BoardReferenceDetails table and perform a DB synchronization again.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can't change the data type of existing fields. Instead you need to drop the old field, sync and add it again.

Especially if the old version of the field already has been deployed to test/prod, you need to handle it properly. You can't deploy your current code to test/prod because the sync will fail.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Gunjan,

Thank you so much for your response, As Advised i have followed the below steps.

1. Deleted or modifying the LineNumber2 Column from SQL and try DB Sync from VS (This Did not work in my case i was getting the same error )

2. Deleted LineNumber2 Field from everywhere in VS and the Rebuild the Solution without DB Sync , Once it was successful i have created LineNumber2 Field again and did DB Sync with Rebuild and it was successful.

The Issue was when i have created this field before i don't know why on SQL side it was created as Int , It should create as same Real type as in VS. Now this time when this field created on SQL side i has created as Real below is the screenshot.

Thank you All for the help

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Sachin,

Please make sure that this field wasn't created before and wasn't deployed to Prod. In that case, you will need to follow the suggestion provided by Nikolaos.

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

Hi Sachin,

You should refer this : robscode.onl/.../

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Gunjan, It might have created before and i was not aware of it. Now everything if fine and no issue while syncing the DB

Thank you so much

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you blue for such a nice blog i bookmarked it and now i have al the story regarding such issues.

Was this reply helpful? Yes No