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