Ax 2012 sync error - Unable to convert data types to anything but character field type (0 to 4).

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.