Troubleshooting Illegal data conversion from original field synchronization Errors Dynamics AX 2012
Recently, I encountered this synchronization error in AX 2012
Error:
I got this error on opening Customer form after I did a update of my local AX with a copy from UAT AX.
Error:
Illegal data conversion from original field CustTable.ServiceRegionsDN to CustTable.ServiceOrderDN: unable to convert data types to anything but character field type (14 to 49)
Note: ServiceRegionsDN and ServiceOrderDN are custom VAR fields.
Solution:
Note - Please be careful while doing any SQL update from database. I did this in my local sandbox, Not recommended to do it in Production AX.
Check the field id in AOT and compare it with SQLDictionary table in SQL with the following query
select * from sqldictionary where TABLEID in (select TABLEID from sqldictionary where name = 'CustTable')
and name = 'ServiceRegionsDN '
Update SQLDictoniary table with the correct fieldid
update SQLDICTIONARY set fieldid = 60080 where TABLEID in
(select TABLEID from sqldictionary where name = 'CustTable'
)
and name = 'ServiceRegionsDN '
Reference - https://blogs.msdn.microsoft.com/axsupport/2012/09/19/troubleshooting-aot-synchronization-errors/
与本文相关的文章
- D365 FO提示–如何使用Azure REST元数据API检索Tier 2沙箱VM大小和其他详细信息 / D365 FO Tips – How To retrieve Tier 2 Sandbox VM Size and other details using Azure REST Metadata API
- How to Install Dynamics 365 for Finance and Operations Platform Update on a Disconnected Local Developer VM
- The new wiki or documentation link for Microsoft dynamics 365 for Operations
- Dynamics 365 for Operations Platform Update 6
- How to get to the LCS Downloadable Tools Page
- Dynamics 365 for Operations Tip – Mobile workspaces option missing under System Administration