作业报错信息如下:
ECIF_FTP,0: error: ftp returned 426
ftp msg: 426 Data connection: Error 0
错误分析:
CBS_BDSKH中sql语句如下:
SELECT a.kehhao, a.gerzwm,a.gerywm, a.guobdm,a.jinnbz, a.xngbie, a.chusrq,a.zhjnzl, a.zhjhao,a.dzyjdz,a.fazjig,a.fzjgdq,a.zjdjdz,a.ywendz,a.danwxz,a.gngzdw,a.bangdh,a.bangdz,a.czhenh,a.danwyb,a.katuor, a.zhiche, a.xuelii, a.funyck,a.zzaidz,a.dianhh,a.dsyhyb,a.zhiwuu,a.zhiyee, a.dizhii, a.youzbm, a.lxdiah, a.wgktyw, a.khjgdh, a.ka1hgy, a.kaihrq,a.weihgy, a.weihrq, a.jiluzt, b.yngyjg,a.zinuck,a.yuesur
FROM bdskh a left join pgycs b on a.weihgy=b.guiydh
order by a.kehhao
此sql执行效率较低,单纯执行sql耗时9分钟左右,此时ftp链接已断。
解决方法:
登录ftp服务器,修改配置文件的data_connection_timeout=1200