Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

How to solve Db synch error

Posted on by Microsoft Employee

Hi, 

How to solve this error.

when I created new field in Exchangeratecurrencypair table and try to table synch, showing this error

error156.PNG

So, I delete a newly created field but again showing this error, while attempt to synch. How to clear this.

I tried clear the cache, aos service restart, refresh database, incremental cil, full cil, db synch but again showing this error while table synch.

How to solve this, Give some ideas.

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to solve Db synch error

    Thanks for this gunjan

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: How to solve Db synch error

    Hi Ashokkumar,

    Yes. Please try deleting that record and try synchronizing again, assuming this is a Dev environment. This is not something you should do on higher environments.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to solve Db synch error

    Hi gunjan, thanks for this, that field has in sql dictionary. What I do, shall remove the record

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to solve Db synch error

    Hi Andre, thanks for this, I already deleted that field and done full cil, dB synch also but again showing above mentioned issue

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: How to solve Db synch error

    Hi Ashokkumar,

    'Select' is a keyword for SQL. Can you try to rename the field to e.g. 'IsSelected' or add text for a purpose like 'SelectRate'?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: How to solve Db synch error

    Hi Ashokkumar,

    Please check if the field somehow exists in the SQLDictionary table. You can run this query to check.

    select * from SQLDICTIONARY where TableId = 6883

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to solve Db synch error

    Hi Andre,

    Thanks for this, I did create field name 'select' that's why this happening but now I removed that field, but again showing same error above mentioned how to solve this

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to solve Db synch error

    Hi gunjan,

    Thanks for this, I deleted field in sql server again attempt dB synch but Same error

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: How to solve Db synch error

    Hi Ashokkumar,

    What exact field did you add to this table? Did you also delete a field as it is failing on dropping a certain column?

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: How to solve Db synch error

    Hi Ashokkumar,

    Please check the table in SQL server database and if the newly created field exists there. If so, try deleting the field and try synchronizing again.

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,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans