考勤计算一开始是可以计算成功的，但是取不到打卡信息，所以计算出来的都是无数据。后来反结之后选到最后一列的时候就计算报错了，再后来，所有的计算都失败了。

先去这个表中T_HR_ATS_ATTENCEPOLICY 查询下有没这个字段FLEAVEISCAL。没这个字段，就从新运行下ptm5的脚本
这个字段是ptm5新加的 你看一下是不是打ptm5的时候脚本没有执行。
:Q:Q

Apusic 报错日志：
error: ORA-00904: "T0"."FLEAVEISCAL": invalid identifier

sql:SELECT "T0"."FID" "ID", "T0"."FCREATORID" "T1.ID", "T0"."FCREATETIME" "CREATETIME", "T0"."FLASTUPDATEUSERID" "T2.ID", "T0"."FLASTUPDATETIME" "LASTUPDATETIME", "T0"."FCONTROLUNITID" "T3.ID", "T0"."FNAME_L2" "NAME", "T0"."FNAME_L1" "NAME_L1", "T0"."FNAME_L2" "NAME_L2", "T0"."FNAME_L3" "NAME_L3", "T0"."FNUMBER" "NUMBER", "T0"."FDESCRIPTION_L2" "DESCRIPTION", "T0"."FDESCRIPTION_L1" "DESCRIPTION_L1", "T0"."FDESCRIPTION_L2" "DESCRIPTION_L2", "T0"."FDESCRIPTION_L3" "DESCRIPTION_L3", "T0"."FSIMPLENAME" "SIMPLENAME", "T0"."FADMINORGUNITID" "T4.ID", "T0"."FHRORGUNITID" "T5.ID", "T0"."FWORKCALENDARID" "T6.ID", "T0"."FPRENOTBILL" "PRENOTBILL", "T0"."FAFTERNOTBILL" "AFTERNOTBILL", "T0"."FWEEKHOUR" "WEEKHOUR", "T0"."FDAYHOUR" "DAYHOUR", "T0"."FMONTHDAY" "MONTHDAY", "T0"."FLEAVEALLOW" "LEAVEALLOW", "T0"."FLATEALLOW" "LATEALLOW", "T0"."FABSENTALLOW" "ABSENTALLOW", "T0"."FOTSTART" "OTSTART", "T0"."FREMARK" "REMARK", "T0"."FAUDITSTATE" "AUDITSTATE", "T0"."FISDEFAULT" "ISDEFAULT", "T0"."FISLEASTTWOCARDS" "ISLEASTTWOCARDS", "T0"."FISGENOVERTIME" "ISGENOVERTIME", "T0"."FLEAVEISCAL" "LEAVEISCAL", "T0"."FRELATEORGUNITID" "T7.ID", "T0"."FATTENCECYCLEID" "T8.ID" FROM "T_HR_ATS_ATTENCEPOLICY" "T0"
ksql:SELECT "T0"."FID" "ID", "T0"."FCREATORID" "T1.ID", "T0"."FCREATETIME" "CREATETIME", "T0"."FLASTUPDATEUSERID" "T2.ID", "T0"."FLASTUPDATETIME" "LASTUPDATETIME", "T0"."FCONTROLUNITID" "T3.ID", "T0"."FNAME_L2" "NAME", "T0"."FNAME_L1" "NAME_L1", "T0"."FNAME_L2" "NAME_L2", "T0"."FNAME_L3" "NAME_L3", "T0"."FNUMBER" "NUMBER", "T0"."FDESCRIPTION_L2" "DESCRIPTION", "T0"."FDESCRIPTION_L1" "DESCRIPTION_L1", "T0"."FDESCRIPTION_L2" "DESCRIPTION_L2", "T0"."FDESCRIPTION_L3" "DESCRIPTION_L3", "T0"."FSIMPLENAME" "SIMPLENAME", "T0"."FADMINORGUNITID" "T4.ID", "T0"."FHRORGUNITID" "T5.ID", "T0"."FWORKCALENDARID" "T6.ID", "T0"."FPRENOTBILL" "PRENOTBILL", "T0"."FAFTERNOTBILL" "AFTERNOTBILL", "T0"."FWEEKHOUR" "WEEKHOUR", "T0"."FDAYHOUR" "DAYHOUR", "T0"."FMONTHDAY" "MONTHDAY", "T0"."FLEAVEALLOW" "LEAVEALLOW", "T0"."FLATEALLOW" "LATEALLOW", "T0"."FABSENTALLOW" "ABSENTALLOW", "T0"."FOTSTART" "OTSTART", "T0"."FREMARK" "REMARK", "T0"."FAUDITSTATE" "AUDITSTATE", "T0"."FISDEFAULT" "ISDEFAULT", "T0"."FISLEASTTWOCARDS" "ISLEASTTWOCARDS", "T0"."FISGENOVERTIME" "ISGENOVERTIME", "T0"."FLEAVEISCAL" "LEAVEISCAL", "T0"."FRELATEORGUNITID" "T7.ID", "T0"."FATTENCECYCLEID" "T8.ID" FROM "T_HR_ATS_ATTENCEPOLICY" "t0"
2016-01-08 14:27:00 信息 [con.out] [2016-01-08 14:27:00,088 ERROR Running HTTPHandler-7]select() occur error:ORA-00904: "T0"."FLEAVEISCAL": invalid identifier

