I'm currently upgrading a NAV2015 database to NAV2017, build 10.0.14199.
The database has many custom Stored Procedures and views. During the Sync-NavTenant, after I imported the NAV2017 objectset with customizations, it couldn't compile one of the objects (Item table) due to a dependency error: 'Object xxxItem' cannot be renamed because the object participates in enforced dependencies.'
I basically had to delete all related StoredProcedures,Views and functions before I actually could compile the object.
This is obviously not something I'm waiting for in an upgrade. Is there a way to overcome this problem or does anyone else has similar experiences?
0
Comments
You can run this SQL script to find the dependencies
In general you do not need to delete the objects you only need to remove dependency.
Be aware that by "enforced dependencies", it means Schema binding, so you'll have to look specifically for that.
I hope this helps.
I ran the query successfully but it didn't show anything. However when I go to the Item table->right mouse click->Dependencies, I'm getting a list of views, stored procedures with dependencies.
How would I run your query specifically for the Item table?
or you can run it for all objects in the database