This topic provides answers to some frequently asked questions about node failures.

I have configured rerun properties for my node, but the node does not rerun after it fails, and the following error message appears: Task Run Timed Out, Killed by System!!!. What do I do?

  • Problem description:

    The Rerun parameter in the Schedule section of the Properties tab is set to Allow Regardless of Running Status or Allow upon Failure Only for the node. However, the node does not rerun after it fails, and the error message Task Run Timed Out, Killed by System!!! is displayed.

  • Possible cause:

    The Timeout Period parameter in the Schedule section of the Properties tab is configured for the node. If the running duration of the node exceeds the value of the Timeout Period parameter, the node automatically stops running and does not rerun.

  • Solution:

    Manually rerun the node.

I set the Auto Rerun Times upon Error parameter to 1 for my node, but the node does not rerun after it fails. What do I do?

  • Problem description:

    The Auto Rerun Times upon Error parameter is set to 1 for the node in the Schedule section of the Properties tab. However, the node does not rerun after it fails.

  • Possible cause:

    The value that you specified for the Auto Rerun Times upon Error parameter is invalid. If you set the Auto Rerun Times upon Error parameter to n, the node actually reruns n - 1 times. The default value of the Auto Rerun Times upon Error parameter is 3, the minimum value of this parameter is 1, and the maximum value is 10. The value 1 indicates that the node does not rerun after it fails, and the value 10 indicates that the node reruns nine times after it fails. You can configure this parameter based on your business requirements.

  • Solution:

    To enable the node to rerun once after it fails, set the Auto Rerun Times upon Error parameter to 2.

What do I do if the error message ODPS-0420095: Access Denied - Authorization Failed [4093], You have NO privilege to do the restricted operation on {acs:odps:*:projects/xxxx}. Access Mode is AllDenied. appears?

  1. Check whether the MaxCompute compute engine has overdue payments.
  2. On the MaxCompute Management page, check whether Policy-based Authorization is turned on.
Policy-based Authorization

What do I do if the error message ODPS-0420061: Invalid parameter in HTTP request - Fetched data is larger than the rendering limitation. Please try to reduce your limit size or column number appears?

Specify a threshold for the number of data records that can be returned in your SQL statement. If you want to obtain more data records, you can export the data records. If you want to obtain more than 10,000 data records, use a Tunnel command to export the data records.

What do I do if the data synchronized by using multiple threads is out of order?

A synchronization node reads data from MaxCompute tables in random order. If you do not configure order settings, the data returned by the synchronization node is also out of order.

By default, the data synchronized from MaxCompute is stored in random order. If you want to obtain sorted data, configure order settings for the synchronized data. For example, you can configure order by xx limit n in the SQL statement of the synchronization node to sort data.

What do I do if my synchronization node that uses an AnalyticDB for MySQL data source and runs on a shared resource group fails to run?

Purchase an exclusive resource group for scheduling, bind the resource group to a virtual private cloud (VPC) that can be connected to the AnalyticDB for MySQL data source, and then run the synchronization node on the exclusive resource group for scheduling. For more information, see Test data source connectivity.

When I run a data synchronization node that uses a MySQL data source, the system displays an error message indicating that the Java Database Connectivity (JDBC) driver for the MySQL node is not supported. What do I do?

  • The error message sql execute failed! The JDBC driver is not supported. appears because the MySQL data source that you selected is not added by using the connection string mode.
  • Select a MySQL data source that is added by using the connection string mode. You can refer to the operations in Add a MySQL data source to go to the Data Source page, find the desired data source, and then click Edit in the Operation column to view the mode that is used to add the data source.

How do I view the logs of a for-each node, do-while node, or PAI node in Operation Center?

Find your node in Operation Center and open the directed acyclic graph (DAG) of the node. Then, right-click the node name in the DAG and select View Internal Nodes.

What do I do if the error message error in your condition run fail appears when I run a branch node?

  • Check whether the branch conditions that you specified for the branch node comply with the specifications of the Python syntax.
  • If the output of the ancestor assignment node of the branch node is strings, you must enclose variables in single quotation marks (') for the branch node to reference the variables.

What do I do if the error message None Ftp connection info!! appears when I run an FTP Check node?

  • Problem description: The FTP Check node that is used to check whether the FTP data source contains the Done file fails to run, and the error message None Ftp connection info!! appears.
  • Possible cause: The FTP data source is incorrectly configured. As a result, the FTP Check node fails to obtain information about the FTP data source.
  • Solution: Go to the Data Source page to check whether the configurations of the data source that you use are correct. For more information about how to go to the page, see Manage connections. If no FTP data source is available on the Data Source page, you must add an FTP data source. For more information, see Add an FTP data source.

What do I do if the error message Connect Failed appears when I run an FTP Check node?

  • Problem description: The FTP Check node that is used to check whether the FTP data source contains the Done file fails to run, and the error message Connect Failed appears.
  • Possible cause: The FTP data source fails to connect to the FTP server.
  • Solution: Run the telnet IP address Port number command to check whether the FTP server is normally running. Replace the IP address and port number in this command with the IP address and port number of the FTP data source. You can go to the Data Source page of the DataWorks console to view the IP address and port number of the FTP data source. For more information about how to go to the Data Source page, see Manage connections.

What do I do if the error message The current time has exceeded the end-check time point! appears when I run an FTP Check node?

  • Problem description: The FTP Check node that is used to check whether the FTP data source contains the Done file fails to run, and the error message The current time has exceeded the end-check time point! appears.
  • Cause: The time specified by Check stop time has elapsed.
  • Solution: Modify the value of Check stop time based on your business requirements on the configuration tab of the FTP Check node. For more information, see Configure a detection policy.

What do I do if the error message File not Exists or exceeded the end-check time point! appears when I run an FTP Check node?

  • Problem description: The FTP Check node that is used to check whether the FTP data source contains the Done file fails to run, and the error message File not Exists or exceeded the end-check time point! appears.
  • Cause: One possible cause is that the FTP Check node does not find the Done file before the time specified by Check stop time arrives. Another possible cause is that the time specified by Check stop time has elapsed.
  • Solution: This is an expected error. If this error message appears, DataWorks does not trigger the descendant node of the FTP Check node to run.

What do I do if the error message no available machine resources under the task resource group appears for my resource group for scheduling?

  • Problem description: The system displays the following error message for the resource group for scheduling: no available machine resources under the task resource group.
  • Solution: Change the resource group for scheduling that you use to run your node. To change the resource group, perform the following operations: Log on to the DataWorks console and go to Operation Center. In the left-side navigation pane of the Operation Center page, choose Cycle Task Maintenance > Cycle Task. On the Cycle Task page, find the auto triggered node for which you want to change the resource group and click Modify Scheduling Resource Group in the lower part of the page.
Resource group for scheduling