|
|
楼主 |
发表于 2014-7-15 15:58:13
|
显示全部楼层
<action direct-execute="true" process="/HR/archives/process/borrowApplyQuery/borrowApplyQueryProcess" activity="borrowApplyQueryActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="queryHR_ACV_BorrowApplyAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="filter"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[(HR_ACV_BorrowApply.fSource = '流程') AND (fBizState IN ('bsEditing','bsExecuting','bsFinished')) AND ((fCreatePsnID = 'PSN01') OR (HR_ACV_BorrowApply IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM HR_ACV_Execute EXECUTE_CONCEPT WHERE EXECUTE_CONCEPT.fCreatePsnID = 'PSN01') ))]]></xbiz:simple></parameter><parameter name="offset"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">0</xbiz:simple></parameter><parameter name="limit"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">20</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fBorrowDept,fBorrowerID,fBorrower,fSecretLevel,fSecretCode,fSecretName,fExigenceLevel,fExigenceCode,fExigenceName,fRemark,fApplyDate,fRequireDate,fPlanReturnDate,fBorrowReason,fAcvStateCode,fAcvStateName,fAcvTitle,fBizState,fBizStateName,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePosID,fCreatePosName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreatePsnFName,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,fCurrentActivities,fCurrentExecutors,fTitle,fAttachment,fSource,HR_ACV_BorrowApply]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fCreateTime DESC]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="HR_ACV_BorrowApply" sequence="recNO,fBizStateName,fAcvTitle,fBorrowDept,fBorrower,fSecretName,fExigenceName,fApplyDate,fPlanReturnDate,fBorrowReason,space-column,version,fBorrowerID,fSecretLevel,fSecretCode,fExigenceLevel,fExigenceCode,fRemark,fRequireDate,fAcvStateCode,fAcvStateName,fBizState,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePosID,fCreatePosName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreatePsnFName,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,fCurrentActivities,fCurrentExecutors,fTitle,fAttachment,fSource"/></translate-parameter></action>
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT HR_ACV_BorrowApply.* FROM HR_ACV_BorrowApply HR_ACV_BorrowApply WHERE ((HR_ACV_BorrowApply.fSource = '流程') AND (fBizState IN ('bsEditing','bsExecuting','bsFinished')) AND ((fCreatePsnID = 'PSN01') OR (HR_ACV_BorrowApply IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM HR_ACV_Execute EXECUTE_CONCEPT WHERE EXECUTE_CONCEPT.fCreatePsnID = 'PSN01') ))) ORDER BY fCreateTime DESC LIMIT 0, 20
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT HR_ACV_BorrowApply.VERSION AS version, HR_ACV_BorrowApply.FBORROWDEPT AS fBorrowDept, HR_ACV_BorrowApply.FBORROWERID AS fBorrowerID, HR_ACV_BorrowApply.FBORROWER AS fBorrower, HR_ACV_BorrowApply.FSECRETLEVEL AS fSecretLevel, HR_ACV_BorrowApply.FSECRETCODE AS fSecretCode, HR_ACV_BorrowApply.FSECRETNAME AS fSecretName, HR_ACV_BorrowApply.FEXIGENCELEVEL AS fExigenceLevel, HR_ACV_BorrowApply.FEXIGENCECODE AS fExigenceCode, HR_ACV_BorrowApply.FEXIGENCENAME AS fExigenceName, HR_ACV_BorrowApply.FREMARK AS fRemark, HR_ACV_BorrowApply.FAPPLYDATE AS fApplyDate, HR_ACV_BorrowApply.FREQUIREDATE AS fRequireDate, HR_ACV_BorrowApply.FPLANRETURNDATE AS fPlanReturnDate, HR_ACV_BorrowApply.FBORROWREASON AS fBorrowReason, HR_ACV_BorrowApply.FACVSTATECODE AS fAcvStateCode, HR_ACV_BorrowApply.FACVSTATENAME AS fAcvStateName, HR_ACV_BorrowApply.FACVTITLE AS fAcvTitle, HR_ACV_BorrowApply.FBIZSTATE AS fBizState, HR_ACV_BorrowApply.FBIZSTATENAME AS fBizStateName, HR_ACV_BorrowApply.FCREATEOGNID AS fCreateOgnID, HR_ACV_BorrowApply.FCREATEOGNNAME AS fCreateOgnName, HR_ACV_BorrowApply.FCREATEDEPTID AS fCreateDeptID, HR_ACV_BorrowApply.FCREATEDEPTNAME AS fCreateDeptName, HR_ACV_BorrowApply.FCREATEPOSID AS fCreatePosID, HR_ACV_BorrowApply.FCREATEPOSNAME AS fCreatePosName, HR_ACV_BorrowApply.FCREATEPSNID AS fCreatePsnID, HR_ACV_BorrowApply.FCREATEPSNNAME AS fCreatePsnName, HR_ACV_BorrowApply.FCREATEPSNFID AS fCreatePsnFID, HR_ACV_BorrowApply.FCREATEPSNFNAME AS fCreatePsnFName, HR_ACV_BorrowApply.FCREATETIME AS fCreateTime, HR_ACV_BorrowApply.FUPDATEPSNID AS fUpdatePsnID, HR_ACV_BorrowApply.FUPDATEPSNNAME AS fUpdatePsnName, HR_ACV_BorrowApply.FUPDATETIME AS fUpdateTime, HR_ACV_BorrowApply.FCURRENTACTIVITIES AS fCurrentActivities, HR_ACV_BorrowApply.FCURRENTEXECUTORS AS fCurrentExecutors, HR_ACV_BorrowApply.FTITLE AS fTitle, HR_ACV_BorrowApply.FATTACHMENT AS fAttachment, HR_ACV_BorrowApply.FSOURCE AS fSource, HR_ACV_BorrowApply.fID AS HR_ACV_BorrowApply FROM HR_ACV_BorrowApply HR_ACV_BorrowApply WHERE (HR_ACV_BorrowApply.FSOURCE = ?) AND ( fBizState IN (?, ?, ?) ) AND ( (fCreatePsnID = ?) OR (HR_ACV_BorrowApply.fID IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM HR_Pub_Execute EXECUTE_CONCEPT WHERE (EXECUTE_CONCEPT.FCREATEPSNID = ?) AND (EXECUTE_CONCEPT.fBizkind = '人事档案处理信息表'))) ) ORDER BY fCreateTime DESC, binds: [流程, bsEditing, bsExecuting, bsFinished, PSN01, PSN01]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: 对象名 'HR_Pub_Execute' 无效。
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.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 31 more |
|
IP卡
狗仔卡
发表于 2014-7-15 15:52:54
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
