Error in recreating external table in sqldw azure
We have a scenario where we occasionally come across an issue with creation of external tables in sqldw azure.
We were trying to perform data replication from Oracle to Azure SQLDW using a .csv file size of 500 MB when the task errored out with the below error.
"RetCode: SQL_ERROR SqlState: 42S01 NativeError: 2714 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'xxxxxxxxxxxxxxx' in the database. Line: 1 Column: -1".
It then tried to drop and recreate this external table but could not do so.
Please Note: The same task completed successfully for various file sizes of 250 MB, 150 MB etc.
Any pointers to the cause of this error would be helpful.
1. Not seeing all the logs, it could be that you have a connection issue if csv copy of 500MB are failing, by default Endpoint is set for 1000MB.
2. What version of Replicate are you running ?
3. What version of Replicate Client is running on the Attunity Cloudbeam Azure server?