起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › 2.7兼容包中的的应用公共组件在3.8版本中运行报错 ...
返回列表 发新帖
查看: 5973|回复: 2

[结贴] 2.7兼容包中的的应用公共组件在3.8版本中运行报错

[复制链接]

13

主题

52

帖子

252

积分

中级会员

Rank: 3Rank: 3

积分
252
QQ
发表于 2020-11-18 00:04:59 | 显示全部楼层 |阅读模式
版本: X5.2.7 小版本号:
数据库: Oracle 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 其它 浏览器: Chrome
微信图片_20201117235635.png

组件配置

组件配置

控制台报错内容：
2020-11-17 23:55:26 [http-8899-8] [com.justep.business.server.BusinessServer] ERROR: action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/OA/signature/process/signatureApplyQuery/signatureApplyQueryProcess" activity="startActivity" action-flag="__action_0__" executor="" execute-context="" name="querySLSignatureAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="filter"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[(fBizState IN ('bsEditing','bsExecuting','bsFinished')) AND ((fCreatePsnID = 'PSN01') OR (OA_SL_Signature IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM OA_SL_UseExecute EXECUTE_CONCEPT WHERE EXECUTE_CONCEPT.fCreatePsnID = 'PSN01') ))]]></xbiz:simple></parameter><parameter name="offset"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">0</xbiz:simple></parameter><parameter name="limit"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">20</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fNO,fSignatureTypeID,fSake,fIndianID,fIndianName,fUseDate,fSignatureTypeName,fRemark,fBizState,fBizStateName,fDeptLeadershipID,fDepLeaderAdvice,fCheckDate,fLeaderID,fLeaderAdvice,fGreeDate,fApplyOgnID,fApplyOgnName,fApplyDeptID,fApplyDeptName,fApplyPsnID,fApplyPsnName,fApplyPsnFID,fApplyPsnFName,fApplyDate,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreatePsnFName,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,fCurrentActivities,fCurrentExecutors,fExtendStr1,fExtendStr2,fExtendStr3,fExtendStr4,fExtendStr5,fExtendStr6,fExtendStr7,fExtendStr8,fExtendStr9,fExtendDate1,fExtendDate2,fExtendDate3,fExtendDate4,fExtendDate5,fExtendNum1,fExtendNum2,fExtendNum3,fExtendNum4,fExtendNum5,fAttachment,fProjectID,fProjectName,OA_SL_Signature]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fApplyDate DESC]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="OA_SL_Signature" sequence="recNo,fBizStateName,fNO,fProjectName,fSignatureTypeName,fSake,fApplyDeptName,fApplyPsnName,fApplyDate,fRemark,space-column,version,fSignatureTypeID,fIndianID,fIndianName,fUseDate,fBizState,fDeptLeadershipID,fDepLeaderAdvice,fCheckDate,fLeaderID,fLeaderAdvice,fGreeDate,fApplyOgnID,fApplyOgnName,fApplyDeptID,fApplyPsnID,fApplyPsnFID,fApplyPsnFName,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreatePsnFName,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,fCurrentActivities,fCurrentExecutors,fExtendStr1,fExtendStr2,fExtendStr3,fExtendStr4,fExtendStr5,fExtendStr6,fExtendStr7,fExtendStr8,fExtendStr9,fExtendDate1,fExtendDate2,fExtendDate3,fExtendDate4,fExtendDate5,fExtendNum1,fExtendNum2,fExtendNum3,fExtendNum4,fExtendNum5,fAttachment,fProjectID"/></translate-parameter></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor335.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: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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT sum(OA_SL_Signature.version) as sversion,sum(OA_SL_Signature.fExtendNum1) as sfExtendNum1,sum(OA_SL_Signature.fExtendNum2) as sfExtendNum2,sum(OA_SL_Signature.fExtendNum3) as sfExtendNum3,sum(OA_SL_Signature.fExtendNum4) as sfExtendNum4,sum(OA_SL_Signature.fExtendNum5) as sfExtendNum5  FROM OA_SL_Signature OA_SL_Signature WHERE ((fBizState IN ('bsEditing','bsExecuting','bsFinished')) AND ((fCreatePsnID = 'PSN01') OR (OA_SL_Signature IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM OA_SL_UseExecute EXECUTE_CONCEPT WHERE EXECUTE_CONCEPT.fCreatePsnID = 'PSN01') )))
--> sql:
--> binds: []
        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:55)
        ... 29 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154054; 提示: KSQL语法错误, fBizState找不到对应的符号描述
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.IdentiferNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.InListNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 34 more



业务状态过滤组件中的关系不是以  “概念.关系” 的形式存在就会报错？尝试将概念名称加在关系前不生效，请问有遇到过类似问题的吗？有没有什么好的解决办法
回复

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36064
发表于 2020-11-18 15:54:15 | 显示全部楼层
这个跟升级无关，ksql的语法一直都是这样

可以参考smarttFilter组件拼接filter的实现
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

13

主题

52

帖子

252

积分

中级会员

Rank: 3Rank: 3

积分
252
QQ
 楼主| 发表于 2021-1-6 18:30:35 | 显示全部楼层
jishuang 发表于 2020-11-18 15:54
这个跟升级无关，ksql的语法一直都是这样

可以参考smarttFilter组件拼接filter的实现 ...

结贴
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-11-22 03:01 , Processed in 0.098607 second(s), 28 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表