工作流流转卡死，提示：JUSTEP150050，回滚事务出错

laijiaxing

跪求起步工程师处理，工作流流转时卡死报错，提示：JUSTEP150050，回滚事务出错

laijiaxing

日志：
2017-12-12 15:54:42 action:<?xml version="1.0" encoding="UTF-8"?>
<actions><action direct-execute="false" process="/yqf/scm/sale/process/SaleOrder/saleOrderProcess" activity="businessActivity3" action-flag="__action_0__" executor="/ORG01.ogn/2902CB41E6B94A198B9F71CD5EE15C0B.ogn/A84FF905D8C643E5B9C3454827516EC1.dpt/49EEE3B4CF5C4FA6BDBA483BEDDB2621.pos/110FB64FEE9742209FDED552341540AA@49EEE3B4CF5C4FA6BDBA483BEDDB2621.psm" execute-context="" name="externalAdvanceProcessAction" accept="*/*">        <parameters xmlns:xbiz="http://www.justep.com/xbiz#">                <parameter name="task">                        <xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1DF3D8F10B334FF5967227C6487E47A0</xbiz:simple>                </parameter><parameter name="control"><xbizbject class="com.justep.system.process.ProcessControl"><process-control><task-join>false</task-join><status>none</status><postscript/><jump-enabled>false</jump-enabled><customized-enabled>false</customized-enabled><message/><dialog-enabled>true</dialog-enabled><save-history>true</save-history><task-join-mode>tjmMultiple</task-join-mode><to><process-control-item is-end="false" activity-id="1C7EBC2F5B024049BB85FE5AF614A6AF" id="1C7EBC2F5B024049BB85FE5AF614A6AF" selected="true" readonly="false"><template/><executor-kinds>SM</executor-kinds><process>/yqf/scm/sale/process/SaleOrder/saleOrderProcess</process><unit>businessActivity7</unit><task-assign-mode>together</task-assign-mode><executor-range><org-unit><fid>/ORG01.ogn/B6EB11F703AD4B719CDE00C59E8E3B1B.ogn/F49816F3212E4E4CA1914EF3C312DF61.dpt/18FDDC91553F41C9B3426E4D49B752AD.pos</fid><responsible>false</responsible><fname>/集团总部/嘉通贸易/财务部/会计1</fname></org-unit><org-unit><fid>/ORG01.ogn/B6EB11F703AD4B719CDE00C59E8E3B1B.ogn/907671DA73D34949AA33F134791F554C.dpt/88BCA5E9E1CB47F7B4349BCD5EEDAE44.pos</fid><responsible>false</responsible><fname>/集团总部/嘉通贸易/物流部/仓管员</fname></org-unit><org-unit><fid>/ORG01.ogn/2CA17AE6775D4B25BF58690494578FEC.ogn/AAAC42C7386A438DAA64A06233CD9902.dpt/1DFCB49BFC144053A900D9160EC2F027.pos/32D2B1C25FB64D92B3CDF9313D02EA46@1DFCB49BFC144053A900D9160EC2F027.psm</fid><responsible>false</responsible><fname>/集团总部/腾达贸易/财务部/会计1/许志权</fname></org-unit><org-unit><fid>/ORG01.ogn/2902CB41E6B94A198B9F71CD5EE15C0B.ogn/0B46D853ECA44B759787AA202A0A8BC9.dpt/4295AB2F67A34ADCAA79F24C6E6B9C8B.pos/068945D9BF654741871070BB9D35D469@4295AB2F67A34ADCAA79F24C6E6B9C8B.psm</fid><responsible>false</responsible><fname>/集团总部/粤通贸易/人资部/客户专员/余锦豪</fname></org-unit></executor-range><executors><org-unit><fid>/ORG01.ogn/2902CB41E6B94A198B9F71CD5EE15C0B.ogn/0B46D853ECA44B759787AA202A0A8BC9.dpt/4295AB2F67A34ADCAA79F24C6E6B9C8B.pos/068945D9BF654741871070BB9D35D469@4295AB2F67A34ADCAA79F24C6E6B9C8B.psm</fid><responsible>false</responsible><fname>/集团总部/粤通贸易/人资部/客户专员/余锦豪</fname></org-unit></executors><task-relation-value><sEURL>/yqf/scm/sale/process/SaleOrder/businessActivity7.a</sEURL><sLastModifyTime>2017-12-12T15:53:38.406Z</sLastModifyTime><sActivityName>仓库发货</sActivityName><sProcessTemplateID2/><SA_Task>4FFE23234A944232B299415E3608DF7B</SA_Task><sCURL>/yqf/scm/sale/process/SaleOrder/businessActivity3.a</sCURL><sProcess>/yqf/scm/sale/process/SaleOrder/saleOrderProcess</sProcess><sTypeName>销售订单申请</sTypeName><sLock>2C998F0C60424CC7A08A35D7896944D6</sLock><sActivity>businessActivity7</sActivity><sExecuteMode>temPreempt</sExecuteMode><sProcessName>销售订单申请</sProcessName><sName>仓库发货【深圳市龙岗区爱车已遇汽车美容生活馆】订单SO-2017121200130</sName><sActivityInTemplate>businessActivity7</sActivityInTemplate><sPreemptMode>tpmOpen</sPreemptMode></task-relation-value><exts/></process-control-item></to><notice><process-control-item is-end="false" activity-id="A61905B0F7D7450E84BDE7F6894EF21F" id="A61905B0F7D7450E84BDE7F6894EF21F" selected="true" readonly="false"><template/><executor-kinds>SM</executor-kinds><process>/yqf/scm/sale/process/SaleOrder/saleOrderProcess</process><unit>businessActivity3</unit><task-assign-mode>singleness</task-assign-mode><executor-range><org-unit><fid>/ORG01.ogn/2902CB41E6B94A198B9F71CD5EE15C0B.ogn/7A67F7CF95F24F12A803449238CBCB71.dpt/B3D7AD7E95694C4786BE34B02B7C6215.dpt</fid><responsible>false</responsible><fname>/集团总部/粤通贸易/营销部/营销一部</fname></org-unit></executor-range><executors><org-unit><fid>/ORG01.ogn/2902CB41E6B94A198B9F71CD5EE15C0B.ogn/7A67F7CF95F24F12A803449238CBCB71.dpt/B3D7AD7E95694C4786BE34B02B7C6215.dpt/1143B6D1F4424E46B4F991829DA8F951.pos/7E0DF62A0F3D4B3694DBC691E522B35B@1143B6D1F4424E46B4F991829DA8F951.psm</fid><responsible>false</responsible><fname>/集团总部/粤通贸易/营销部/营销一部/业务员/丘兆杰</fname></org-unit></executors><task-relation-value><sEURL>/yqf/scm/sale/process/SaleOrder/queryActivity.w</sEURL><sLastModifyTime>2017-12-12T15:53:38.406Z</sLastModifyTime><sActivityName>财务审批</sActivityName><SA_Task>C2780624BFF440EEA14A1CB168AF7700</SA_Task><sCURL>/yqf/scm/sale/process/SaleOrder/businessActivity3.a</sCURL><sProcess>/yqf/scm/sale/process/SaleOrder/saleOrderProcess</sProcess><sCatalogID>tsTask</sCatalogID><sExecuteMode2>finishWhenOpen</sExecuteMode2><sTypeName>销售订单申请</sTypeName><sLock>BAF290CED68C444993CE453E1C59028B</sLock><sActivity>businessActivity3</sActivity><sExecuteMode>temPreempt</sExecuteMode><sProcessName>销售订单申请</sProcessName><sName>恭喜您！订单审批通过,单号SO-2017121200130金额1,656.00元。</sName><sKindID>tkNotice</sKindID><sActivityInTemplate>businessActivity3</sActivityInTemplate><sPreemptMode>tpmOpen</sPreemptMode></task-relation-value><exts/></process-control-item></notice><exts/></process-control></xbizbject></parameter>        </parameters></action></actions>
com.justep.exception.BusinessException: 编码: JUSTEP150050; 提示: 回滚事务出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.Transaction.rollback(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Already closed.
        at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:114)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
        ... 23 more

