BeX5 OA 部署后不能登陆

sweetwolf

使用最新的预览版版本BeX5 V3.7, 从网站下载了“协同OA办公系统 (V5.2.7)”，按照说明文档部署到SQL Server，
定义了数据源如下：


数据库表SA_OPPerson中也存在“北京起步_oa”这个用户：



运行系统输入用户名和密码：北京起步_oa/123456，不能登录，出错信息如下：
Error: 查询用户出错 at Object.create (http://127.0.0.1:8080/x5/UI2/v_b ... re.min.js:71:216609) at n.Model.login (http://127.0.0.1:8080/x5/UI2/v_e ... gin/login.js:106:29) at n.Model.loginClick (http://127.0.0.1:8080/x5/UI2/v_e ... ogin/login.js:131:8) at n.fire (http://127.0.0.1:8080/x5/UI2/v_b ... re.min.js:71:237473) at n.fireEvent (http://127.0.0.1:8080/x5/UI2/v_b ... re.min.js:71:238637) at n.callParent (http://127.0.0.1:8080/x5/UI2/v_b ... re.min.js:71:234912) at n.fireEvent (http://127.0.0.1:8080/x5/UI2/v_8 ... mmon.min.js:15:3768) at n._doClick (http://127.0.0.1:8080/x5/UI2/v_2 ... mp.min.js:144:86899) at HTMLAnchorElement.i (http://127.0.0.1:8080/x5/UI2/v_b ... ore.min.js:71:19322) at HTMLAnchorElement.dispatch (http://127.0.0.1:8080/x5/UI2/v_b ... ore.min.js:71:53815)

然后输入用户名和密码：system/123456，也不能登录，出错信息基本一致！

请问是出了什么问题了？请指教！

jishuang

/BIZ/system/config/sys.config.m中的<config name="passwordSalt" value="http://www.justep.com"/>注释掉，然后重启tomcat

sweetwolf

jishuang 发表于 2017-6-23 09:20
/BIZ/system/config/sys.config.m中的注释掉，然后重启tomcat

在sys.config.m中注释后：

重启了tomcat，用system登录不成功，结果是一样的：

Error: 查询用户出错 at Object.create (http://127.0.0.1:8080/x5/UI2/v_2b1c1910cd904339b309764dc9166ce6l_zh_CNs_desktopd_pc/system/core.min.js:71:216609) at n.Model.login (http://127.0.0.1:8080/x5/UI2/v_b99a1aa1d5864b1190429e305b68d7d0l_zh_CNs_desktopd_pc/portal/base/login/login.js:106:29) at n.Model.loginClick (http://127.0.0.1:8080/x5/UI2/v_b99a1aa1d5864b1190429e305b68d7d0l_zh_CNs_desktopd_pc/portal/base/login/login.js:131:8) at n.fire (http://127.0.0.1:8080/x5/UI2/v_2b1c1910cd904339b309764dc9166ce6l_zh_CNs_desktopd_pc/system/core.min.js:71:237473) at n.fireEvent (http://127.0.0.1:8080/x5/UI2/v_2b1c1910cd904339b309764dc9166ce6l_zh_CNs_desktopd_pc/system/core.min.js:71:238637) at n.callParent (http://127.0.0.1:8080/x5/UI2/v_2b1c1910cd904339b309764dc9166ce6l_zh_CNs_desktopd_pc/system/core.min.js:71:234912) at n.fireEvent (http://127.0.0.1:8080/x5/UI2/v_d2221483371e47cca6c887da141a70f1l_zh_CNs_desktopd_pc/system/common.min.js:15:3768) at n._doClick (http://127.0.0.1:8080/x5/UI2/v_77dc675793234bdaaf22be519bd4a6dal_zh_CNs_desktopd_pc/system/components/comp.min.js:144:86899) at HTMLAnchorElement.i (http://127.0.0.1:8080/x5/UI2/v_2b1c1910cd904339b309764dc9166ce6l_zh_CNs_desktopd_pc/system/core.min.js:71:19322) at HTMLAnchorElement.dispatch (http://127.0.0.1:8080/x5/UI2/v_2b1c1910cd904339b309764dc9166ce6l_zh_CNs_desktopd_pc/system/core.min.js:71:53815)

jishuang

看数据库中system的密码是什么

sweetwolf

jishuang 发表于 2017-6-23 10:41
看数据库中system的密码是什么

E10ADC3949BA59ABBE56E057F20F883E

jishuang

system登录tomcat控制台的完整错误信息发一下看看

sweetwolf

jishuang 发表于 2017-6-23 13:37
system登录tomcat控制台的完整错误信息发一下看看

以下是system登录后的信息：

2017-06-23 15:37:43 action:<?xml version="1.0" encoding="UTF-8"?>
<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">0:0:0:0:0: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">system</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="OperatingSystem"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">WINDOWS</xbiz:simple></item><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">Computer</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">2017-06-23</xbiz:simple></parameter><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">:e0d34b5ab5e5f0831ac99a9be6072f8e</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.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.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: 编码: JUSTEP150021; 提示: 登录名或密码错误
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.throwBusinessException(Unknown Source)
        at com.justep.system.opm.OrgUtils.getPersonByDB(Native Method)
        at com.justep.system.opm.OrgUtils.getPerson(Unknown Source)
        at com.justep.system.opm.OrgUtils.login(Native Method)
        at com.justep.system.opm.OrgUtils.login1(Unknown Source)
        at OPMProcedure.login(OPMProcedure.java:152)
        at OPMProcedure.login(OPMProcedure.java:137)
        ... 26 more

jishuang

确认BIZ的system是否有扩展空间，扩展空间中是否有上面修改的那个配置文件，文件中的配置没有去掉

sweetwolf

jishuang 发表于 2017-6-23 16:12
确认BIZ的system是否有扩展空间，扩展空间中是否有上面修改的那个配置文件，文件中的配置没有去掉 ...

BIZ的system没有扩展空间：

---

---

jishuang

你好楼主，该问题需要远程，已经通过技术服务QQ加你为好友了，请及时通过，我们会尽快QQ远程。
已远程，更密码无关，是用的之前老版本的数据库，数据库中缺少字段导致的，需要自己执行版本升级过程中提供的升级脚本