登录名或密码错误【mysql更换为sql server】

asia668

原mysql数据库更换为sql server数据库；
登录用户的表sa_opperson的数据已导入。但测试自动的程序时，系统报错：
2017-05-24 20:35: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">demo</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_VISTA</xbiz:simple></item><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">Mobile</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-05-24</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/config/sys.config.m中的
<config name="passwordSalt" value="http://www.justep.com"/>注释掉，保存文件然后重启tomcat看看

asia668

/BIZ/system/config/sys.config.m中的
<config name="passwordSalt" value="http://www.justep.com"/>注释掉，保存文件然后重启tomcat看看
-------------------------------------------------------------------------------------------------------------------------
注释后，仍然提示登录名或密码错误。

jishuang

确认SA_OPPerson中的登录人的密码是什么？

asia668

F3D3A7EF80A1E7BDA2511A3A0B7E6CF8

jishuang

是这个就不能把BIZ/system/config/sys.config.m中的
<config name="passwordSalt" value="http://www.justep.com"/>注释掉


确认SA_OPOrg中有个人吗？

asia668

SA_OPORG内，demo的账号信息

jishuang

信息是什么？确认SA_OPPerson和SA_OPOrg中的sValidState字段的值都是1吗？

asia668

一直没找到错误

jishuang

你好楼主，该问题需要远程，已经通过技术服务QQ加你为好友了，请及时通过，我们会尽快QQ远程。