Error when updating SDM workshifts

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

The following error appears in the SDM UI when trying to save changes in a SDM workshift:

AHD04199: An unexpected Database error occurred. Contact your administrator.

In the NX_ROOT/log/stdlog:

SQL Execute  failed: [Microsoft SQL Server Native Client 11.0] [ SQL Code=4711 SQL State=42000] Cannot truncate table 'customdb.customtable' because it is published for replication or enabled for Change Data Capture.

Environment

Service Desk Manager 17.4

Supported SQL Server version for 17.4

Resolution

The customdb.customtable is not an OOTB db or table and it's not part of the SDM MDB. The error suggests that there is a constraint or trigger related to the bpwshft table (where the workshifts data is stored) linked to the customdb.customtable.

We recommend to contact the DBA and disable replication/CDC for the customdb.customtable or remove/disable the customizations linked to the bpwshft OOTB table.