“我的工作”模块一片空白什么都没有

急，在线等

论坛没人啊

额。不好意思，有人的。你建一个表单一个视图一个流程，在前台跑一条数据再看看。

都建立了，去前台跑还是不行。你们用的前台在什么流程都不建立的时候，是不是也是一片空白

能否把你的tomcat下报的错误信息贴出来看下。

发了。。。。。。。。

12:46:27,640  INFO AbstractRelationHISDAO:318 - MS SQL SERVER: SELECT * FROM T_R
ELATIONHIS vo WHERE vo.DOCID='11e0-f944-23b76a8a-a891-81266b690c82' AND vo.flowi
d='null' ORDER BY vo.actiontime
12:46:33,984  INFO AbstractDocStaticTblDAO:2333 - MS SQL Server: SELECT TOP 10 *
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_DOCUME
NT  doc,DBO.T_ACTORHIS ahis,DBO.T_RELATIONHIS rhis,DBO.T_FLOW_INTERVENTION pen,D
BO.T_FLOWSTATERT fs,DBO.T_NODERT node,DBO.T_ACTORRT actor  where doc.id=rhis.doc
id 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 nu
ll  and (actor.actorid in ('11e0-f8a4-7b951ea5-a4c4-a916643b6040') or ahis.actor
id in ('11e0-f8a4-7b951ea5-a4c4-a916643b6040')) order by doc.formid,doc.flowid)
table_0 WHERE table_0.DOMAINID ='11e0-f89b-054e469b-bff4-7db5e3699fd7') TABNIC
java.sql.SQLException: 除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、
派生表和子查询中无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava: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(JtdsPrep
aredStatement.java:777)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:93)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWor
kBySQL(AbstractDocStaticTblDAO.java:2336)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWor
kBySQLPage(AbstractDocStaticTblDAO.java:2305)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWor
kBySQLPage(AbstractDocStaticTblDAO.java:2284)
        at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.queryWorks(D
ocumentProcessBean.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(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultAc
tionInvocation.java:365)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(Defau
ltActionInvocation.java:217)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:191)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:113)
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:233)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:198)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDis
patcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiL
anguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilte
r.java:30)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java
:100)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
        at java.lang.Thread.run(Thread.java:619)

下面这个是

回复 5# admin


    在的话帮忙看看

您好，这个部分在sqlserver下测试过确实存在问题。已经提交研发部修正。会在下周的优化版本中发布。抱歉了。