Hi Experts.
I was refer to below URL and conducted my DB Synch error issue but i wonder if it needs to delete TABLEIDTAVLE and TABLEFIELDTABLE like deleting relevant data in SQLDICTIONARY.
https://robscode.onl/d365-db-sync-changed-data-type-on-field/
https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/376489/sqldictionary-table-in-d365fo
By the way. I was aware of field count of SQLDICTIONARY abd TABLEFIELDIDTABLE selcted.
Otherwise. About DB synch error. May i igore TABLEIDTABLE and TABLEFIELDTABLE deleting?
Best regards
Hi Sergei,
Thank you for your kind support and I got it.
Hi Nikolaos,
I got it and Thank you very much for your kind support.
You are my hero!!
You are making a document to handle what error?
If you have some error because you have changed a data type of a field, the correct process is to not do that! Your document needs to contain only that information.
You can't deploy such package to UAT or Prod where data type of an existing field is changed. So you should never develop such changes. And therefore you don't need to manipulate SQLDictionary or the other related tables.
Hi Sergei.
Now I am making a document to handle the error but Afrer knowing the iformation of TABLEIDTABLE and TABLEFIELDIDTABLE in D365FO.
O.k I wanted to ask whether above its need to fix the error or not.
Sorry for not enough to explain about my post.
Hi Namkamura,
Could you, please, explain what are you trying to fix and how you get into this situation? Even if you fix something in dev with this approach you will get the same issue later in sandbox and Prod.
Thanks a lot So What do you think below query on the page ?
At least I thnk it is not enough to regaring DB Synch error as soolution Thus.I thnk It must be delete datas of TABLEIDTABLE and TABLEFIELDIDTABLE.
robscode.onl/.../
Sorry for my typos.
I think it's better if you don't try to tamper with SQLDictionary or TableFieldIdTable, you could just break things.
If you can share more background for your question (=how you ended up in a situation where you need to ask your question, and all details about your situation) we could help you find the best solution for your problem.
The relations are:
TableIdTable.Id = SqlDictionary.TableId
TABLEFIELDIDTABLE.Id = SqlDictionary.FieldId and TABLEFIELDIDTABLE.TableId = sqlDictionary.TableId
Thank you your swift response but Actually i wanna know relations and how touse between SQLDITIONARY and tableidtable . Tablefieldtable.
Would please let me know above mentioned objects?
Warm regards
Did you change field type on the table? If yes, recommended way is not to change type of existing field, but create new one and write upgrade SQL script to copy data from old field to new field. When you try to deploy the type change in Prod most likely it will fail and you will be asked to fix the package.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,206
André Arnaud de Cal... 847 Super User 2025 Season 2
Sohaib Cheema 596 User Group Leader
