BUG: Stored Procedure has Unresolved References

[jtherrien-accuraty]

Describe the bug

The plugin was installed on an existing DNN 9.13.10 site a few days ago, and ever since when trying to use Evotiva to do a database backup via DACPAC it fails with errors saying that there are a few stored procedures with unresolved references.

Software Versions

• DNN: 09.13.10
• Module: 09.08.00

To Reproduce

Steps to reproduce the behavior:

1. Install the plugin to a DNN site
2. Trigger Evotiva backup to run, and the DACPAC backup errors out each time whether it is scheduled or on-demand.

Expected behavior

DACPAC backup of the database to complete successfully.

Screenshots

If applicable, add screenshots to help explain your problem.

Error log

Note: Debug DLL's
Doesn't appear to be available on the 9.8.0 release

Additional context

Here is what is returned as the error output when running Evotiva:

1. Database (dacpac) backup error details:
   o Validation of the schema model for data package failed.
   Error SQL71501: Error validating element [dbo].[activeforums_Tags_Search]: Procedure: [dbo].[activeforums_Tags_Search] has an unresolved reference to object [dbo].[activeforums_Tags].[IsCategory].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Save]: Procedure: [dbo].[activeforums_UserProfiles_Save] has an unresolved reference to object [dbo].[activeforums_UserProfiles].[Avatar].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Save]: Procedure: [dbo].[activeforums_UserProfiles_Save] has an unresolved reference to object [dbo].[activeforums_UserProfiles].[AvatarType].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Get]: Procedure: [dbo].[activeforums_UserProfiles_Get] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[Avatar], [dbo].[activeforums_UserProfiles].[P] or [dbo].[Users].[P].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Get]: Procedure: [dbo].[activeforums_UserProfiles_Get] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[AvatarType], [dbo].[activeforums_UserProfiles].[P] or [dbo].[Users].[P].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanBlock].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModApprove].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModLock].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModUser].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModDelete].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModSplit].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModPin].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModEdit].
   Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModMove].
   Error SQL71501: Error validating element [dbo].[activeforums_Forums_Maintenance]: Procedure: [dbo].[activeforums_Forums_Maintenance] has an unresolved reference to object [dbo].[activeforums_Forums].[LastPostId].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[Avatar], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[Avatar], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[AvatarType], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
   Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[AvatarType], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
2. Error SQL71501: Error validating element [dbo].[activeforums_Tags_Search]: Procedure: [dbo].[activeforums_Tags_Search] has an unresolved reference to object [dbo].[activeforums_Tags].[IsCategory].
3. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Save]: Procedure: [dbo].[activeforums_UserProfiles_Save] has an unresolved reference to object [dbo].[activeforums_UserProfiles].[Avatar].
4. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Save]: Procedure: [dbo].[activeforums_UserProfiles_Save] has an unresolved reference to object [dbo].[activeforums_UserProfiles].[AvatarType].
5. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Get]: Procedure: [dbo].[activeforums_UserProfiles_Get] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[Avatar], [dbo].[activeforums_UserProfiles].[P] or [dbo].[Users].[P].
6. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_Get]: Procedure: [dbo].[activeforums_UserProfiles_Get] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[AvatarType], [dbo].[activeforums_UserProfiles].[P] or [dbo].[Users].[P].
7. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanBlock].
8. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModApprove].
9. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModLock].
10. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModUser].
11. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModDelete].
12. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModSplit].
13. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModPin].
14. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModEdit].
15. Error SQL71501: Error validating element [dbo].[activeforums_Permission_Create]: Procedure: [dbo].[activeforums_Permission_Create] has an unresolved reference to object [dbo].[activeforums_Permissions].[CanModMove].
16. Error SQL71501: Error validating element [dbo].[activeforums_Forums_Maintenance]: Procedure: [dbo].[activeforums_Forums_Maintenance] has an unresolved reference to object [dbo].[activeforums_Forums].[LastPostId].
17. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[Avatar], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
18. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[Avatar], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
19. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[AvatarType], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].
20. Error SQL71501: Error validating element [dbo].[activeforums_UserProfiles_List]: Procedure: [dbo].[activeforums_UserProfiles_List] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[activeforums_UserProfiles].[AvatarType], [dbo].[activeforums_UserProfiles].[P], [dbo].[UserPortals].[P] or [dbo].[Users].[P].

[johnhenley]

@jtherrien-accuraty With the exception of activeforums_Forums_Maintenance, the other procedures are all obsolete and no longer used. In next release (v10), they are being removed and activeforums_Forums_Maintenance is getting corrected. activeforums_UserProfiles_List is not used anymore but is not being removed until the user control that requires it is also removed, so activeforums_UserProfiles_List is also getting corrected.

To get past this, you can

DROP PROCEDURE activeforums_Tags_Search
DROP PROCEDURE activeforums_Permission_Create
DROP PROCEDURE activeforums_Tags_Search

then replace activeforums_Forums_Maintenance and activeforums_UserProfiles_List with these:

• activeforums_UserProfiles_List.txt
• activeforums_Forums_Maintenance.txt