How to solve Db synch error

(0) Share

Report

Posted on by Community Member

Hi,

How to solve this error.

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

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.

All responses (10)

Answers (1)

Community Member on at

Like (0)

Report

RE: How to solve Db synch error

Thanks for this gunjan
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

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 on at

Like (0)

Report

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 on at

Like (0)

Report

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 Cal... 294,097 Super User 2025 Season 1 on at

Like (0)

Report

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 35,421 on at

Like (0)

Report
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 on at

Like (0)

Report

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 on at

Like (0)

Report

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 Cal... 294,097 Super User 2025 Season 1 on at

Like (0)

Report

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 35,421 on at

Like (0)

Report

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.