By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

DMS - "Failed to get blob column values for table..."?

0

Hi,

When running a DMS task from MySQL to Redshift (CDC), I'm seeing an error like the below.

"Failed to get blob column values for table..."

I don't see any specific reasons for this error in the cloud watch logs.

Anyone know why BLOB fields are having this problem migrating to Redshift during DMS?

For reference, below are the LOB-related task settings I have set:

"InlineLobMaxSize": 0, "SupportLobs": true, "LobChunkSize": 0, "LobMaxSize": 63, "FullLobMode": false, "LimitedSizeLobMode": true,

Thanks!

Topics
Migration & ModernizationAnalytics
Tags
AWS Database Migration ServiceAmazon Redshift
Language
English
AWS-User-8809738
asked 2 years ago879 views
1 Answer
1

It's hard to know for sure without more information, but it probably has something to do with your LOB settings on the task. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html

profile pictureAWS
burdettg
answered 2 years ago
AWS
EXPERT
Fabrizio@AWS
reviewed 2 years ago
  • AWS-User-8809738
    2 years ago

    Yeah, I tried reading up on that and I couldn't find anything revolving this.

    For reference, I added the LOB-related task settings I'm using.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content