从第三方系统打开X5中的功能时，第一次能打开，再次打开...

rzport_lq0

我们采用这种方式把X5的功能集成到我们的系统中来的：
http://ip:port/x5/portal/directLogin.w?username=<%=v_user%>&password=<%=v_pass%>&source=<%=v_source %>&menuname=<%=v_menuname%>"
把他放到一个frame中。
在我们的系统中第一次打开这个功能时一切正常，然后切换到其他页面，再点击这个功能时，就报KSQL的错误。。
做了如下测试。我记录下，正常打开时的jsessionid 和出错的jseesionid，把出错的url放到任何浏览器中执行都出KSQL的问题，将该jseesionid用正常的打开时的jseesionid替换后，一切正常。不知道是不是和jseesionid中记录的信息是否有关？

jishuang

具体的错误信息是什么？

rzport_lq0

详细里面的内容如下：
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT ZBBT_ZBXX.* FROM ZBBT_ZBXX ZBBT_ZBXX ORDER BY ZBNAME ASC LIMIT 0, 10
编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列MCH必须包含在select查出列中



java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor399.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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:820)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT ZBBT_ZBXX.* FROM ZBBT_ZBXX ZBBT_ZBXX ORDER BY ZBNAME ASC LIMIT 0, 10
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列MCH必须包含在select查出列中
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.handleColumns(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 31 more

url:/UI/system/service/common/bizAction.j
param:{"process":"/ICS/zbkh/zbinf/process/zbinf/zbinfProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryZBBT_ZBXXAction","parameters":{"variables":{},"offset":0,"limit":10,"columns":"version,ZBID,ZBLB,ZBPURPOSE,KHXMDM,FILEBH,ZBNAME,TGDWDM,TGDWMC,ZRRID,ZRR,LRZRRID,LRZRR,JSDWDM,JSDWMC,KHCYCLE,LRSHJYQ,ZBSETSHJ,LASTXGSHJ,ZGSTATUS,PXH,NOTE,ZBGSDM,MCH,ZBBT_ZBXX","orderBy":"ZBNAME ASC"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"ZBBT_ZBXX","sequence":"recNo,ZBLB,MCH,ZBNAME,ZBGSDM,TGDWMC,ZRR,LRZRR,JSDWMC,KHCYCLE,ZBPURPOSE,LRSHJYQ,ZBSETSHJ,LASTXGSHJ,ZGSTATUS,NOTE,version,ZBID,KHXMDM,FILEBH,TGDWDM,ZRRID,LRZRRID,JSDWDM,PXH"}}}


有的模块还出现这样的提示：
UIServer错误URI：/x5/ICS/zbkh/zbinf/process/zbkhmanage/mainActivity.w错误码：500错误信息：编码: JUSTEP151002; 提示: 定义Process "/ICS/zbkh/zbinf/process/zbkhmanage/zbkhmanageProcess"出错, has-action中引用了不可见的Action "queryBT_ZBLRLOCKSETAction"
com.justep.exception.BaseRuntimeException: 编码: JUSTEP151002; 提示: 定义Process "/ICS/zbkh/zbinf/process/zbkhmanage/zbkhmanageProcess"出错, has-action中引用了不可见的Action "queryBT_ZBLRLOCKSETAction"        at com.justep.ui.WindowServer.getData(Unknown Source)        at com.justep.ui.WindowServer.service(Unknown Source)        at com.justep.ui.servlet.MainServlet.service(Unknown Source)        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3729)        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)第一次打开都是正常的。

jishuang

X5用的什么版本？

rzport_lq0

5.2.6.2457

jishuang

那就在登录的时候判断之前的bsessionid是否超时，在确认是否登录，可以参考
/UI/demo/actions/process/integration/x5Login.j

rzport_lq0

jishuang 发表于 2015-1-15 09:59
那就在登录的时候判断之前的bsessionid是否超时，在确认是否登录，可以参考
/UI/demo/actions/process/inte ...

bsessionid不会在1分钟内失效吧？

jishuang

rzport_lq0 发表于 2015-1-15 15:42
bsessionid不会在1分钟内失效吧？

平台默认是30分钟

rzport_lq0

jishuang 发表于 2015-1-15 16:50
平台默认是30分钟

那就是说没有失效。也没有注销操作。

rzport_lq0

你的意思是我还需要调用 x5Login.j 这个？