列名 'LASTOVERDUEREMINDER' 无效

升级后的M3一直显示此报错，具体信息如下：

1. 09:26:17,446  INFO AbstractNotificationDAO:87 - SELECT doc.DOCID, doc.FORMID, doc.AUDITDATE, doc.FLOWID, doc.DOMAINID, doc.SUMMARY, nrt.NODEID, art.ID ACTORRTID, art.ACTORID, art.DEADLINE FROM t_pending doc INNER JOIN t_nodert nrt ON doc.DOCID = nrt.DOCID INNER JOIN t_actorrt art ON nrt.ID = art.NODERT_ID AND doc.APPLICATIONID = '11e4-228a-84c65877-9fe3-6d16f7ce8322' AND art.DEADLINE IS NOT NULL AND art.LASTOVERDUEREMINDER IS NULL AND art.DEADLINE <= ?
   
2. java.sql.SQLException: 列名 'LASTOVERDUEREMINDER' 无效。
   
3.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
   
4.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
   
5.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
   
6.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
   
7.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
   
8.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
   
9.         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   
10.         at cn.myapps.core.workflow.notification.dao.AbstractNotificationDAO.queryOverDuePending(AbstractNotificationDAO.java:92)
    
11.         at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.getOverDueNotifications(NotificationProcessBean.java:278)
    
12.         at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.notifyOverDueAuditors(NotificationProcessBean.java:222)
    
13.         at cn.myapps.core.workflow.notification.ejb.NotificationJob.run(NotificationJob.java:36)
    
14.         at java.util.TimerThread.mainLoop(Timer.java:512)
    
15.         at java.util.TimerThread.run(Timer.java:462)
    
16. 09:26:17,523  INFO NotificationJob:48 - ********************* Notification Job End ********************

复制代码

请楼主检查t_actorrt这个表有无LASTOVERDUEREMINDER字段。如果没有请创建一个datetime类型字段。

还真没有这个字段。谢谢，问题解决。

感谢楼主反馈，该贴结贴。