Dynamics Community Forum Thread Details

How to create Upgrade Codeunit with TableSyncSetup in Business Central?

Hi,

I changed the Primary Key for one of the table in Extension. Now when publish the extension, it will not allow to publish and shows the following error.

SchemaUpdateMode=synchronize failed with code 422. Reason:

Table XYZ :: An unsupported key change was detected. Keys cannot be changed, removed, or reordered. New keys can only be added to the end of the list.

If i modify the SchemaUpdateMode=Recreate, all the data will be erased.

So i want to create the Upgrade Codeunit for the same. So i created the Codeunit with SubType = Upgrade and created a function by name TableSyncSetup.

But now i am unable to set the Property of function to TableSyncSetup and passing the parameter is also not allowed.

Error : "The type or method 'Table Synch. Setup' cannot be used for 'Extension' development"

I have referred the following links.

https://docs.microsoft.com/en-us/dynamics-nav/upgrade-codeunits

Please suggest with your answers.

Thank you.

Categories:

Other

Quick Links