|
|
服务器本来好好的
然后用imp做了个数据导入操作
然后报告如下错误:
重新生成文件系统缓存。
生成文件系统缓存完毕，耗时：8469毫秒。
java.sql.SQLException: ORA-01114: 将块写入文件 %s 时出现 IO 错误 (块 # %s)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.fetch(OCIDBAccess.java:2009)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2400)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:267
2)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:572)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement
.java:205)
at com.justep.service.database.Query.doOpen(Unknown Source)
at com.justep.service.database.Query.open(Unknown Source)
at com.justep.service.database.Query.setActive(Unknown Source)
at com.justep.service.action.database.GetRecordsAction.doExecute(Unknown Source)
at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
at com.justep.service.action.base.SupportAction.execute(Unknown Source)
at com.justep.service.action.base.SupportAction.execute(Unknown Source)
at com.justep.service.BizServiceImp.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a: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(ApplicationFilt
erChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
13)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
78)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107
)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http1
1AprProtocol.java:652)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
at java.lang.Thread.run(Thread.java:595)
CommandText: SELECT WZKCXXB.WZBM, WZKCXXB.GSBM, WZKCXXB.KCSL, WZXXB.DLDM, WZXXB.XLDM, WZXXB
.JLDWBM, WZXXB.WZMC, WZXXB.GGXH, WZXXB.WZBM
FROM WZKCXXB, WZXXB
ORDER BY WZKCXXB.WZBM
2008-12-6 21:55:19 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-01114: 将块写入
文件 %s 时出现 IO 错误 (块 # %s)
java.lang.Exception: error occur during invoke getRecords method, ORA-01114: 将块写入文件 %
s 时出现 IO 错误 (块 # %s)
at com.justep.service.action.database.GetRecordsAction.doExecute(Unknown Source)
at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
at com.justep.service.action.base.SupportAction.execute(Unknown Source)
at com.justep.service.action.base.SupportAction.execute(Unknown Source)
at com.justep.service.BizServiceImp.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a: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(ApplicationFilt
erChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
13)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
78)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107
)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http1
1AprProtocol.java:652)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
at java.lang.Thread.run(Thread.java:595)
Time: 2008-12-7 8:48:23
Time: 2008-12-7 8:48:26
java.sql.SQLException: ORA-03114: 未连接到 ORALCE
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:1255)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:267
2)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:572)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement
.java:205)
at com.justep.service.database.Query.doOpen(Unknown Source)
at com.justep.service.database.Query.open(Unknown Source)
at com.justep.service.database.Query.setActive(Unknown Source)
at com.justep.service.action.database.GetRecordsAction.doExecute(Unknown Source)
at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
at com.justep.service.action.base.SupportAction.execute(Unknown Source)
at com.justep.service.action.base.SupportAction.execute(Unknown Source)
at com.justep.service.BizServiceImp.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a: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(ApplicationFilt
erChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
13)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
78)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107
)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http1
1AprProtocol.java:652)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
at java.lang.Thread.run(Thread.java:595)
CommandText: SELECT ScopeTarget AS "机会指标", COUNT(CRM_CUSTOMER.CustomerID) AS "个数_编号
"
FROM CRM_CUSTOMER
WHERE (CRM_Customer.NOUSE = 0) AND (((CRM_CUSTOMER.ClientAccount = 'ZBM')) and (((FSales
= 'lk') or (Consulter='lk') or (RegPerson='lk)) or TechnicPrinci = 'LK'or FSales lik
e '%' or (RegPerson = '公用' or FSales = '公用' or Consulter = '公用' or TechnicPrinci = '
公用') ))
GROUP BY ScopeTarget
ORDER BY ScopeTarget |
|
发表于 2008-12-7 09:53:58