i访问用户和机构表报错ORA-04063

本帖最后由 西瓜小姐 于 2018-9-14 14:33 编辑

之前本机的i一直在使用没有这个报错，近期做了单点登陆，便出现这个报错，网上有说授权问题，但具体我也不知咋操作，请大神指教主要是用户和机构表报错，其他没有问题，i版本i52

截图201809141423002020.png (74.68 KB, 下载次数: )

下载附件

2018-9-14 14:23 上传

QueryObj ERROR:/i52126/esmain/dbmgr.do?sql=select%20*%20from%20ES10_VORG&datasource=ES%2433%24&action=exesql&limit=100&start=0
com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-04063: view "IZYDB01.ES10_VORG" 有错误

  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:745)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
  at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
  at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)
  at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
  at com.esen.jdbc.pool.impl.oracle.OraclePooledStatement.executeQuery(OraclePooledStatement.java:22)
  at com.esen.platform.sysmgr.dbmgr.DbExeSqlResult.initTotalCount(DbExeSqlResult.java:254)
  at com.esen.platform.sysmgr.dbmgr.DbExeSqlResult.init(DbExeSqlResult.java:84)
  at com.esen.platform.sysmgr.dbmgr.DbExeSqlResult.(DbExeSqlResult.java:75)
  at com.esen.platform.action.sysmgr.ActionDbMgr.getSqlResult(ActionDbMgr.java:1438)
  at com.esen.platform.action.sysmgr.ActionDbMgr.jsexecute(ActionDbMgr.java:313)
  at com.esen.weblib.action.Action_Js.jsexecute(Action_Js.java:282)
  at com.esen.weblib.action.Action_Js.execute(Action_Js.java:73)
  at com.esen.platform.action.sysmgr.ActionDbMgr.execute(ActionDbMgr.java:217)
  at com.esen.weblib.action.Action.handle(Action.java:66)
  at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
  at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
  at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
  at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
  at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  at com.esen.platform.web.ReleasabledServlet.service(ReleasabledServlet.java:93)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at com.esen.platform.action.FilterLoginCheck.doFilter(FilterLoginCheck.java:95)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at com.esen.platform.web.PlatformLocaleContextFilter.doFilter(PlatformLocaleContextFilter.java:47)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at com.esen.i.action.EsmainActionFilter.doFilter(EsmainActionFilter.java:42)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  at com.esen.util.sso.master.LogoutFilter.doFilter(LogoutFilter.java:57)
  at com.esen.platform.sso.SSODelegatingFilter.doFilter(SSODelegatingFilter.java:30)
  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:128)
  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:293)
  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
  at java.lang.Thread.run(Thread.java:619)



JavaScript StackTrace:
function querycallback(q){try{q.checkResult();var detail=q.getDetail();var rs=eval("("+detail+")");if(rs.fields){exesql.xui.getDomById("result").style.display="";exesql.xui.getDomById("updateresult").style.display="none";var xlistpnt=exesql.xui.getDomById("tabWithData");xlistpnt.style.display="";clearAllContent(xlistpnt);exesql.xlist=new XList(window,xlistpnt,"100%","100%",rs.fields);exesql.xlist.setRowHeight(ExeSql.lineheight);exesql.xlist.setTextSelected(true);if(rs.datas){for(var i=0;ilimit;if(needPageNavbar){var ri=new resultData("text",limit,rs.totalcount,exesql.start,rs.hasMoreData);if(ri){var pageDom=document.getElementById("tr_pagerow");pageDom.style.display="";if(isie6){pageDom.style.marginTop="25px";pageDom.style.left="0%";pageDom.style.bottom="0";pageDom.style.paddingBottom="0";}var xpageparent=document.getElementById("tr_pagecell");clearAllContent(xpageparent);new XPageBar(xpageparent,ri,_XPage$OnShowPageCallback);}}else{document.getElementById("tr_pagerow").style.display="none";}var tr=exesql.xlist._headTable.childNodes[0].childNodes[0];var lastTd=tr.childNodes[tr.childNodes.length-1];lastTd.style.width="120px";}else{document.getElementById("tr_pagerow").style.display="none";}exesql.xui.getComponentById("_exesql_splitpane").doLayout();}else{exesql.xui.getDomById("result").style.display="";exesql.xui.getDomById("tabWithData").style.display="none";exesql.xui.getDomById("updateresult").style.display="";exesql.xui.getDomById("rowcount").innerText=rs.rows;var pageDiv=document.getElementById("tr_pagerow");if(pageDiv){pageDiv.style.display="none";}if(rs.iscreate||rs.isdelete){exesql.parentWindow.progressFinishEvent(exesql.getDataSource());}}this.setSqlValue();}catch(e){showError(e);}}

function(){this._lastReadyState=this.hp.readyState;if(this.hp.readyState==4){this._clearTimeoutTimer();if(this.hp.status==undefined||this.hp.status==0||this.hp.status>12000){if(this._retry()){return;}}var onfinish=this.onfinish;if(typeof(onfinish)=="function"){onfinish(this,this.userdata);}else{eval(onfinish);}if(this.autodispose){this.dispose();}}}

function(){j._onreadystatechange();}