Weird DMS Error: "Replication Task Settings document error: Array element's unique identifier was not found, please provide Id for each and every element"

Question

Trying to set up DMS between RDS MySQL and Redshift.  If I try to edit the the Table Mappings from the GUI, I always get a weird error (that has zero Google results, except 1 spam page)

`Replication Task Settings document error: Array element's unique identifier was not found, please provide Id for each and every element`.

No idea what that means.  Every rule has a unique name and ID.

Not the biggest issue in the world, as it's usually okay if I make a new one, but it does make it hard to iterate.  Any idea what the issue here could be?  Thanks!

Answer

Hi,

I understand that you are observing the below error on your trying to set up DMS between RDS MySQL and Redshift. :

ERROR : Replication Task Settings document error: Array element's unique identifier was not found, please provide Id for each and every element.

I found out that it is related to an issue because of modifying (even if using the same values) the character set, when you remove the character settings in task setting, when you save and modify again, the character setting section appears:

"CharacterSetSettings": {
	    "CharacterSetSupport": {
	      "CharacterSet": "    ",
	    },
	    "CharacterReplacements": [
	      {
	        "SourceCharacterCodePoint": "  ",
	        "TargetCharacterCodePoint": "  "
	      },

The modification on existing "CharacterSetSettings" is not supported, To fix this issue you will need to create a new task with the required settings of "CharacterSetSettings" or new task without any setting for "CharacterSetSettings"

[+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.CharacterSubstitution.html

I hope this helps

Weird DMS Error: "Replication Task Settings document error: Array element's unique identifier was not found, please provide Id for each and every element"

Relevant content