【搞定】请解决一下**

泉海天轻纺

这个是什么问题？
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
        at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java)
        at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(Delegat
ingStatement.java:225)
        at com.justep.service.database.Query.doExecSimpleSQL(Unknown Source)
        at com.justep.service.database.Query.doExecuteSQL(Unknown Source)
        at com.justep.service.database.Query.executeSQL(Unknown Source)
        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.ActionSupport.execute(Unknown Source)
        at com.justep.service.action.base.ActionSupport.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
CommandText: DROP TABLE HTTDBA.FM_ACC_RECMAIN_VIEW
2007-1-25 14:16:44 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: ExecuteSQL error: ORA-00942: 表或视图不存在

java.lang.Exception: ExecuteSQL error: ORA-00942: 表或视图不存在

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
重新生成文件系统缓存。
生成文件系统缓存完毕，耗时：17907毫秒。
Time: 2007-1-25 14:20:44
Time: 2007-1-25 14:25:40
重新生成文件系统缓存。
生成文件系统缓存完毕，耗时：18031毫秒。
2007-1-25 14:30:14 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occurred during Invoke GetMetaDataParamORA-0170
2: 此处不允许有视图

java.lang.Exception: error occurred during Invoke GetMetaDataParamORA-01702: 此
处不允许有视图

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: ORA-01451: 要修改为 NULL 的列无法修改为 NULL

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java)
        at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java)
        at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(Delegat
ingStatement.java:225)
        at com.justep.service.database.Query.doExecSimpleSQL(Unknown Source)
        at com.justep.service.database.Query.doExecuteSQL(Unknown Source)
        at com.justep.service.database.Query.executeSQL(Unknown Source)
        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.database.BatchCallAction.innerExec(Unknown
Source)
        at com.justep.service.action.database.BatchCallAction.execute(Unknown So
urce)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
CommandText: Alter Table FM_FEESTAFFNUM Modify( StaffNum NUMBER(15, 0) NULL )
java.lang.Exception: ExecuteSQL error: ORA-01451: 要修改为 NULL 的列无法修改为 N
ULL

        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.database.BatchCallAction.innerExec(Unknown
Source)
        at com.justep.service.action.database.BatchCallAction.execute(Unknown So
urce)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
2007-1-25 14:35:25 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: invoke batch method error, ExecuteSQL error: ORA-0145
1: 要修改为 NULL 的列无法修改为 NULL

java.lang.Exception: invoke batch method error, ExecuteSQL error: ORA-01451: 要
修改为 NULL 的列无法修改为 NULL

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)

aPanther

楼主有三个ORACLE的错误：
具体请看

ORA-01451  请参考:
http://blog.donews.com/cytihuntor/archive/2005/08/25/525914.aspx
http://topic.csdn.net/t/20050525/11/4033910.html

ORA-01702  请参考:
http://www.itpub.net/404356.html
http://www.cnoug.org/thread-32987-1-1.html

ORA-00942  请参考:
http://www.itpub.net/99982.html
http://www.5blogs.com/rss/blog/200681120845223.6683127701.htm

泉海天轻纺

谢谢，可是这样子会把整个平台死掉了，其它人都不能用，这样我们就重启电脑？
是不是对数据库有影响，就会造成业务平台和建模死掉吗？

aPanther

你们是做什么动作后出现这些提示的？

泉海天轻纺

我在业务平台里添加记录时，不能保存，他们在建模开发时，不能使用。就打开服务器tomcat 时，看到1楼的信息。

aPanther

楼主，说的太简单了点
你根据2楼的方法来修改吧，不过最好是周末，没有人连接的时候。
错误都是ORACLE报出来的哦。

aPanther

由于楼主长时间没有回复，这个帖子就先结了。