Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Database Syncing Error...
Finance forum
Answered

Database Syncing Errors D365 F&O

Posted on by Microsoft Employee

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:

Error87.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Blue Wang on at
    RE: Database Syncing Errors D365 F&O

    Hi Sachin,

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

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

     5078.Error88.PNG

    Thank you All for the help

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    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 Profile Picture
    Gunjan Bhattachayya 35,417 on at
    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 Profile Picture
    Blue Wang on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans