［结］升级3012中出现的问题**

Crazy_wen2006

文档服务在数据库中叫什么名字？好像没有找到

jiahaiming

有14张表，具体名字我记不清了
楼主在论坛里搜索一下吧，以前有人讨论过。

Crazy_wen2006

14张数据表，分别是：APPLIED_PATCH，CHILD_ASSOC，EXTERNALKEYS，FIRST，NODE，NODE_ASPECTS，NODE_ASSOC，NODE_PERMISSION，NODE_PERM_ENTRY，NODE_PROPERTIES，NODE_STATUS，PERMISSION_REF，RECIPIENT，STORE， VERSION_COUNT
这14张表是关于文档服务的吗？我在我的数据库里搜索了一下，没有找到

Akon

楼主在系统库看一下，在系统库中的。

Crazy_wen2006

test
我是在那个搜索栏目里面搜索的，提示没有找到，每个数据库下面都看了也没有

在安装3012升级包出现的
2008-4-16 17:17:52
执行升级包“D:justep3012X3 ServerinUpgradeBPLsX3_2008-03-12.bpl”失败：

是不是与此有关？


有时在搜索的时候出现如下错误，也是提示ExecuteSQL error: : 表或视图不存在
java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
        at oracle.jdbc.driver.T2CStatement.execute_for_describe(T2CStatement.jav
a:841)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleState
ment.java:896)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:986)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1125)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(Delegati
ngStatement.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.GeneratedMethodAccessor122.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: SELECT * FROM OMST
2008-4-18 13:28:08 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-0094
2: 表或视图不存在

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.GeneratedMethodAccessor122.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-00942: 表或视图不存在

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
        at oracle.jdbc.driver.T2CStatement.execute_for_describe(T2CStatement.jav
a:841)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleState
ment.java:896)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:986)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1125)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(Delegati
ngStatement.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.GeneratedMethodAccessor122.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: SELECT * FROM OMST
2008-4-18 13:28:09 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-0094
2: 表或视图不存在

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.GeneratedMethodAccessor122.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)
Time: 2008-4-18 15:3:15

jiahaiming

楼主，那些表在建模工具里看不到。需要到数据库里看。

另外，请检查“TDocSystem，TFunctreeview表，业务系统表”是否存在，如果在studio中可以看到，那么看能否预览数据。

Crazy_wen2006

刚在数据库里面搜索了一下，“FIRST”与“VERSION_COUNT”不存在，其余都在。
刚在studio中可以找到“TDocSystem，TFunctreeview表，业务系统信息表”并可以预览。

jiahaiming

看楼主的描述，应该是文档服务的表的不存在了。

正常启动一次文档服务，系统会自动创建这些表的。

Crazy_wen2006

问一个很菜的问题，文档服务如何启动

lixy

是跟tomcat一块启动的。