topic Re: Error when running Full Load - MSSQL Developer Edition as Source in Qlik Replicate

Error when running Full Load - MSSQL Developer Edition as Source

RTS23 — Thu, 09 Feb 2023 08:47:58 GMT

Hello, I'm getting this error when running a Full Load, MSSQL Developer Edition Source - OracleDB Target.

Stream component 'st_0_sql' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_sql'.
RetCode: SQL_ERROR SqlState: 42000 NativeError: 20028 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The Distributor has not been installed correctly. Could not enable database for publishing. Line: 1 Column: -1
Failed (retcode -1) to execute statement: 'exec sp_replicationdboption @dbname = N'SampleDB', @optname = N'publish', @value = N'true''

Already configure MSSQL Replication Distribution and Publishing.

Is there something I'm missing ?

Thank you

Re: Error when running Full Load - MSSQL Developer Edition as Source

DesmondWOO — Thu, 09 Feb 2023 09:27:29 GMT

Hi @RTS23 ,

I believe it is SQL server configuration issue. Please check Publisher Properties -> Publication Databases and Distributor Properties -> Publishers if they are configured properly. If problem persists, I would suggest to check with Microsoft Engineer.

Regards,
Desmond

Re: Error when running Full Load - MSSQL Developer Edition as Source

SwathiPulagam — Fri, 10 Feb 2023 19:16:30 GMT

Hi @RTS23 ,

Please disable distribution and configure it one more time.

Please don't ignore any warning messages. Report them here. We will look into it and guide you.

Thanks,

Swathi