Ax 2012 sync error:
After upgrading the Ax 2012 i got the below error in sync the database.
Illegal data conversion from original field LEDGERJOURNALNAME.VOUCHERALLOCATEDATPOSTING to LEDGERJOURNALNAME.VoucherAllocatedAtPosting: Unable to convert data types to anything but character field type (0 to 4).
the only way i found to solve it was:
1- Backup the original table using:
SELECT * INTO newtable [IN externaldb] FROM table1;
2- Delete the original tables.
3- Sync database to recreate the tables.
4- Compare columns between the two tables.
you can use: https://www.diffchecker.com/
5- reinsert the data from the backup table into the original one.
6- re-sync the database didn't issue any error.
