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
asked 23 days ago173 views
2 Answers
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
EXPERT
Matt-B
answered 23 days ago
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
answered 23 days ago

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