Learn the impact of the subscription comparison procedure on classes and system tables and how to bring the RSSDs to a consistent state.
The system-provided function-string classes and error class do not initially have a designated primary site, that is, their site ID equals 0. The classes rs_default_function_class and rs_db2_function_class cannot be modified, and thus can never have a designated primary site. The classes rs_sqlserver_function_class and rs_sqlserver_error_class may be assigned a primary site and modified. The primary site of a derived function-string class is the same as its parent class.
If the recovering Replication Server was made the primary site for a function-string class or error class since the last transaction dump, the rs_subcmp procedure finds orphaned rows in downstream RSSDs.
In that event, run rs_subcmp again on the rs_classes, rs_erroractions, rs_funcstrings, and rs_systext system tables. Set prsid = 0 in order to repopulate these tables with the necessary default settings.
select * from rs_classes where prsid = 0 order by primary_keys