NAV2018 Extensions OnPrem - Same field no.

airamairam Member Posts: 91
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!

Answers

  • Developer101Developer101 Member Posts: 560
    Can you not delete the fields in extensions and redeploy them?
    United Kingdom
  • airamairam Member Posts: 91
    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..
  • Developer101Developer101 Member Posts: 560
    You have to renumber one and forcesync is it,
    United Kingdom
  • airamairam Member Posts: 91
    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?
  • Developer101Developer101 Member Posts: 560
    really forcesync is not available in NAV2018? I think it is
    United Kingdom
Sign In or Register to comment.