KSQL查询测试帐号密码错误

badnjcf

帐号密码对的,让问怎么设置...谢谢!~~~帐号密码是系统里的帐号密码.

badnjcf

2021-04-30 15:23:37 action:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:justep="http://www.justep.com/x5#" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xforms="http://www.w3.org/2002/xforms" xmlnsxf="http://www.orbeon.com/oxf/processors" xmlns:ns="http://www.justep.com/x5#" xmlns:xbiz="http://www.justep.com/xbiz#" activity="mainActivity" process="/SA/OPM/system/systemProcess" name="loginAction"><parameters><parameter name="options"><xbiz:map><item key="client"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">manager</xbiz:simple></item></xbiz:map></parameter><parameter name="name"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">system</xbiz:simple></parameter><parameter name="pwd"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">76f6161afbdaea608353dbcedce22114</xbiz:simple></parameter><parameter name="loginDate"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#date">2021-04-30</xbiz:simple></parameter><parameter name="lang"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">zh_CN</xbiz:simple></parameter><parameter name="ip"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">localhost</xbiz:simple></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source)
        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:741)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        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:155)
        at OPMProcedure.login(OPMProcedure.java:137)

jishuang

浏览器中输入同样的用户名和密码可以登录系统？

badnjcf

jishuang 发表于 2021-4-30 15:39
浏览器中输入同样的用户名和密码可以登录系统？

可以的

jishuang

可以那就应该没问题，本地测试默认的system/123456是没问题的，你的密码修改了？

badnjcf

jishuang 发表于 2021-4-30 18:56
可以那就应该没问题，本地测试默认的system/123456是没问题的，你的密码修改了？ ...

对,密码改过了.我这边试了都不行,自己建的用户也不行.

badnjcf

可以帮我远程看一下吗,是哪里问题.还有我的数据库是SQL SERVER..我想看下ROWNUM列怎么加上去是用,SQL.ROW_NUMBER() OVER(ORDER BY列).不行呀

jishuang

数据库中密码的是什么？
这个是sql中的标准用法

badnjcf

前台system密码是zhou235数据中密码是.666CB0C2E8CE4D22C50CD7E2E9C16457

jishuang

找一个默认是123456的用户，发一下后端的具体错误信息