NAV2018 Extensions OnPrem - Same field no.

airam

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!

Developer101

Can you not delete the fields in extensions and redeploy them?

airam

thanks for your reply, however even with both fields deployed, NAV is crashing because they both have the same Field No. (in separate extensions), can't renumber as it gives an error..

Developer101

You have to renumber one and forcesync is it,

airam

unfortunately ForceSync is not available in NAV2018, so the only solution I am seeing at this stage is to remove the fields directly from SQL. anyone tried this already please?

Developer101

really forcesync is not available in NAV2018? I think it is