QC(Mercury Quality Center)页面打开报404,两个 datetime 列的差别导致了运行时溢出
日志报错:
failed perform job :class com.mercury.td.saserver.jobs.CIdleAppServerCleanerJob
com.mercury.optane.core.CTdException
Messages:Failed to deactivate idle application servers in database;
[Mercury][SQLServer JDBC Driver][SQLServer]两个 datetime 列的差别导致了运行时溢出。;
定位方法:
1、根据报错信息中的方法,在QC安装目录中,找到对应CLASS:sabin-exp.war/WEB-INF/lib/saproxy.jar/com/mercury/td/saserver/jobs/CIdleAppServerCleanerJob.class
2、反编译CCIdleAppServerCleanerJob.class
3、进入sqlserver数据库:
通过字段找到对应的表
select * from qcsiteadmin_db.dbo.syscolumns Where name=‘TD_LAST_TOUCH_TIME’
找到对应的表
select * from qcsiteadmin_db.td.appservers
4、查询报错:两个 datetime 列的差别导致了运行时溢出。
select * from qcsiteadmin_db.td.appservers
where TD_IS_ACTIVE=‘Y’ AND (TD_LAST_TOUCH_TIME IS NULL OR (SELECT DATEDIFF(millisecond,TD_LAST_TOUCH_TIME,getdate())) > 60000)
5、更新TD_LAST_TOUCH_TIME
update qcsiteadmin_db.td.appservers set TD_LAST_TOUCH_TIME=‘2022-02-01 13:59:49.857’;
update qcsiteadmin_db.td.appservers set TD_IS_ACTIVE=‘Y’;