If custom fields are not set correctly, it may may cause data loss when migrating to v14 from v13

Situation:
In version13, Custom field Allowance created in Salary Structure Assignment as varchar. User changed mind to use it as value after initial creation. The user removed the Data field and added a Currency field.

On migration from v13 to v14 the database threw error that pymysql.err.DataError: (1265, "Data truncated for column 'allowance' at row 68")

Solution:
Had to update tabSalary Structure Assignment set allowance = 0 where allowance is null;
update tabSalary Structure Assignment set allowance = cast(allowance as decimal(21,9));
delete from tabModule Def where name = ‘HR’;
delete from tabModule Def where name = ‘Payroll’;

And had to install the hrms app on v14 site since it was coming from v13

Hope it helps others.

1 Like

can you please elaborate with a bit more clarity?