SQL Code=20092 when starting up CA Service Desk

Document ID : KB000121509
Last Modified Date : 26/11/2018
Show Technical Document Details
Issue:
Error message when starting up CA Service Desk:

bpvirtdb_srvr 1216 ERROR vdbmisc.c 688 Miscellaneous Database error occured :[Microsoft SQL Server Native Client 11.0] [ SQL Code=20092 SQL State=42000] Table '[dbo].[usp_session_ext]' into which you are trying to insert, update, or delete data is currently being upgraded or initialized for merge replication. On the publisher data modifications are disallowed until the upgrade completes and snapshot has successfully run. On subscriber data modifications are disallowed until the upgrade completes or the initial snapshot has been successfully applied and it has synchronized with the publisher.

It happens in the SDM reporting server.
Environment:
CA Service Desk 17.1
CA Service Desk 17.0
CA Service Desk 14.1
Cause:
This issue happens when there is something missing in the database replication process. As a best practice, customers use to create a SDM reporting server in order to not overload the production environment with heavy queries or reports. If a customization is put in place or if there is an upgrade for any reason, the database replication is disabled in order to avoid conflict between the production and the reporting database. If something goes wrong when re-enabling the database replication, CA Service Desk starts having problems when starting up its services.
Resolution:
Consider talking to your database team in order to review the database replication. There are clear procedures in the CA Service Desk documentation which can help you on enabling the database replication.
Additional Information:
Replicated Database for Offline Reporting