jishuang

http://docs.wex5.com/bex5-deploy-question-list-4011/加上里面说的配置项

laijiaxing

加了之后报错，(对象名 'dual' 无效。)  登录报错     编码: JUSTEP180040; 提示: 查询用户出错
<action process="/SA/task/taskView/taskViewProcess" activity="mainActivity" name="queryWaitTaskAction" execute-context="" content-type="application/xml"><parameters/></action>
2017-12-12 17:18:12 Not registed session:2839A35C1144F182B8FF132EE052819F, jsessionid:JSESSIONID=1648D432CE3647A4B9FD51BC2B7ABD92, action: logout
2017-12-12 17:18:15 执行sql: insert into SA_Log  (sOperatingSystem, sDeviceType, sActivityName, sStatusName, sCreatorPersonName, version, SID, sProcess, sParameters, sActionName, sTypeName, sActivity, sCreateTime, sProcessName, sIP, sAction, $clientName ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue ), binds: [MAC_OS_X_IPAD, Mobile, 系统, 失败, thl, 0, 5E4E7B6A790441848AFCDABAD87355EE, /SA/OPM/system/systemProcess, ******, 登录, 操作日志, mainActivity, 2017-12-12 17:18:15.906, 系统调用, 192.168.10.1, loginAction]失败
com.justep.exception.BusinessException: 编码: JUSTEP150055; 提示: 在模块"/system/data"下获取数据库连接出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execSqlUpdate(Unknown Source)
        at com.justep.system.interceptor.LogBefore.loginLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.doActionLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
        at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (对象名 'dual' 无效。)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.justep.system.data.Transaction.getConnectionWithJndi(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: 对象名 'dual' 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 33 more
2017-12-12 17:18:15 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="loginAction" execute-context="" content-type="application/xml"><parameters><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">18918FE4E194988C89DB8686A57EE8DC</xbiz:simple></parameter><parameter name="name"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">thl</xbiz:simple></parameter><parameter name="loginDate"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Date">2017-12-12</xbiz:simple></parameter><parameter name="lang"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">zh_CN</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">Mobile</xbiz:simple></item><item key="OperatingSystem"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">MAC_OS_X_IPAD</xbiz:simple></item></xbiz:map></parameter><parameter name="ip"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">192.168.10.1</xbiz:simple></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.system.util.BizSystemException: 编码: JUSTEP180040; 提示: 查询用户出错
        at com.justep.system.util.BizSystemException.create(Unknown Source)
        at com.justep.system.opm.OrgUtils.select(Unknown Source)
        at com.justep.system.opm.OrgUtils.getPersonByDB(Native Method)
        at com.justep.system.opm.OrgUtils.getPerson(Unknown Source)
        at com.justep.system.opm.OrgUtils.login(Native Method)
        at com.justep.system.opm.OrgUtils.login1(Unknown Source)
        at OPMProcedure.login(OPMProcedure.java:124)
        at OPMProcedure.login(OPMProcedure.java:109)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select case when UPPER(p.sLoginName)=:name then 1 when UPPER(p.sCode)=:name then 2 else 3 end as odr , mo, mo.sFID, mo.sFName, mo.sFCode, p.* from SA_OPPerson p join SA_OPOrg mo ON p.sMainOrgID = mo where (UPPER(p.sLoginName)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr

jishuang

用的什么数据库？确认加的正确吗？

laijiaxing

使用SQL SERVER2008，按下面方法加
<Resource name="system"         auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://192.168.10.7:1433/X5DB;socketTimeout=60" username="sa" password="xxxxxxxxxxx" maxActive="10" maxIdle="5"        removeAbandoned="true" removeAbandonedTimeout="180" logAbandoned="true"  validationQuery=”select sysdate from dual;” />

jishuang

到数据库中执行select sysdate from dual;看看正确吗？

laijiaxing

消息 208，级别 16，状态 1，第 3 行
对象名 'dual' 无效。

jishuang

改为select 1看看

laijiaxing

昨晚重启了服务器，暂时没有出现“回滚事务出错”  ，默默问一下，增加validationQuery=”select 1” 是何目的？怎理解？