Data Replication 2
Results 1 to 2 of 2

Thread: Error in recreating external table in sqldw azure

  1. #1
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0

    Error in recreating external table in sqldw azure

    Hi Experts,

    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.

    Regards,
    Akanksha

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    234
    Rep Power
    4
    Hello Akanksha,

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •