Question 1: How to deal with DataWorks [Data Quality] interface to try to run the rule report?
DataWorks [data quality] interface interview running rules report [The parameter is incorrect. getYunAccountAndAK is not exist in tenant server] how to deal with?
Reference answer:
It should be a dirty data encounter, which has been corrected.
More answers to this question can be found in the original article:
https://developer.aliyun.com/ask/622762
Question 2: DataWorks If the data for a particular day is generated irregularly, but most of the time it is regular, is there a good way to handle it?
DataWorks If the data for a particular day is generated irregularly but most of the time it is timed then this timed scheduling will report an error Is there a good way to handle this?
Reference Answer:
Data for a particular day he is not timed to produce ----- Where is that data being produced? Synchronized with a data integration synchronization task? Then the downstream task hangs under the synchronization task and waits for the upstream synchronization to complete before executing the downstream Doesn't this meet the requirements?
More answers to this question can be found in the original article:
https://developer.aliyun.com/ask/622731
Question 3: An oracle data source in DataWorks suddenly failed to connect in the early hours of this morning, how should I troubleshoot the problem based on this error report?
DataWorks in oracle a data source in the early hours of this morning suddenly connectivity is not available, which reported an error here Resource GroupIP at the two IP addresses what is the meaning?
What is the meaning of these two IP addresses at Resource GroupIP? How should we troubleshoot the problem based on this error.
Reference Answer:
Suggested from the upper right corner of the small wrench into the data source again to test the data integration connectivity According to the steps of the Diagnostic Assistant for the operation Look, how is it dealt with under the connection Tracing the cause can only be viewed from the link that is open to view, such as routing, whitelisting has been changed and so on, AliCloud cloud products or AliCloud ECS self-built number warehouse / database services and exclusive resource groups with the same master account and the same geographical area. Aliyun products or Aliyun ECS self-built warehouse/database services and exclusive resource groups are across master accounts or across geographic regions.
You can check from these steps to see where there is a change that is causing the failure.
More answers to this question can be found in the original article:
https://developer.aliyun.com/ask/622730
Question 4: DataWorks Real-Time Synchronization task, reporting an error saying data type conversion failed, which field is the problem?
“DataWorks real-time synchronization task, reported an error saying data type conversion failed, which field is the problem? The reported error message is rather simple to read.ERROR RdbmsWriter$Task - flush table ods_wms_stockinfo_account_rt error: com.alibaba.di.plugin.center.element.LongColumn can LongColumn can 't support conversion to byte[] type!
DataXException: com.alibaba.di.plugin.center.exception.DataXException: com.alibaba.di.plugin.center.element.LongColumn can 't support conversion to byte[ ] type!”. ] type!”
Reference answer:
Is the current table structure easy to look up? Suspect a numeric type field is written to a byte type field.
Source table: stockinfo_account wms lazxxxxxms.mysql.singapore.rds.aliyuncs.com
Target table: ods_wms_stockinfo_account_rt erp am-t4ne09xxxxxxxe153470
The write side uses a binary type, change it to a numeric type and try it.
More answers to this question can be found in the original article:
https://developer.aliyun.com/ask/622728
Question 5: What is the problem with DataWorks, a partitioned table that does not have a partition exception?
What's wrong with the DataWorks partition table that doesn't have partition exceptions? I can find the partitions by show partitions?
Refer to the answer:
Confirm whether the synchronization task and the data map query is the same table, the synchronization task log can confirm the projectname and tablename, it is recommended to specify the project name to check the table partition project name can be found in the log of the synchronization task.
More answers to this question can be found in the original article:
https://developer.aliyun.com/ask/622723