2.4升级2.5问题-我的工作

打开主界面，点击“我的工作”

 

抛出以下异常：

20:29:06,421 INFO AbstractDocStaticTblDAO:2333 - MS SQL Server: SELECT TOP 10 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY DOMAINID) AS ROWNUMBER, TABNIC.* FROM ( SELECT * FROM (select distinct doc.id DOCID,doc.formid FORMID,doc.flowid FLOWID,rhis.flowname FLOWNAME,doc.statelabel STATELABEL,pen.summary SUBJECT,doc.AUDITORNAMES,doc.AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID from DBO.T_DOCUMENT doc,DBO.T_ACTORHIS ahis,DBO.T_RELATIONHIS rhis,DBO.T_FLOW_INTERVENTION pen,DBO.T_FLOWSTATERT fs,DBO.T_NODERT node,DBO.T_ACTORRT actor where doc.id=rhis.docid and rhis.id = ahis.nodehis_id and doc.id = pen.id and doc.id =fs.docid and fs.id =node.flowstatert_id and node.id = actor.nodert_id and doc.issubdoc is null and doc.parent is null and doc.flowid is not null and doc.statelabel is not null and (actor.actorid in ('11e0-7b88-089adb62-922a-5fa8b8a4498a') or ahis.actorid in ('11e0-7b88-089adb62-922a-5fa8b8a4498a')) order by doc.formid,doc.flowid) table_0 WHERE table_0.DOMAINID ='11df-feb0-8287a1ae-8521-99fd4ea7469e') TABNIC) TableNickname WHERE ROWNUMBER>0 java.sql.SQLException: 除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.Statement$$EnhancerByProxool$$8fd4a06d.executeQuery(<generated>) at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQL(AbstractDocStaticTblDAO.java:2336) at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(AbstractDocStaticTblDAO.java:2305) at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(AbstractDocStaticTblDAO.java:2284) at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.queryWorks(DocumentProcessBean.java:1450) at cn.myapps.core.dynaform.work.action.WorkAction.doWorkList(WorkAction.java:150) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:589) at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:365) at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:217) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:191) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198) at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:42) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:100) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508) at java.lang.Thread.run(Thread.java:619) 20:30:57,640 INFO NotificationJob:21 - ********************* Notification Job Start ********************

 

修改方案：

1.修改相应的表的字段的存储类型：

--T_FLOW_INTERVENTION.summary SUBJECT
--T_DOCUMENT.AUDITORNAMES
--T_DOCUMENT.AUDITORLIST

原类型未ntext，改为nvarchar(255)

2.修改对应文件代码：

DataPackage<WorkVO> cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(ParamsTable params, int page, int lines, WebUser user) throws Exception

 

里面删除：//+ " order by doc.formid,doc.flowid";