|
|
2019-11-18 16:01:28 action:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:justep="http://www.justep.com/x5#" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns xf="http://www.orbeon.com/oxf/processors" xmlns:ns="http://www.justep.com/x5#" xmlns:xbiz="http://www.justep.com/xbiz#" activity="mainActivity" process="/SA/OPM/system/systemProcess" name="queryDataTestAction"><parameters><parameter name="ksql"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">select HR_TrainPerson.*,HR_TrainApply.FB_BizNO as FB_BizNO,HR_TrainApply.fPlanName as fPlanName,HR_TrainApply.fTrainType as fTrainType,HR_TrainApply.fTrainForm as fTrainForm,HR_TrainApply.fContentType as fContentType,HR_TrainApply.fTrainCourseName as fTrainCourseName,HR_TrainApply.fYear as fYear,HR_TrainApply.fStartTime as fStartTime,HR_TrainApply.fStopTime as fStopTime,HR_TrainApply.fAllHour as fAllHour,HR_TrainApply.fTrainContent as fTrainContent,SA_OPOrg,SA_OPOrg.sName as sName,SA_OPOrg.sCode as sCode,SA_OPOrg.sLongName as sLongName,SA_OPOrg.sFName as sFName,SA_OPOrg.sFCode as sFCode,SA_OPOrg.sFID as sFID,SA_OPOrg.sOrgKindID as sOrgKindID,SA_OPOrg.sSequence as sSequence,SA_OPOrg.sValidState as sValidState,SA_OPOrg.sParent as sParent,SA_OPOrg.sChildren as sChildren,SA_OPOrg.sLevel as sLevel,SA_OPOrg.sPhone as sPhone,SA_OPOrg.sFax as sFax,SA_OPOrg.sAddress as sAddress,SA_OPOrg.sZip as sZip,SA_OPOrg.sDescription as sDescription,SA_OPOrg.sPersonID as sPersonID,SA_OPOrg.sNodeKind as sNodeKind,SA_OPOrg.version as version from HR_TrainPerson HR_TrainPerson optional join HR_TrainApply HR_TrainApply on HR_TrainPerson.FBD_MasterID = HR_TrainApply optional join SA_OPOrg SA_OPOrg on HR_TrainPerson.fEmployeeID = SA_OPOrg.sPersonID LIMIT 0, 50</xbiz:simple></parameter><parameter name="dataModel"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">/rbc_HR/trainManageHR/data</xbiz:simple></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
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: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: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:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select HR_TrainPerson.*,HR_TrainApply.FB_BizNO as FB_BizNO,HR_TrainApply.fPlanName as fPlanName,HR_TrainApply.fTrainType as fTrainType,HR_TrainApply.fTrainForm as fTrainForm,HR_TrainApply.fContentType as fContentType,HR_TrainApply.fTrainCourseName as fTrainCourseName,HR_TrainApply.fYear as fYear,HR_TrainApply.fStartTime as fStartTime,HR_TrainApply.fStopTime as fStopTime,HR_TrainApply.fAllHour as fAllHour,HR_TrainApply.fTrainContent as fTrainContent,SA_OPOrg,SA_OPOrg.sName as sName,SA_OPOrg.sCode as sCode,SA_OPOrg.sLongName as sLongName,SA_OPOrg.sFName as sFName,SA_OPOrg.sFCode as sFCode,SA_OPOrg.sFID as sFID,SA_OPOrg.sOrgKindID as sOrgKindID,SA_OPOrg.sSequence as sSequence,SA_OPOrg.sValidState as sValidState,SA_OPOrg.sParent as sParent,SA_OPOrg.sChildren as sChildren,SA_OPOrg.sLevel as sLevel,SA_OPOrg.sPhone as sPhone,SA_OPOrg.sFax as sFax,SA_OPOrg.sAddress as sAddress,SA_OPOrg.sZip as sZip,SA_OPOrg.sDescription as sDescription,SA_OPOrg.sPersonID as sPersonID,SA_OPOrg.sNodeKind as sNodeKind,SA_OPOrg.version as version from HR_TrainPerson HR_TrainPerson optional join HR_TrainApply HR_TrainApply on HR_TrainPerson.FBD_MasterID = HR_TrainApply optional join SA_OPOrg SA_OPOrg on HR_TrainPerson.fEmployeeID = SA_OPOrg.sPersonID LIMIT 0, 50
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.KSQL.select(Unknown Source)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT HR_TrainPerson.fID AS HR_TrainPerson, HR_TrainPerson.VERSION AS HR_TrainPerson_version, HR_TrainPerson.FBD_MASTERID AS FBD_MasterID, HR_TrainPerson.FEMPLOYEEID AS fEmployeeID, HR_TrainPerson.FEMPLOYEENAME AS fEmployeeName, HR_TrainPerson.FPOST AS fPost, HR_TrainPerson.FPOSTID AS fPostID, HR_TrainPerson.FDATE AS fDate, HR_TrainPerson.FRESULT AS fResult, HR_TrainPerson.FB_NOTE AS FB_Note, HR_TrainPerson.FB_DEPTID AS FB_DeptID, HR_TrainPerson.FB_ORGID AS FB_OrgID, HR_TrainApply.FB_BIZNO AS FB_BizNO, HR_TrainApply.FPLANNAME AS fPlanName, HR_TrainApply.FTRAINTYPE AS fTrainType, HR_TrainApply.FTRAINFORM AS fTrainForm, HR_TrainApply.FCONTENTTYPE AS fContentType, HR_TrainApply.FTRAINCOURSENAME AS fTrainCourseName, HR_TrainApply.FYEAR AS fYear, HR_TrainApply.FSTARTTIME AS fStartTime, HR_TrainApply.FSTOPTIME AS fStopTime, HR_TrainApply.FALLHOUR AS fAllHour, HR_TrainApply.FTRAINCONTENT AS fTrainContent, SA_OPOrg.sID, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg__1.sID AS sChildren, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.VERSION AS version FROM HR_TRAINPERSON HR_TrainPerson LEFT JOIN HR_TrainApply HR_TrainApply ON HR_TrainPerson.FBD_MASTERID = HR_TrainApply.fID LEFT JOIN (SA_OPOrg SA_OPOrg LEFT JOIN SA_OPOrg SA_OPOrg__1 ON SA_OPOrg.sID = SA_OPOrg__1.sParent ) ON HR_TrainPerson.FEMPLOYEEID = SA_OPOrg.SPERSONID), binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 31 more
Caused by: java.sql.SQLException: ORA-04063: view "TRBIZ.SA_OPORG" 有错误
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 32 more
|
|
IP卡
狗仔卡
发表于 2019-11-18 16:02:25
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2019-11-18 16:33:09
楼主