问题一:DataWorks临时查询报错 FAILED: System Error: None 怎么办?
DataWorks临时查询报错 FAILED: System Error: None Active Gateway Resource ?
参考回答:
点「带参运行」使用的独享调度资源组还是公共调度资源组呢 是否会稳定出现
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647879
问题二:DataWorks导入到es数据报错,导入到mysql没问题,试了下es数据源能联通怎么办?
DataWorks导入到es数据报错,导入到mysql没问题,试了下es数据源能联通,同事的账号试了下也是报错,凌晨的跑数任务没问题?实例重新跑批也是这个错误
报错信息ErrorMessage:
Render instance failed, error message: DescribeInstance with regionId: cn-hangzhou instanceId: es-cn-uqm3fjgo800042s8m ownerId: 241791778707068402 error message: Can not get user info from tenant, userId: 241791778707068402
参考回答:
确认一下
- 当前di任务的责任人的ram子账号是不是被删除 并且还没有修改责任人
- 右上角 小扳手-数据源看想es开发数据源配置的访问账号是否还在正常使用中
cn-hangzhou instanceId: es-cn-uqm3fjgo800042s8m ownerId: 241791778707068402 error message: Can not get user info from tenan----es数据源配置截图 方便发一下么 对应配置的访问账号是否是241791778707068402 这个ram账号在ram控制台看下状态呢
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647875
问题三:DataWorks连通性测试都通过了的这是为什么会报错呀?
"DataWorks连通性测试都通过了的这是为什么会报错呀?
oad driver class: com.mysql.cj.jdbc.Driver
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:172)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:444)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
at java.sql.DriverManager.getConnection(DriverManager.java:674)
at java.sql.DriverManager.getConnection(DriverManager.java:256)
at com.alibaba.dw.alisa.wrapper.util.ConnectionManager.getJDBCConnection(ConnectionManager.java:30)
at com.alibaba.dw.alisa.wrapper.JdbcWrapper.executeJdbcSql(JdbcWrapper.java:99)
at com.alibaba.dw.alisa.wrapper.JdbcWrapper.submitJob(JdbcWrapper.java:43)
at com.alibaba.dataworks.dwalisa.DwalisaWrapperMain.main(DwalisaWrapperMain.java:265)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:92)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:982)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
... 9 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:639)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:66)
... 12 more
sql execute failed! Communications link failure"
参考回答:
你说的报错是哪里报错,你的描述中没有说明
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647872
问题四:DataWorks分支节点跨空间迁移后提交不了怎么解决呢?
DataWorks分支节点跨空间迁移后提交不了怎么解决呢?
参考回答:
源端空间分支节点「关联到节点输出」输出名是不是没有加 英文空间名前缀,建议在源端加一下 然后修改一下下游依赖的输出名 再跨工作空间发布
关于本问题的更多回答可点击原文查看:
https://developer.aliyun.com/ask/647870
问题五:DataWorks如果当天的ads表没有数据,管道报错 他会影响管道的下个小时的运行吗?
DataWorks把一批管道及其上游 设为每一个小时执行一次,如果当天的ads表没有数据,管道报错 他会影响管道的下个小时的运行吗?
参考回答:
如果任务没有设置依赖本节点 不会影响下一个小时运行
关于本问题的更多回答可点击原文查看: