5.27的OA在3.8中的配置

yebm0086

我按照5,。27中的OA产品部署说明去部署的，（把产品资源覆盖到3.8的目录，数据库覆盖到3.8的data）可是连数据库都不能启动，为什么，是我部署有问题吗，还是有其他的我没有做到，



2018-06-15 16:30:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-06-15 16:30:59 0 [Note] mysqld (mysqld 5.6.26) starting as process 24192 ...
2018-06-15 16:30:59 24192 [Note] Plugin 'FEDERATED' is disabled.
2018-06-15 16:30:59 24192 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-06-15 16:30:59 24192 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-15 16:30:59 24192 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-06-15 16:30:59 24192 [Note] InnoDB: Memory barrier is not used
2018-06-15 16:30:59 24192 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-06-15 16:30:59 24192 [Note] InnoDB: Not using CPU crc32 instructions
2018-06-15 16:30:59 24192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-15 16:30:59 24192 [Note] InnoDB: Completed initialization of buffer pool
2018-06-15 16:30:59 24192 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-15 16:30:59 24192 [Note] InnoDB: Log scan progressed past the checkpoint lsn 93172246
2018-06-15 16:30:59 24192 [Note] InnoDB: Database was not shutdown normally!
2018-06-15 16:30:59 24192 [Note] InnoDB: Starting crash recovery.
2018-06-15 16:30:59 24192 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-06-15 16:30:59 24192 [Note] InnoDB: Restoring possible half-written data pages
2018-06-15 16:30:59 24192 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 93176239
2018-06-15 16:31:00 24192 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 11113, file name .\mysql-bin.000007
2018-06-15 16:31:01 24192 [Note] InnoDB: 1 rollback segment(s) are active.
2018-06-15 16:31:01 24192 [Note] InnoDB: Waiting for purge to start
2018-06-15 16:31:01 24192 [Note] InnoDB: 5.6.26 started; log sequence number 93176239
2018-06-15 16:31:01 24192 [Note] Server hostname (bind-address): '*'; port: 3306
2018-06-15 16:31:01 24192 [Note] IPv6 is available.
2018-06-15 16:31:01 24192 [Note]   - '::' resolves to '::';
2018-06-15 16:31:01 24192 [Note] Server socket created on IP: '::'.
08:31:01 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67460 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x52151c8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
2bfa73    mysqld.exe!?get_field@@YAPADPAUst_mem_root@@PAVField@@@Z()
26bd09    mysqld.exe!?init@ACL_PROXY_USER@@QAEXPAUTABLE@@PAUst_mem_root@@@Z()
26c9ea    mysqld.exe!?acl_reload@@YADPAVTHD@@@Z()
2703ef    mysqld.exe!?acl_init@@YAD_N@Z()
1c290a    mysqld.exe!?win_main@@YAHHPAPAD@Z()
1c2c67    mysqld.exe!?mysql_service@@YAHPAX@Z()
65751a    mysqld.exe!my_mb_ctype_mb()
73ff62c4    KERNEL32.DLL!BaseThreadInitThunk()
772a0fd9    ntdll.dll!RtlSubscribeWnfStateChangeNotification()
772a0fa4    ntdll.dll!RtlSubscribeWnfStateChangeNotification()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 0
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

jishuang

mysql数据库用的版本是不一样的，最好不要这样覆盖
要么就有5.2.7版本的数据库去做升级
要么就是5.3版本的数据库自己创建表等

http://www.wex5.com/zh-download-page/#06中提供的有5.3.3版本的OA


或者根据错误提示到网上查找是否有相关的解决方案，这个就是mysql标准的错误提示，不是平台控制的

yebm0086

你好，我下载了5.3.3的版本OA，直接复制到3.8中，界面可以看到，大部分也可以运行，但是在流程图这块出现问题了，我找了“办公用品详情”，其他的也是类似。

