I have problems with a DMS task

0

I have this task and it sends me the following error, I have tried everything and it doesn't work

{ "rules": [ { "rule-type": "selection", "rule-id": "613324719", "rule-name": "613324719", "object-locator": { "schema-name": "replicador", "table-name": "empaque" }, "rule-action": "include", "parallel-load": null, "isAutoSegmentationChecked": false } ] }


--- error

Last Error No table included in TableMappings. Check table mappings to make sure there is at least one rule with rule-type 'selection' and rule-action 'include' or 'explicit' Stop Reason FATAL_ERROR Error Level FATAL

jaime
已提問 1 個月前檢視次數 211 次
2 個答案
0

Hi THere

The error message indicates that the DMS task does not have any tables included in the table mappings. The error message states "Last Error No table included in TableMappings. Check table mappings to make sure there is at least one rule with rule-type 'selection' and rule-action 'include' or 'explicit'".

Here are a few things you can check to troubleshoot the issue:

  1. Verify the table mapping configuration: Ensure that the table mapping configuration you provided in your question is correct and includes at least one rule with the correct settings. The rule should have a rule-type of "selection", a rule-action of "include" or "explicit", and the correct object-locator parameters (schema-name and table-name).

  2. Check the table existence: Ensure that the table "empaque" exists in the "replicador" schema on the source database. Verify that the table is accessible and that the DMS user has the necessary permissions to access it.

  3. Verify the DMS task configuration: Check the overall DMS task configuration, including the source and target database connections, to ensure that everything is set up correctly.

  4. Review the DMS task logs: Check the DMS task logs for additional information about the error. The logs may provide more details about the issue, which could help you identify the root cause.

profile pictureAWS
專家
Matt-B
已回答 1 個月前
0

Review all the points you indicate. endpoint source, endpoint target. schema , tables and tasks. Everything is correct, but it keeps sending that error, I don't know if something is missing that is not documented.

jaime
已回答 1 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南