The error "'Service failure, The Resource <path> does not exist" may occur when attempting to modify a resource's dependency. This happens if the resource contains objects from other resources that were deleted. These deleted resources likely originated from tables with foreign keys to other tables or resources that have also been deleted.

When you delete a user's 'Home' folder, any resources created under it are also deleted. This includes the resources that other dependent resources rely on. As a result, attempts to execute these dependent resources will fail, showing the error 'Service failure, The Resource <path> does not exist'.

To address this issue, remove all the foreign keys that are associated with these non-existing tables by opening that dependent data source -> foreign key in TDV Studio.

These foreign keys even though they do not exist in reality, do not impact the performance of the resource but hold some relation between the removed dependents which is leading to this issue which is expected. Once these foreign keys (which do not exist in reality) are cleared, the edit dependency error on the web manager for this resource should get resolved as well.

Important Note: It is recommended that /My Home and /Shared folders be used only for development purposes. This is because resources created in the "my home" will be deleted if the user is deleted from TDV. To avoid any  issues, It is highly recommended that the user(s):

• Do not copy or create resources that you want to publish in the Home directory
• Do not use the resources from the 'users' folder
• Do not use these resources in foreign keys.