Database Syncing Errors D365 F&O

(0) 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:

All responses (8)

Answers (3)

Community Member on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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
Verified answer

Blue Wang on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

Hi Sachin,

You should refer this : robscode.onl/.../
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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.
Community Member on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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
Verified answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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.
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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.
Blue Wang on at

Like (0)

Report

RE: Database Syncing Errors D365 F&O

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