KSQL查询测试帐号密码错误

badnjcf

2021-05-07 10:13:40 加载模块：/system/logic/code/interceptor ...
2021-05-07 10:13:40 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">tycx</xbiz:simple></parameter><parameter name="pwd"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">e10adc3949ba59abbe56e057f20f883e</xbiz:simple></parameter><parameter name="loginDate"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#date">2021-05-07</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.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: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)
        ... 40 more

badnjcf

用了默认密码123456的还是这样

jishuang

qq1392416607看一下，你的qq有验证信息

badnjcf

jishuang 发表于 2021-5-7 11:42
qq1392416607看一下，你的qq有验证信息

你好我QQ发你了.260526692

jishuang

把studio关掉，然后删除studio\workspace\.metadata\.plugins 目录，在把studio\workspace\.metadata_bakup\.plugins 这个目录拷到studio\workspace\.metadata\ 然后重启studio看看

如果不行就基于新解压的版本操作

badnjcf

jishuang 发表于 2021-5-8 13:36
把studio关掉，然后删除studio\workspace\.metadata\.plugins 目录，在把studio\workspace\.metadata_bakup ...

我发现问题了,就是这个文件改了后.会出现密码错误.

.

我开的是多租户模式,要怎么解决

就是下面这一句加进来就不行.
        <item name="initClient" value="/system/logic/code/interceptor,com.justep.system.interceptor.InitClient,before"/>

jishuang

开发版先不要设置多租户

badnjcf

jishuang 发表于 2021-5-8 18:37
开发版先不要设置多租户

好吧,只能这样了.谢谢啦
顺便问下,我用的是sqlserver,..ksql不能实现序号列吗...就是上面我问过的,row_number()函数是不是不能用于ksql

jishuang

使用SQL.调用标准的数据库函数

比较复杂的推荐直接用sql实现

badnjcf

好的,谢谢了,请结帖!~