【结贴】表或视图不存在**

weirongjia · 发表于 2008-9-7 17:49:47

Reloading Config File...
16:54:30,515 INFO  [admin.patch.PatchExecuter] Checking for patches to apply ...
16:54:30,562 INFO  [admin.patch.PatchExecuter] No patches were required.
16:54:30,562 INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_04-b05; max
imum heap size 1016.125MB
16:54:30,562 INFO  [service.descriptor.DescriptorService] Alfresco started (Open Source) -
v1.2.0 (RC2); repository v1.2.0 (RC2); schema 5
2008-9-7 16:54:30 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8081
2008-9-7 16:54:30 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2008-9-7 16:54:30 org.apache.catalina.storeconfig.StoreLoader load
信息: Find registry server-registry.xml at classpath resource
2008-9-7 16:54:30 org.apache.catalina.startup.Catalina start
信息: Server startup in 13359 ms
重新生成文件系统缓存。
生成文件系统缓存完毕，耗时：8485毫秒。
重新生成组织机构缓存。公司：ZBM
生成组织机构缓存完毕，耗时：1360毫秒。
Time: 2008-9-7 17:12:13
java.sql.SQLException: ORA-00942: 表或视图不存在

      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.GeneratedMethodAccessor121.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
= '朱文芝') or (Consulter='朱文芝') or (RegPerson='朱文芝')) or TechnicPrinci = 'ZWZ'or FSa
les like '%' or (RegPerson = '公用' or FSales = '公用' or Consulter = '公用' or TechnicPrin
ci = '公用') ))
  GROUP BY ScopeTarget
  ORDER BY ScopeTarget
2008-9-7 17:12:32 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-00942: 表或视图
不存在

java.lang.Exception: error occur during invoke getRecords method, ORA-00942: 表或视图不存在

      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.GeneratedMethodAccessor121.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)
java.sql.SQLException: ORA-00942: 表或视图不存在

      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.GeneratedMethodAccessor121.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
= '朱文芝') or (Consulter='朱文芝') or (RegPerson='朱文芝')) or TechnicPrinci = 'ZWZ'or FSa
les like '%' or (RegPerson = '公用' or FSales = '公用' or Consulter = '公用' or TechnicPrin
ci = '公用') ))
  GROUP BY ScopeTarget
  ORDER BY ScopeTarget
2008-9-7 17:12:32 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-00942: 表或视图
不存在

java.lang.Exception: error occur during invoke getRecords method, ORA-00942: 表或视图不存在

      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.GeneratedMethodAccessor121.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)
java.sql.SQLException: ORA-00942: 表或视图不存在

      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.GeneratedMethodAccessor121.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
= '朱文芝') or (Consulter='朱文芝') or (RegPerson='朱文芝')) or TechnicPrinci = 'ZWZ'or FSa
les like '%' or (RegPerson = '公用' or FSales = '公用' or Consulter = '公用' or TechnicPrin
ci = '公用') ))
  GROUP BY ScopeTarget
  ORDER BY ScopeTarget
2008-9-7 17:12:32 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-00942: 表或视图
不存在

java.lang.Exception: error occur during invoke getRecords method, ORA-00942: 表或视图不存在

      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.GeneratedMethodAccessor121.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

这是服务器报的错误
请帮看看吧？

zfang · 发表于 2008-9-7 21:13:52

CRM_CUSTOMER看看这个表或者视图存在吗？

weirongjia · 发表于 2008-9-8 09:59:29

没有这个表
所有以crm开头的表都不存在
那我从别的地方把这几个表导入可以么？

zfang · 发表于 2008-9-8 10:03:50

哦，那应该可以吧。具体你看看。这些都是你们自己做得功能里要用到的表吧？

weirongjia · 发表于 2008-9-8 10:09:20

没有这个表
所有以crm开头的表都不存在
那我从别的地方把这几个表导入可以么？

weirongjia · 发表于 2008-9-8 10:10:35

没有
不是我做的这个好像是系统带的客户关系管理里的表

shangxy · 发表于 2008-9-8 10:14:08

平台自带的表，可以检查一下你服务端配置工具中业务系统数据库的连接是否正确，
如果正确还是报告这个错误，那就打开studio把那个数据库中5张表创建一下物理表就可以了

weirongjia · 发表于 2008-9-8 15:13:49

恩
好的谢谢两位老师
结贴吧

		自动登录	找回密码
密码			立即注册