200
社区成员
发帖
与我相关
我的任务
分享powercenter workflow卡死不动，也没报错就显示 timeout based commit point
日志如下
WRT_8036 Target: CISCUSTOMERINFO (Instance Name: [NAME_0])
WRT_8038 Inserted rows - Requested: 97000 Applied: 97000 Rejected: 0 Affected: 97000
2015-11-05 09:06:11 : 信息 : (14656 | WRITER_1_*_1) : (IS | IS_service) : node01_sjtm : WRT_8161 :
TARGET BASED COMMIT POINT Thu Nov 05 09:06:10 2015
===================================================
WRT_8036 Target: CISCUSTOMERINFO (Instance Name: [NAME_0])
WRT_8038 Inserted rows - Requested: 98000 Applied: 98000 Rejected: 0 Affected: 98000
2015-11-05 09:07:11 : 调试 : (14656 | WRITER_1_*_1) : (IS | IS_service) : node01_sjtm : WRT_8165 : TIMEOUT BASED COMMIT POINT
WRT_8036 Target: CISCUSTOMERINFO (Instance Name: [NAME_0])
WRT_8038 Inserted rows - Requested: 97000 Applied: 97000 Rejected: 0 Affected: 97000
2015-11-05 09:06:11 : 信息 : (14656 | WRITER_1_*_1) : (IS | IS_service) : node01_sjtm : WRT_8161 :
TARGET BASED COMMIT POINT Thu Nov 05 09:06:10 2015
===================================================
WRT_8036 Target: CISCUSTOMERINFO (Instance Name: [NAME_0])
WRT_8038 Inserted rows - Requested: 98000 Applied: 98000 Rejected: 0 Affected: 98000
2015-11-05 09:07:11 : 调试 : (14656 | WRITER_1_*_1) : (IS | IS_service) : node01_sjtm : WRT_8165 : TIMEOUT BASED COMMIT POINT
...全文
请发表友善的回复…
发表回复
路西法_OS 2016-01-11
- 打赏
- 举报
1、sql执行的太慢，Informatica默认是10000条提交一次，一直提交不了，就会报这个错，优化一下sql
2、调整属性-Commit Interval 默认是10000，改低一点，1000试试
弹指神通 2016-01-06
- 打赏
- 举报
不是很详细，把详细一点的log和报error的部分拿出来看看。
enmy448503004 2016-01-04
- 打赏
- 举报
请问解决了吗，我现在也是这个情况
