Replicate data to azure Synapse

[nikhilraorane]

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];'

[lpmarino]

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. 

[vtatarnikov]

@nikhilraorane , @lpmarino  

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

[nikhilraorane]

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

will surely update if I find any solution.

[vtatarnikov]

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

[lpmarino]

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