多租户问题

John913

问题1：Bex5_V3.7是否还需要5.2兼容包？

问题2：按照client.config.m中的指引，访问http://localhost:8080/x5/UI2/SA/init/init.w，并点击初始化，出现如下错误，如何解决？

<action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="loginAction" execute-context="" content-type="application/xml"><parameters><parameter name="ip"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">127.0.0.1</xbiz:simple></parameter><parameter name="name"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">init</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="client"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">manager</xbiz:simple></item></xbiz:map></parameter><parameter name="loginDate"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Date">2018-01-16</xbiz:simple></parameter><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">E10ADC3949BA59ABBE56E057F20F883E</xbiz:simple></parameter><parameter name="lang"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">zh_CN</xbiz:simple></parameter></parameters></action>
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 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
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: INSERT INTO SA_OPOrgVer SA_OPOrgVer(SA_OPOrgVer, SA_OPOrgVer.version, SA_OPOrgVer.sName, SA_OPOrgVer.sCode) VALUES (:SA_OPOrgVer, :version, :sName, :sCode)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.opm.OrgCache.getOrgVer(Unknown Source)
at com.justep.system.opm.OrgCache.getOrgVersion(Unknown Source)
at OPMProcedure.login(OPMProcedure.java:178)
at OPMProcedure.login(OPMProcedure.java:137)
... 28 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO SA_Code (SA_Code.sID, SA_Code.VERSION, SA_Code.SNAME, SA_Code.SCODE, SA_Code.sType) VALUES ( ? ,  ? ,  ? ,  ? , ?), binds: [orgVersion, 0, orgVersion, 730370CE0CDA4AF98C780E8692E1D440, orgVersion]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 42 more
Caused by: java.sql.SQLException: Field 'client_id' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
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.executeUpdate(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 43 more

jishuang

不需要兼容包
看/BIZ/system/config/client.config.m中的说明，确认相关的配置都正确吗？

John913

相关配置是正确的，我只做了client.config.m中的第一步，开启多租户。上面的错误是在做“二. 多租户系统库的初始化”时，点击初始化出的错

John913

这条KSQL看起来没什么问题：
INSERT INTO SA_OPOrgVer SA_OPOrgVer(SA_OPOrgVer, SA_OPOrgVer.version, SA_OPOrgVer.sName, SA_OPOrgVer.sCode) VALUES (:SA_OPOrgVer, :version, :sName, :sCode)

为什么转换成sql时没有自动添加client_id字段呢？转换的sql:
INSERT INTO SA_Code (SA_Code.sID, SA_Code.VERSION, SA_Code.SNAME, SA_Code.SCODE, SA_Code.sType) VALUES ( ? ,  ? ,  ? ,  ? , ?), binds: [orgVersion, 0, orgVersion, 730370CE0CDA4AF98C780E8692E1D440, orgVersion]

jishuang

数据库是平台3.7默认带的数据库吗？

John913

是的，bex5版本号为：6154

jishuang

你好楼主，这个问题需要我在本地环境进行问题重现，所以会花费较长时间，请你耐心等待，我完成后会第一时间反馈结果，谢谢！

John913

非常感谢，希望知道这里的KSQL为什么不会自动添加client_id字段。

jishuang

在/BIZ/system/data/init/sys.mysql.create.sql中加上
insert into SA_Code ($clientName, sID, sType, sCode, sName, version) values($clientValue, '__init__','__init__','__init__','__init__',0);
把数据库还原为默认带的数据库，然后重新初始化

这个是平台的缺陷

John913

谢谢。问多一句，起步是不是不再卖多租户的lisence了？