执行KSQL出错, KSQL: select t.sFlowID from SA_Task t where (t.sData1=:data or t.sData2=:data or t.sData3=:data or t.sData4=:data) and t.sProcess=:process
--> sql: SELECT t.SFLOWID AS sFlowID FROM SA_Task_histroy t WHERE ( (t.SDATA1 = ? ) OR (t.SDATA2 = ? ) OR (t.SDATA3 = ? ) OR (t.SDATA4 = ? ) ) AND (t.SPROCESS = ? )
--> binds: [C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, /OA/officeSupplyConsumables/process/officeSupplyUseApply/officeSupplyUseApplyProcess]
编码：JUSTEP150210
隐藏详细
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select t.sFlowID from SA_Task t where (t.sData1=:data or t.sData2=:data or t.sData3=:data or t.sData4=:data) and t.sProcess=:process
--> sql: SELECT t.SFLOWID AS sFlowID FROM SA_Task_histroy t WHERE ( (t.SDATA1 = ? ) OR (t.SDATA2 = ? ) OR (t.SDATA3 = ? ) OR (t.SDATA4 = ? ) ) AND (t.SPROCESS = ? )
--> binds: [C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, /OA/officeSupplyConsumables/process/officeSupplyUseApply/officeSupplyUseApplyProcess]
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.KSQL.select(Unknown Source)
at com.justep.system.process.TaskDB.select(Unknown Source)
at com.justep.system.process.TaskDB.queryFlowIdByData(Unknown Source)
at ProcessProcedure.getProcessChartByData(ProcessProcedure.java:849)
... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT t.SFLOWID AS sFlowID FROM SA_Task_histroy t WHERE ( (t.SDATA1 = ? ) OR (t.SDATA2 = ? ) OR (t.SDATA3 = ? ) OR (t.SDATA4 = ? ) ) AND (t.SPROCESS = ? ) , binds: [C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, C94B430ACD5847D7B033C74BD9CA0BAD, /OA/officeSupplyConsumables/process/officeSupplyUseApply/officeSupplyUseApplyProcess]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 37 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5sys.sa_task_histroy' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 38 more

jishuang

数据库中缺少表，http://bbs.wex5.com/forum.php?mo ... typeid&typeid=6中3.3到3.8版本中间发布的版本中提供的升级程序执行一下

yebm0086

我没有找到，3.3升级到3.8的程序，具体的是那个地址，方便告诉我吗

jishuang

3.3到3.8版本中间发布的版本中提供的升级程序
4楼的链接中有每个版本发布的帖子啊，有些版本中有升级程序就执行，没有跳过不用处理

yebm0086

升级可以了，出现这个问题

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP151058; 提示: 模块"/OA/finance/process/financeReimbrseBadgut"不存在
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadExtAttribute(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModel(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModelObjectByFullName(Unknown Source)
        at com.justep.model.ModelUtils.getProcess(Unknown Source)
        at com.justep.system.process.TemplateHelper.getTemplate(Unknown Source)
        at com.justep.system.process.ProcessInstance.getTemplate(Unknown Source)
        at com.justep.system.process.ProcessInstance.loadTokenInstance(Unknown Source)
        at com.justep.system.process.TaskDB.loadPI(Unknown Source)
        at com.justep.system.process.ProcessChartEngine.getProcessChartByPI(Unknown Source)
        at ProcessProcedure.getProcessChartByTask(ProcessProcedure.java:842)
        ... 30 more
2018-06-20 12:19:04 开始-WINDOW生成中间文件: /UI2/system/service/process/dialog/processRecord.w
2018-06-20 12:19:04 加载模块：/UI2/system/components/justep/panel/server ...
2018-06-20 12:19:04 加载模块：/UI2/system/components/justep/panel/server
2018-06-20 12:19:04 结束-WINDOW生成中间文件: /UI2/system/service/process/dialog/processRecord.w
2018-06-20 12:19:04 开始-中间文件生成缓存文件: /UI2/system/service/process/dialog/processRecord.w
2018-06-20 12:19:04 结束-中间文件生成缓存文件: /UI2/system/service/process/dialog/processRecord.w
2018-06-20 12:19:12 加载模块：/OA/finance/process/financeReimbrseBadgut ...
2018-06-20 12:19:12 excute stream action, params:{"accept":"application/json","action":"getProcessChartByTaskAction","actionFlag":"__action_0__","activity":"startActivity","contentType":"json","executeContext":"","executor":"","parameters":{"ext":"","task":"9FC47ADF0C544BFDBA3781999C86A2F0"},"process":"/OA/finance/process/financeReimbrseApplyQuery/financeReimbrseApplyQueryProcess"}
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP151058; 提示: 模块"/OA/finance/process/financeReimbrseBadgut"不存在
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadExtAttribute(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModel(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModelObjectByFullName(Unknown Source)
        at com.justep.model.ModelUtils.getProcess(Unknown Source)
        at com.justep.system.process.TemplateHelper.getTemplate(Unknown Source)
        at com.justep.system.process.ProcessInstance.getTemplate(Unknown Source)
        at com.justep.system.process.ProcessInstance.loadTokenInstance(Unknown Source)
        at com.justep.system.process.TaskDB.loadPI(Unknown Source)
        at com.justep.system.process.ProcessChartEngine.getProcessChartByPI(Unknown Source)
        at ProcessProcedure.getProcessChartByTask(ProcessProcedure.java:842)
        ... 30 more

yebm0086

我在下载的资源库中也没有找到这个模块，详细在7#



模块"/OA/finance/process/financeReimbrseBadgut"不存在
编码：JUSTEP151058  

jishuang

不存在搜索源码是否地方有把配置去掉，OA不是平台提供的，需要自己修改