如何迁移docServer中的部门附件到另一个服务器

lygyy007

SA_DocNode中sParentID和sDocPath中值已经更新为新的文档服务器的sID值，但是还是报juestp.Doc.queryDocInfoById，是还要改什么吗

jishuang

报错发tomcat控制台的完整错误信息

lygyy007

2018-06-15 09:44:34 [TP-Processor3] [com.justep.business.server.BusinessServer] ERROR: excute stream action, params:{"accept":"application/json","action":"queryDocInfoByIdAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"/100000.ogn/100019.dpt/200857@100019.psm","parameters":{"docVersion":"last","fileId":"228440-defaultDocNameSpace","host":"/CD2FCF25D125429D997D5B7C7A51B6C4","isHttps":false},"process":"/SA/doc/system/systemProcess"}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:40)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:347)
        at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:227)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:311)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.doc.exception.DocRTException: 编码: JUSTEP300008; 提示: 请求文档服务失败:HTTP/1.1 500 Internal Server Error
        at com.justep.doc.DocUtils.excutePostAction(DocUtils.java:193)
        at com.justep.doc.DocDBHelper.queryDocInfoById(DocDBHelper.java:248)
        at com.justep.doc.DocAdapter.queryDocInfoById(DocAdapter.java:677)
        ... 33 more

jishuang

请求文档服务失败:HTTP/1.1 500 Internal Server Error
这个错误说明文档服务器都没启动成功

看文档服务器上的报错信息

lygyy007

文档服务器应该是正常启动了的，我看了文档服务器的日志也没有报错。2018-06-15 10:24:14 [ActiveMQ Cleanup Timer] [org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] DEBUG: Cleaning up old messages.
2018-06-15 10:24:14 [ActiveMQ Cleanup Timer] [org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter] DEBUG: Executing SQL: DELETE FROM ACTIVEMQ_MSGS WHERE ( EXPIRATION<>0 AND EXPIRATION<?) OR ID <= ( SELECT min(ACTIVEMQ_ACKS.LAST_ACKED_ID) FROM ACTIVEMQ_ACKS WHERE ACTIVEMQ_ACKS.CONTAINER=ACTIVEMQ_MSGS.CONTAINER)
2018-06-15 10:24:14 [ActiveMQ Cleanup Timer] [org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter] DEBUG: Deleted 0 old message(s).
2018-06-15 10:24:14 [ActiveMQ Cleanup Timer] [org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] DEBUG: Cleanup done.
2018-06-15 10:24:15 [catalina-exec-37] [org.outerj.daisy.authentication.impl.DaisyAuthenticationFactory] DEBUG: 通过org.outerj.daisy.repository.serverimpl.LocalDocumentStrategy.loadDocumentInTransaction获取到的[Oracle]sql是select created, last_modified, last_modifier, owner, private, reference_lang_id, updatecount from documents where id = ? and ns_id = ?

之前你回复的帖子里，我画圈的地方我不太明白是什么意思就没有操作，SA_DocNode是已经改掉了。

jishuang

文档服务器需要一个doc数据源
doc数据源连接的数据库中的数据也需要在新的文档服务器连接的doc数据源中有配置啊


浏览器中http://IP:端口/DocServer都可以访问成功吗？
在文档中心新上传一个文件操作正确吗？

lygyy007

可以成功访问，也能成功上传附件。

jishuang

500错误确认文档服务器中没有报错？确认SA_DocNode中的数据修改的是否正确
看新上传的生成的记录，跟自己修改的有什么不同？

lygyy007

在Sa_DocNode中把SPARENTID,SDOCDISPLAYPATH字段都改过了，也看了两个文档服务器的日志好像是没啥报错。我把日志发到附件上你们看看呢。

jishuang

确认操作的是不是这个文件，换一个其他的文件操作看看