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.
Thanks for this gunjan
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.
Hi gunjan, thanks for this, that field has in sql dictionary. What I do, shall remove the record
Hi Andre, thanks for this, I already deleted that field and done full cil, dB synch also but again showing above mentioned issue
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'?
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
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
Hi gunjan,
Thanks for this, I deleted field in sql server again attempt dB synch but Same 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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (