NAV2018 Extensions OnPrem - Same field no

Business Central/NAV Developers Forum
1

Hello,

I published two extensions for the same table (User Setup) with two separate additional fields, both using the same field number. No errors were initially given, but now, whenever I try to open the User Setup table or any tables related to it, NAV crashes.

I have since renumbered the field numbers in both extensions to ensure they are unique and marked both duplicate fields as ObsoleteState = Removed. However, NAV continues to crash whenever I attempt to access the affected pages or tables. Unfortunately, this issue is occurring in the Production Environment because one of the extensions was not published on the Sandbox, so no errors appeared there.

I am looking at these options

  1. Manually delete the fields from SQL
  2. Change the “schemaUpdateMode” to ForceSync (not sure if all the Extensions data will be lost, if yes, this not an option)

Any help would be much appreciated.

Best Regards!

2

Hi @airam,

Extensions in NAV2018 have a lot of flaws… the ForceSync is not available in NAV2018 (I’m not sure if MS has added it in lasts CU), you can only use “Recreate” but this will delete all the extension data.

When I started with extensions, I had a SQL script to delete all the extension data to avoid problems with breaking changes when I was developing an extension. This is not an option if the extension is already installed in a production environment, unless you can export extension data and import it after the extension is installed again.

I’m sorry if this doesn’t help too much.

3

Thanks a lot for your reply. Yes indeed, I just checked and ForceSync is not available :frowning:

If I delete the fields directly from SQL will this have further repercussions?

Thanks

4

I don’t know, I’ve never removed a field in SQL… copy the DB and test it yourself.