Results 1 to 3 of 3

Thread: Replicate - Full load issue for single big or multiple small tables

  1. #1
    vishal is offline Junior Member
    Join Date
    Jun 2019
    Posts
    3
    Rep Power
    0

    Replicate - Full load issue for single big or multiple small tables

    Hello,

    We are using “Attunity Replicate – Hourly” from AWS Marketplace. It is on an EC2 instance. Our loads from Oracle RDS (source) to Snowflake (target) are erroring out in two cases:

    • Unable to do FULL load for a table whose row count is 189+ M. The process terminates abnormally.
    • Unable to do FULL load for multiple tables in a Task. If we setup multiple tasks, one for each of the tables and run them together, those completes.


    We have noticed no performance issue on the server, source and target databases which all resides in AWS.

    Please advice how to troubleshoot these.

  2. #2
    sairam is offline Junior Member
    Join Date
    Jul 2019
    Posts
    1
    Rep Power
    0

    SnowFlake connection issue

    Hi,

    How did you connect to snowflake?
    I am getting an error while trying to connect the Snowflake.
    Please help me to resolve the following error.



    Cannot connect to Cloud server
    RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'SnowflakeDSIIDriver' : file not found

    Name:  SnowflakeConnetionIssue.PNG
Views: 58
Size:  57.2 KB

    Thanks in advance :)

  3. #3
    vishal is offline Junior Member
    Join Date
    Jun 2019
    Posts
    3
    Rep Power
    0
    Sorry for the late reply.

    You need to install Snowflake drivers on the Attunity server.

    Thanks,
    Vishal

Posting Permissions

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