Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ramu123
Contributor III
Contributor III

Qlik replicate -UI server not working error code-SYS,GENERAL_EXCEPTION,The requested security protocol is not supported.

Hi Team,

 

We are unable to access Qlik replicate UI and services are running good-the error code is "SYS,GENERAL_EXCEPTION,The requested security protocol is not supported."

 

Thanks

Ramu

Labels (1)
2 Solutions

Accepted Solutions
john_wang
Support
Support

Hello @ramu123 ,

Thanks for reaching out.

In general this error was caused by .Net Framework missing , or lower version. Replicate requires .NET Framework 4.8 or later.

You may check your .Net Framework version by DOS command:

reg query "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\full" /v version

Typical results:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\full
    version    REG_SZ    4.8.09037

All versions .Net Framework can be found in dotnet.microsoft.com.

Feel free to let us know if it works.

Regards,

John.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

john_wang
Support
Support

Glad to hear that @ramu123 , please click "Accept as Solution" if possible.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

17 Replies
john_wang
Support
Support

Hello @ramu123 ,

Thanks for reaching out.

In general this error was caused by .Net Framework missing , or lower version. Replicate requires .NET Framework 4.8 or later.

You may check your .Net Framework version by DOS command:

reg query "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\full" /v version

Typical results:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\full
    version    REG_SZ    4.8.09037

All versions .Net Framework can be found in dotnet.microsoft.com.

Feel free to let us know if it works.

Regards,

John.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
ramu123
Contributor III
Contributor III
Author

Hi John,

Thank you for your advice and I updated to .net frame work to 7.8 and its working perfectly .

 

Thanks

Ramu

ramu123
Contributor III
Contributor III
Author

Hi John,

Thank you for your advice and I updated to .net frame work to 4.8 and its working perfectly .

 

Thanks

Ramu

john_wang
Support
Support

Glad to hear that @ramu123 , please click "Accept as Solution" if possible.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
ramu123
Contributor III
Contributor III
Author

Hi John,

Below error message I have received for log stream. 

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.

But Could not find in target database with this name ' 'attrep_mscdc_ddl_catcher'.

Could you please suggest what could be reason, where to check? is this error related source database or target database?

is there any impact?

Thanks

Ramu

Dana_Baldwin
Support
Support

Hi @ramu123 

Are you using MS-CDC source?

Which version of Replicate are you running?

This might need to be a new thread in the community or even a support case opened.

Thanks,

Dana

john_wang
Support
Support

Hi @ramu123 ,

Totally agree with @Dana_Baldwin , please open a new thread if you need further assistance.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
john_wang
Support
Support

Hi @ramu123 ,

Noticed you opened a new article already, thank you.

https://community.qlik.com/t5/Qlik-Replicate/Stream-component-failed-at-subtask-and-Failed-to-create...

Best Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
ramu123
Contributor III
Contributor III
Author

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...