By using AWS re:Post, you agree to the Terms of Use
/DMS - "Failed to get blob column values for table..."?/

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!

1 Answers
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

answered a month ago
EXPERT
reviewed a month 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