topic Re: Replicate data to azure Synapse in Qlik Replicate

Replicate data to azure Synapse

nikhilraorane — Mon, 14 Jun 2021 09:47:06 GMT

Getting below error after I run my task to replicate data from MSSQL db to Azure synapse analytics.

Failed to check if credential 'ATTREP_CN_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc' exists
Failed to drop external data source: 'ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc'
Failed to create and execute: 'DROP EXTERNAL DATA SOURCE [ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc];'
RetCode: SQL_ERROR SqlState: 42000 NativeError: 15151 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the object 'ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc', because it does not exist or you do not have permission. Line: 1 Column: -1
Failed (retcode -1) to execute statement: 'DROP EXTERNAL DATA SOURCE [ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc];'

Re: Replicate data to azure Synapse

lpmarino — Mon, 14 Jun 2021 11:17:16 GMT

I have the same issue. I have an open case with Qlik on it. I am also going from MSSQL to Azure Synapse. If you get an answer, please let me know as mine has been ongoing.

Re: Replicate data to azure Synapse

vtatarnikov — Tue, 21 Sep 2021 15:57:05 GMT

@nikhilraorane , @lpmarino

Hey! I have exactly the same problem. Have you solved the problem?

Re: Replicate data to azure Synapse

nikhilraorane — Fri, 24 Sep 2021 04:44:01 GMT

No Luck yet... I need to check as I am in middle of something else...

will surely update if I find any solution.

Re: Replicate data to azure Synapse

vtatarnikov — Fri, 24 Sep 2021 07:42:39 GMT

The error is gone. We have moved from a serverless SQL to a dedicated SQL. I'm not sure, but maybe it helped.

Re: Replicate data to azure Synapse

lpmarino — Fri, 24 Sep 2021 14:44:10 GMT

Glad you were able to resolve. We gave up testing it with Attunity. Their last post about it refers to increasing the data warehouse units . We were only experiencing it occasionally in production, but all the time in UAT, we also scale up Azure at midnight which does cause loss of connectivity - Replicate should rebound though. Here is the reference they put in my case

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu