解决方案：

问题：部分员工无法进行自动排班 【适用版本】 8.2sp2 【操作步骤】 8.2旧补丁下的产品bug，可参考如下语句修复： select * into attendancefile0116 from T_hr_ats_attendancefile select * into attendancefilehis0116 from T_hr_ats_attendancefilehis update T_hr_ats_attendancefile set filetype = 1 where FATTENCEPOLICYID is not null and FATSSHIFTID is not null and (filetype <>1 or filetype is null) update T_hr_ats_attendancefilehis set filetype = 1 where FATTENCEPOLICYID is not null and FATSSHIFTID is not null and (filetype <>1 or filetype is null) and fleffdt = {ts '2099-12-31'}