Hi Dana,
Yes I'm using MS-CDC in source database for Qlik replicate.
Qlik replicate version is 2022.5.0.499 and Qlik Enterprise manger version is 2021.11.0.151.
The below is complete error code :
Stream component 'st_0_PROD M2C ISU' terminated
Stream component failed at subtask 0, component st_0_PROD M2C ISU
Error executing command
Failed to create DDL events trigger
RetCode: SQL_ERROR SqlState: 42S01 NativeError: 2714 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'attrep_mscdc_ddl_catcher' in the database. Line: 1 Column: -1
Failed (retcode -1) to execute statement: '
CREATE TRIGGER [attrep_mscdc_ddl_catcher]
ON DATABASE
FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE
AS
BEGIN
SET NOCOUNT ON;
declare @x XML
declare @ddlOperation varchar(32)
declare @schemaName nvarchar(128)
declare @tableName nvarchar(128)
declare @loginName varchar(64)
declare @Username varchar(64)
declare @eventTime varchar(32)
declare @orgT varchar(256)
declare @cdcT varchar(256)
declare @orgObjId integer
declare @cdcObjId integer
set @x = EVENTDATA();
set @ddlOperation = @x.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(32)')
set @schemaName = @x.value(N'(/EVENT_INSTANCE/SchemaName)[1]', 'nvarchar(128)')
set @tableName = @x.value(N'(/EVENT_INSTANCE/ObjectName)[1]', 'nvarchar(128)')
set @loginName = @x.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(64)')
set @Username = @x.value('(/EVENT_INSTANCE/UserName)[1]', 'varchar(64)')
set @eventTime = @x.value('(/EVENT_INSTANCE/PostTime)[1]', 'varchar(32)')
set @orgT = @schemaName+'.' + @tableName
set @cdcT = 'cdc.' + @schemaName+'_' + @tableName+'_CT';
set @orgObjId = OBJECT_ID(@orgT,N'U')
if @orgObjId is null
set @orgObjId = 0;
set @cdcObjId = OBJECT_ID(@cdcT,N'U')
if @cdcObjId is null
set @cdcObjId = 0;
INSERT INTO [dbo].[attrep_mscdc_ddl_history]
([ddlOperation], [schemaName], [tableName], [loginName], [userName], [eventTime], [orgObjId], [cdcObjId])
VALUES
(@ddlOperation,@schemaName,@tableName,@loginName,@userName,@eventTime,@orgObjId,@cdcObjId)
delete from [dbo].[attrep_mscdc_ddl_history] where ddlId = (select max(ddlId) from [dbo].[attrep_mscdc_ddl_history])
END;
'
I have opened new thread https://community.qlik.com/t5/Qlik-Replicate/Stream-component-failed-at-subtask-and-Failed-to-create...
