Tuesday, September 9, 2014

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.

1 comment:

  1. I just found this blog and have high hopes for it to continue. Keep up the great work, its hard to find good ones. I have added to my favorites. Thank You.
    check my blog

    ReplyDelete