After Restoring the data from Live Environment to the Test Environment When I synchronize the Data Dictionary after that I got the following error message.
Illegal data conversion from original field IPBCLIENTSESSION.CLIENTCOMPUTER to CRTFERTORDERTABLE.FertSupplier: Unable to convert data types to anything but character field type (0 to 4).
In Dynamics AX Environment I check the id of the table i.e CRTFERTORDERTABLE and id of the field i.e FertSupplier
The id of table CRTFERTORDERTABLE is 30379
id of the field FertSupplier is 30002.
Than in Sql server I write the following query:
SELECT TABLEID,FIELDID,NAME from SQLDICTIONARY
where TABLEID = 30379 and (FIELDID = 30002)
After running the query the result that I got is:
in the above image we can see that field CLIENTCOMPUTER contains the id 30002 while in AX Field ID 30002 belongs to FERTSUPPLIER
now I will update the SQLDICTIONARY table and set the CLIENTCOMPUTER ID to new id to remove the conflict.
below is the query to update the table
update SQLDICTIONARY set FIELDID = 300020
where TABLEID = 30379 and FIELDID = 30002
Now after running this I will again synchronize the table in Dynamics AX and after the synchronization the error will not arrive.
Thanks
Muhammad Zahid.
Illegal data conversion from original field IPBCLIENTSESSION.CLIENTCOMPUTER to CRTFERTORDERTABLE.FertSupplier: Unable to convert data types to anything but character field type (0 to 4).
In Dynamics AX Environment I check the id of the table i.e CRTFERTORDERTABLE and id of the field i.e FertSupplier
The id of table CRTFERTORDERTABLE is 30379
id of the field FertSupplier is 30002.
Than in Sql server I write the following query:
SELECT TABLEID,FIELDID,NAME from SQLDICTIONARY
where TABLEID = 30379 and (FIELDID = 30002)
After running the query the result that I got is:
in the above image we can see that field CLIENTCOMPUTER contains the id 30002 while in AX Field ID 30002 belongs to FERTSUPPLIER
now I will update the SQLDICTIONARY table and set the CLIENTCOMPUTER ID to new id to remove the conflict.
below is the query to update the table
update SQLDICTIONARY set FIELDID = 300020
where TABLEID = 30379 and FIELDID = 30002
Now after running this I will again synchronize the table in Dynamics AX and after the synchronization the error will not arrive.
Thanks
Muhammad Zahid.
Thanks and Impressive Article. Outsourcing Data Conversion requirements of many a business has proven to be vital and wise decision. It helps them to function effectively and save a considerable amount of time and money. IT Outsourcing Services offer to convert your data into a powerful management resource. However difficult, complex or voluminous be your data conversion project, we will get it completed quickly and cost effectively. With the support of experienced team of Data Conversion professionals and state-of-the-art technology, we can obtain data from virtually any media source or file and convert it into usable formats. Our experience and capability to provide the complete Data Conversion solutions make us leaders in the industry.
ReplyDeleteThank you
ReplyDelete