aws-dms:replication task 设置文档错误:未找到数组元素的唯一标识符,请为每个元素提供id

3htmauhk  于 2021-07-09  发布在  Spark
关注(0)|答案(0)|浏览(290)

我的任务设置json。。

{
      "TargetMetadata": {
        "TargetSchema": "",
        "SupportLobs": true,
        "FullLobMode": false,
        "LobChunkSize": 0,
        "LimitedSizeLobMode": true,
        "LobMaxSize": 32,
        "InlineLobMaxSize": 0,
        "LoadMaxFileSize": 0,
        "ParallelLoadThreads": 0,
        "ParallelLoadBufferSize": 0,
        "BatchApplyEnabled": true,
        "TaskRecoveryTableEnabled": false,
        "ParallelLoadQueuesPerThread": 0,
        "ParallelApplyThreads": 0,
        "ParallelApplyBufferSize": 0,
        "ParallelApplyQueuesPerThread": 0
      },
      "FullLoadSettings": {
        "TargetTablePrepMode": "DO_NOTHING",
        "CreatePkAfterFullLoad": false,
        "StopTaskCachedChangesApplied": false,
        "StopTaskCachedChangesNotApplied": false,
        "MaxFullLoadSubTasks": 15,
        "TransactionConsistencyTimeout": 600,
        "CommitRate": 10000
      },
      "Logging": {
        "EnableLogging": true,
        "LogComponents": [
          {
            "Id": "TRANSFORMATION",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "SOURCE_UNLOAD",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "IO",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "TARGET_LOAD",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "PERFORMANCE",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "SOURCE_CAPTURE",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "SORTER",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "REST_SERVER",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "VALIDATOR_EXT",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "TARGET_APPLY",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "TASK_MANAGER",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "TABLES_MANAGER",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "METADATA_MANAGER",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "FILE_FACTORY",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "COMMON",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "ADDONS",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "DATA_STRUCTURE",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "COMMUNICATION",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          },
          {
            "Id": "FILE_TRANSFER",
            "Severity": "LOGGER_SEVERITY_DEFAULT"
          }
        ],
        "CloudWatchLogGroup": "dms-tasks-dev-cdp-replication-instance",
        "CloudWatchLogStream": "dms-task-327XOPIERNZIVMAYGN34MZY3ARIVOBGRQAF3QXI"
      },
      "ControlTablesSettings": {
        "historyTimeslotInMinutes": 5,
        "ControlSchema": "",
        "HistoryTimeslotInMinutes": 5,
        "HistoryTableEnabled": false,
        "SuspendedTablesTableEnabled": false,
        "StatusTableEnabled": false,
        "FullLoadExceptionTableEnabled": false
      },
      "StreamBufferSettings": {
        "StreamBufferCount": 3,
        "StreamBufferSizeInMB": 8,
        "CtrlStreamBufferSizeInMB": 5
      },
      "ChangeProcessingDdlHandlingPolicy": {
        "HandleSourceTableDropped": true,
        "HandleSourceTableTruncated": true,
        "HandleSourceTableAltered": true
      },
      "ErrorBehavior": {
        "DataErrorPolicy": "LOG_ERROR",
        "DataTruncationErrorPolicy": "LOG_ERROR",
        "DataErrorEscalationPolicy": "SUSPEND_TABLE",
        "DataErrorEscalationCount": 0,
        "TableErrorPolicy": "SUSPEND_TABLE",
        "TableErrorEscalationPolicy": "STOP_TASK",
        "TableErrorEscalationCount": 0,
        "RecoverableErrorCount": -1,
        "RecoverableErrorInterval": 5,
        "RecoverableErrorThrottling": true,
        "RecoverableErrorThrottlingMax": 1800,
        "RecoverableErrorStopRetryAfterThrottlingMax": false,
        "ApplyErrorDeletePolicy": "IGNORE_RECORD",
        "ApplyErrorInsertPolicy": "LOG_ERROR",
        "ApplyErrorUpdatePolicy": "LOG_ERROR",
        "ApplyErrorEscalationPolicy": "LOG_ERROR",
        "ApplyErrorEscalationCount": 0,
        "ApplyErrorFailOnTruncationDdl": false,
        "FullLoadIgnoreConflicts": true,
        "FailOnTransactionConsistencyBreached": false,
        "FailOnNoTablesCaptured": false
      },
      "ChangeProcessingTuning": {
        "BatchApplyPreserveTransaction": true,
        "BatchApplyTimeoutMin": 1,
        "BatchApplyTimeoutMax": 30,
        "BatchApplyMemoryLimit": 500,
        "BatchSplitSize": 0,
        "MinTransactionSize": 1000,
        "CommitTimeout": 1,
        "MemoryLimitTotal": 1024,
        "MemoryKeepTime": 60,
        "StatementCacheSize": 50
      },
      "PostProcessingRules": null,
      "CharacterSetSettings": {
        "CharacterReplacements": [
          {
            "SourceCharacterCodePoint": "201C",
            "TargetCharacterCodePoint": "0022"
          }
        ]
      },
      "LoopbackPreventionSettings": null,`enter code here`
      "BeforeImageSettings": null,
      "FailTaskWhenCleanTaskResourceFailed": false
    }

我在这里加上:

"CharacterSetSettings": {
            "CharacterReplacements": [
              {
                "SourceCharacterCodePoint": "201C",
                "TargetCharacterCodePoint": "0022"
              }
            ]
          },

它给了我这个错误:

Replication Task Settings document error: Array element's unique identifier was not found, please provide Id for each and every element 
(Service: AWSDatabaseMigrationService; Status Code: 400; Error Code: InvalidParameterValueException; Request ID: 491eb0cf-2f6b-47bb-9d1c-9a37eb4a9ada; Proxy: null)

我尝试为数组中的每个元素添加id,如下所示:

“CharacterSetSettings”: {
    “CharacterSetSupport”: null,
    “CharacterReplacements”: [
      {
        "ID": "DOUBLE QUOTES REPLACE"
        “SourceCharacterCodePoint”: “201C”,
        “TargetCharacterCodePoint”: “0022”
      }
    ]
  },

在提供了这个id列之后,它会给我同样的错误,比如:

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

我的问题是:
我的id值正确吗?如果不是,那么这个id的值应该是多少?
请帮我处理这个错误。。
任何帮助都将被占用。提前谢谢

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题