Enter the key words to find the related topics

D365 database Sync error convention failed from int to Real

Select the effected table for example salestable, one field in changed from int to real.
After changing the filed we may get an errors  cannot convert from int to Real.

Solution:

Go to Data base execute the below queries.

select * from salestable.// Check the data

select * into salestable_copy from salesTable. // This will copy the data from Salestable to salestable_copy

sp_removable salestable  // this will delete the table from entire data base.

select * into salesTable from salestable_copy  //This will copy the data from salestable_copy to Salestable 

Now we can delete the copy table as shown below.
sp_removable salestable_copy

sp_helptext salesTable // For stored procedure query.

No comments:

Post a Comment