Data Replication 2
Results 1 to 5 of 5

Thread: Replication Full load stuck at 98% of total completion

  1. #1
    mjolly is offline Junior Member
    Join Date
    Sep 2015
    Posts
    6
    Rep Power
    0

    Replication Full load stuck at 98% of total completion

    Attunity Replicate console stuck at 98 % of the full load.

    source db: oracle 11g
    target: amazon redshift cluster

    Issue:
    The full load starts, loads the table structure from source to the target. (Verified by connecting SQL workbench/J to the AWS redshift cluster)
    However, the attunity replicate does not replicate the data from the source to the target.
    The source table has a few hundred records.
    I let the replicate software run for hours, but it only got queued and never completed.

    Attached are the screenshot of the console and the log.

    Name:  030.JPG
Views: 410
Size:  131.0 KBName:  028.JPG
Views: 374
Size:  149.4 KB

    --
    Thnx

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    Hello Mjolly,

    1. Look like the data is not getting to your S3 bucket.
    Please verify that the cvs files are getting to your S3 bucket.

    2. Is your Attunity Cloubbeam server in the same region as your Redshift Cluster?

    3. Is the Replicate server locally or on AWS?

    4. From the Replicate server, could you telnet the Attunity Cloudbeam server on port 5746?
    example > telnet Attunity_clouldbeam_server_ip 5746 ,,,, what do you get?

    5. Is the Attunity Replicate or the Attunity Cloudbeam server behind any VPC?

    Thanks,
    Steve Nguyen

  3. #3
    mjolly is offline Junior Member
    Join Date
    Sep 2015
    Posts
    6
    Rep Power
    0
    Steve,

    1. The csv files are not getting to the S3 Bucket. (Authenticated users have the privs: list, upload/delete, view permissions). The S3 bucket has a folder with no encryption.

    2. Yes the cloud beam server is in the same region - US east coast as the Redshift cluster.

    3. Replicate server is on premise and the cloudbeam server is in the AWS

    4. Yes, the on-premise replicate server (telnet client) opens the telnet prompt when I telnet to the cloudbeam server(EC2 machine) with the telnet server on port 5746

    5. The Attunity Cloudbeam server is in the AWS VPC - security group along with the Amazon redshift cluster.

    6. The Amazon redshift cluster is able to connect to cloudbeam server and the replicate server but we have the public access off (unauthorized users outside the aws region) on it for now.

  4. #4
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    Quote Originally Posted by mjolly View Post
    Steve,

    1. The csv files are not getting to the S3 Bucket. (Authenticated users have the privs: list, upload/delete, view permissions). The S3 bucket has a folder with no encryption.

    2. Yes the cloud beam server is in the same region - US east coast as the Redshift cluster.

    3. Replicate server is on premise and the cloudbeam server is in the AWS

    4. Yes, the on-premise replicate server (telnet client) opens the telnet prompt when I telnet to the cloudbeam server(EC2 machine) with the telnet server on port 5746

    5. The Attunity Cloudbeam server is in the AWS VPC - security group along with the Amazon redshift cluster.

    6. The Amazon redshift cluster is able to connect to cloudbeam server and the replicate server but we have the public access off (unauthorized users outside the aws region) on it for now.
    Hello Mjolloy,

    I think the issue is with your Security right now.

    on the two items:
    5. The Attunity Cloudbeam server is in the AWS VPC - security group along with the Amazon redshift cluster.

    6. The Amazon redshift cluster is able to connect to cloudbeam server and the replicate server but we have the public access off (unauthorized users outside the aws region) on it for now.

    Could you take the Cloudbeam and Redshift out of your VPC for testing?
    and have Public access On?

    Thanks,
    Steve

  5. #5
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    mjolly,

    Note we have seen similar issue:

    When the Replicate server and the Attunity Cloudbeam server it was deployed in private network VPC.

    To resolve the issue:
    The Replicate Server and CloudBeam EC2 need to be on external facing network.

Tags for this Thread

Posting Permissions

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