Solutions for Job Problems - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
Error When Overwriting Existing Objects
Description: The overwrite option indicates if tables that exist on the target should be overwritten. If the value of the overwrite_existing_objects parameter is false and the table exists on the target, an error message is generated at job creation time: Table XX exists on the target. Change the OverwriteExistingOjbects property to true and try again.
Solution: If you are creating a new job and get the error message, change the value of the overwrite_existing_objects element to true in create.xml or the overwrite_existing_objects parameter of the create command.
You cannot change the option for a job that is already created, therefore create a new job if necessary. If the job was created with the overwrite option specified as false and the table existed on target, but the table was dropped on the target between job creation and run time, the table will not be created on the target at job run time.
No Data Mover Agents
Description: If you receive the following error on the command line: Daemon cannot find any agents. Must have at least 1 agent to run a job.
Solution: Run /etc/init.d/dmagent status to determine if any Data Mover Agents are currently online. If no Data Mover Agents are online, go to the Teradata server where the Data Mover Agent is installed and do the following:
  1. Run /etc/init.d/dmagent status to determine if the Data Mover Agent is active.
  2. If Data Mover Agent is not active, run /etc/init.d/dmagent to start it.
Data Mover Daemon Port is in Use
Description: If you receive the following error:Daemon port is in use and used by other processes.
Solution: Go to /etc/opt/teradata/datamover. Edit daemon.properties to change the value of arcserver.port to an available port number.
Tables Not Copied to Target System
Description: If tables are listed in the input XML file, but are not copied to the target Teradata Database system.
Solution: You can try any of the following processes to determine the reason:
  • Run the status command with output_level of 4 to view the reason for the failure.
  • Configure the daemon to send events to Teradata Ecosystem Manager and rerun the job, then review the TMSMEVENT metadata table.
  • In the create XML file, set the value of the log_level element to 99, then create and start the job. Run the status command with output_level of 4 to view the reason for the failure.
  • Verify that at least one agent is running by using the list_agents command to list all available agents.
  • Use the view_log command to view the Teradata ARC and Teradata PT API log files, which can be used to troubleshoot the job failure.
  • Review the dmDaemon.log file at /var/opt/teradata/datamover/logs.
  • Review the dmAgent.log file at /var/opt/teradata/datamover/logs.
  • Restart all Teradata Data Mover services, then run the failed job again. To restart the Teradata Data Mover ActiveMQ service, change directory to /etc/init.d, then type the following at the command-line:
    tdactivemq stop
    tdactivemq start
    To restart the daemon service, change directory to /etc/init.d, then type the following at the command-line:
    dmdaemon stop
    dmdaemon start
    To restart the agent service, change directory to /etc/init.d, then type the following at the command-line:
    dmagent stop
    dmagent start