topic Re: Error when replicating tables from MS SQL Server DB using Qlik Replicate in Qlik Replicate

Error when replicating tables from MS SQL Server DB using Qlik Replicate

Alihoussene — Tue, 11 Oct 2022 10:23:26 GMT

Hi,

I tried to replicate some tables from MS SQL Server DB as Source to Snowflake as target using Qlik replicate and Both connections are well established and work well. But when I runed the task, I encountered the error below:

Date and Time Level Message
10/10/2022 3:37:17 PM WARNING_GENERAL Task 'replication' encountered a fatal error
10/10/2022 3:37:17 PM ERROR_GENERAL "Stream component 'st_0_source' terminated
Stream component failed at subtask 0, component st_0_source
Error executing command
Failure upon initial CAPTURE fitness checking
Unable to verify existence of artifact required for DBOWNER permission
mssql_perm_approve_object_existence(...) ended with CREATE() error:
select 1
from master.sys.objects o
inner join master.sys.schemas s on o.schema_id = s.schema_id
where o.name = 'rtm_dump_dblog'
and o.type = 'P'
and s.name = 'attrep'

RetCode: SQL_ERROR SqlState: 42000 NativeError: 40515 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Reference to database and/or server name in 'master.sys.objects' is not supported in this version of SQL Server. Line: 1 Column: -1
mssql_perm_approve_object_existence(...) ended with CREATE() error:
select 1
from master.sys.objects o
inner join master.sys.schemas s on o.schema_id = s.schema_id
where o.name = 'split_partition_list'
and o.type = 'TF'
and s.name = 'attrep'

I hope someone could help me fix it.

Re: Error when replicating tables from MS SQL Server DB using Qlik Replicate

Dana_Baldwin — Tue, 11 Oct 2022 16:48:09 GMT

Hi @Alihoussene

I assume this is a new task, correct?

Do you have other tasks successfully using this same source endpoint? Not just the same database, but using the same source endpoint as defined?

Thanks,

Dana

Re: Error when replicating tables from MS SQL Server DB using Qlik Replicate

Alihoussene — Tue, 11 Oct 2022 16:55:08 GMT

Hi @Dana_Baldwin ,
This is the first task I've configured with this source endpoint and it's the only task I have.
Thanks

Re: Error when replicating tables from MS SQL Server DB using Qlik Replicate

Heinvandenheuvel — Wed, 12 Oct 2022 13:58:55 GMT

The error message from SQLserver is very explicit : "Reference to database and/or server name in 'master.sys.objects' is not supported in this version of SQL Server."

What version SQLserver version is being used? Which Replicate version (top right GUI, and first line in log).

Is that SQLserver version supported as source?

https://help.qlik.com/en-US/replicate/May2022/pdf/Replicate-Support-Matrix.pdf

While the error message is explicit and needs to be checked from that angle, sometimes issues like this a security related. Make sure the username used has 'max' privs, at the very least during a retry maybe forever, and try the query in SMSS using the same username vs using dbadmin.

Hein.

Re: Error when replicating tables from MS SQL Server DB using Qlik Replicate

Alihoussene — Mon, 17 Oct 2022 09:23:37 GMT

Thanks for the responses, I've followed the Qlik replicate user guide for MS SQL Server endpoint
I should make some configs before using the server for replication. I've followed the guide as describe in the section Microsoft Azure SQL Managed Instance as a source . I didn't configure the required permissions.

Thanks