CA Service Catalog installation fails when database replication is enabled

Document ID : KB000121448
Last Modified Date : 21/11/2018
Show Technical Document Details
Issue:
Error message when installing CA Service Catalog with database replication enabled:

jdbc.SQLServerException: Cannot complete ALTER TABLE command. Do not execute the command 'ALTER TABLE table_name DISABLE TRIGGER ALL' on a published table. Reissue multiple 'ALTER TABLE table_name DISABLE TRIGGER trigger_name' statements to disable each trigger individually on the given table.

Environment:
CA Service Catalog 17.1
CA Service Catalog 14.1
Cause:
In order to follow the best practices for reporting, an offline reporting environment is created in order to replicate tables between the production and reporting environments. There are specific configurations for Microsoft SQL Server and Oracle, but the issue occurs when the replication is enabled while performing upgrading/customization tasks. Actually the replication works fine when records are added, updated or removed, but it does not work fine when installers start updating tables structure.
Resolution:
Make sure the replication is disabled when upgrading CA Service Catalog. Consider talking to your database administration in order to understand the best way to stop the replication when performing tasks where the tables structure is changed.
Additional Information:
Replicated Database for Offline Reporting