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