sql: SELECT "T0"."FID" "ID", "T0"."FCREATORID" "T1.ID", "T0"."FCREATETIME" "CREATETIME", "T0"."FLASTUPDATEUSERID" "T2.ID", "T0"."FLASTUPDATETIME" "LASTUPDATETIME", "T0"."FCONTROLUNITID" "T3.ID", "T0"."FNAME_L2" "NAME", "T0"."FNAME_L1" "NAME_L1", "T0"."FNAME_L2" "NAME_L2", "T0"."FNAME_L3" "NAME_L3", "T0"."FNUMBER" "NUMBER", "T0"."FDESCRIPTION_L2" "DESCRIPTION", "T0"."FDESCRIPTION_L1" "DESCRIPTION_L1", "T0"."FDESCRIPTION_L2" "DESCRIPTION_L2", "T0"."FDESCRIPTION_L3" "DESCRIPTION_L3", "T0"."FSIMPLENAME" "SIMPLENAME", "T0"."FADMINORGUNITID" "T4.ID", "T0"."FHRORGUNITID" "T5.ID", "T0"."FWORKCALENDARID" "T6.ID", "T0"."FPRENOTBILL" "PRENOTBILL", "T0"."FAFTERNOTBILL" "AFTERNOTBILL", "T0"."FWEEKHOUR" "WEEKHOUR", "T0"."FDAYHOUR" "DAYHOUR", "T0"."FMONTHDAY" "MONTHDAY", "T0"."FLEAVEALLOW" "LEAVEALLOW", "T0"."FLATEALLOW" "LATEALLOW", "T0"."FABSENTALLOW" "ABSENTALLOW", "T0"."FOTSTART" "OTSTART", "T0"."FREMARK" "REMARK", "T0"."FAUDITSTATE" "AUDITSTATE", "T0"."FISDEFAULT" "ISDEFAULT", "T0"."FISLEASTTWOCARDS" "ISLEASTTWOCARDS", "T0"."FISGENOVERTIME" "ISGENOVERTIME", "T0"."FLEAVEISCAL" "LEAVEISCAL", "T0"."FRELATEORGUNITID" "T7.ID", "T0"."FATTENCECYCLEID" "T8.ID" FROM "T_HR_ATS_ATTENCEPOLICY" "t0"
2016-01-08 14:27:00 信息 [con.out] [2016-01-08 14:27:00,088 ERROR Running HTTPHandler-2]license method:initalize
2016-01-08 14:27:00 信息 [con.out] [2016-01-08 14:27:00,088 ERROR Running HTTPHandler-2]license result:1
2016-01-08 14:27:00 信息 [con.out] [2016-01-08 14:27:00,198 ERROR Running HTTPHandler-1]license method:getListData
2016-01-08 14:27:27 信息 [con.out] ******cookies is not null *****
2016-01-08 14:27:27 信息 [con.out] ----/login_withForm.jsp
2016-01-08 14:28:00 信息 [con.out] -----PunchCardSynchroniztionManager.process begin-----1452234480369---------------

总部的大神说好的会回复:'(
SHR1.5PTM5版本
如图