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.

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi gunjan,

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

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

Like (0)

Report
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

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

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'?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for this gunjan

Was this reply helpful? Yes No