Sproc_CreateMetaForAllSetup Stored Procedure – Upgrade Issues
In upgraded CampusNexus CRM environments, administrators may encounter scenarios where new out-of-the-box entities such as objects, tabs, groups, properties or relationships are not created. Administrators must view upgrade setup logs to identify a list of these missing entities.
Onsite administrators and CampusNexus CRM support staff (including Hosting and Professional Services) and are encouraged to run the stored procedure as a first step to resolve such upgrade issues.
Resolution
Administrators must run the sproc_CreateMetaForAllSetup stored procedure on the Main database computer; it identifies and creates the missing information.
While the stored procedure is not designed to resolve all upgrade issues, it attempts to create the missing entities. If a missing entity fails to be created again, the stored procedure returns a reason that describes the failure.
Before running the stored procedure, administrators must ensure that:
-
Database replication is complete
-
The SQL Server agent service is stopped on the subscriber and Main database computers