天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

 找回密码
 注册成为天翎用户
查看: 1295|回复: 5

数据库使用oracle,“我的工作”、“站内短信”不能使用,求助!!

[复制链接]
alan_hu 发表于 2011-12-18 21:37:28 | 显示全部楼层 |阅读模式
本帖最后由 shary 于 2011-12-21 09:35 编辑

sql执行正常
报错信息如下:
    21:30:32,859  INFO AbstractDocStaticTblDAO:2305 - Oracle :select * from ( select row_.*, rownum rownum_ from (  SELECT * FROM (SELECT DISTINCT * FROM (select distinct doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,pen.flowname FLOWNAME,doc.statelabel STATELABEL,to_char(substr(pen.summary,1,1000)) as SUBJECT,to_char(substr(doc.AUDITORNAMES,1,2000)) as AUDITORNAMES,to_char(substr(doc.AUDITORLIST,1,2000)) as AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID  from  APPUSER.T_DOCUMENT  doc,APPUSER.T_FLOW_INTERVENTION pen,APPUSER.T_FLOWSTATERT fs,APPUSER.T_NODERT node,APPUSER.T_ACTORRT actor  where 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.state is not null and doc.statelabel is not null  and actor.actorid in ('11e1-2955-f11fd715-a7a3-3b92b95d5939') UNION select distinct doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,rhis.flowname FLOWNAME,doc.statelabel STATELABEL,to_char(substr(pen.summary,1,1000)) as SUBJECT,to_char(substr(doc.AUDITORNAMES,1,2000)) as AUDITORNAMES,to_char(substr(doc.AUDITORLIST,1,2000)) as AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID  from  APPUSER.T_DOCUMENT  doc,APPUSER.T_ACTORHIS ahis,APPUSER.T_RELATIONHIS rhis,APPUSER.T_FLOW_INTERVENTION pen,APPUSER.T_FLOWSTATERT fs where doc.id=rhis.docid and rhis.id = ahis.nodehis_id and doc.id = pen.id and doc.id =fs.docid and doc.issubdoc is null and doc.parent is null and doc.state is not null and doc.statelabel is not null  and ahis.actorid in ('11e1-2955-f11fd715-a7a3-3b92b95d5939')) tab order by tab.formid,tab.flowid) table_0 WHERE table_0.DOMAINID ='11e1-2955-4c7c5114-a7a3-3b92b95d5939' ) row_ where rownum <= 10) where rownum_ > 0
java.lang.NullPointerException
        at cn.myapps.core.dynaform.work.ejb.WorkVO.setSubject(WorkVO.java:118)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.setWorkProperties(AbstractDocStaticTblDAO.java:2367)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQL(AbstractDocStaticTblDAO.java:2312)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(AbstractDocStaticTblDAO.java:2278)
        at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(AbstractDocStaticTblDAO.java:2189)
        at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.queryWorks(DocumentProcessBean.java:1558)
        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:597)
        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:109)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.util.AssertionThreadLocalFilter.doFilter(AssertionThreadLocalFilter.java:54)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:75)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:197)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.core.sso.cas.filter.OBPMAuthenticationFilter.doFilter(OBPMAuthenticationFilter.java:84)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)
        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.EncodingFilter.doFilter(EncodingFilter.java:27)
        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:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        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:291)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:619)
shary 发表于 2011-12-19 10:12:49 | 显示全部楼层
请问您的myApps平台是什么版本
 楼主| alan_hu 发表于 2011-12-19 10:23:50 | 显示全部楼层
2.5 sp3 7900
shary 发表于 2011-12-19 10:42:32 | 显示全部楼层
您好,您打一下附件的这个补丁试一下。注意在打补丁之前进行相关文件备份以免出现问题。

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册成为天翎用户

x
 楼主| alan_hu 发表于 2011-12-19 11:21:29 | 显示全部楼层
给我发个编译好的吧,eclipse编译环境没配置呢,谢谢
irene 发表于 2012-2-27 11:26:02 | 显示全部楼层
您好,请问您有源码吗?如果有,您可以在您本机上配置eclipse,然后利用eclipse来编译,如果没有源码的话,我们公司现在的产品是开源的了,您可以到我们的网站上下载源码然后部署到eclipse上面进行编译,下载链接:http://www.teemlink.com/obpm.jsp

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册成为天翎用户

x

本版积分规则

QQ|手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-12 20:57

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表