页面查询出错

sandgia

"messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT BID_specification.*  FROM BID_specification BID_specification WHERE (( 1=1  and issueUnit like '%中国通信标准化协会%')) LIMIT 0, 20\n --> sql: SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT  BID_specification.fID AS BID_specification, BID_specification.ISSUETIME AS issueTime, BID_specification.NORMALNUM AS normalNum, BID_specification.WORKCONTENT AS workContent, BID_specification.FCREATEPERSONID AS fCreatePersonID, BID_specification.FCREATEDEPTCODE AS fCreateDeptCode, BID_specification.FCREATEPERSONCODE AS fCreatePersonCode, BID_specification.REMARK AS remark, BID_specification.VERSION AS version, BID_specification.CERTIFYDATA AS certifyData, BID_specification.FCREATEPERSONNAME AS fCreatePersonName, BID_specification.FCREATDTIME AS fCreatdTime, BID_specification.FCREATEDEPTNAME AS fCreateDeptName, BID_specification.NORMALNAME AS normalName, BID_specification.SETDAY AS setDay, BID_specification.IMPLTIME AS ImplTime, BID_specification.FCREATEPERSONFID AS fCreatePersonFID, BID_specification.ISSUEUNIT AS issueUnit, BID_specification.CERTIFYDATAADRESS AS certifyDataAdress, BID_specification.FCREATEDEPTID AS fCreateDeptID FROM BID_SPECIFICATION BID_specification  WHERE  (? = ?) AND (issueUnit LIKE ?) ) JUSTEP_TABLE__  WHERE ROWNUM<21\n --> binds: [1, 1, %中国通信标准化协会%]","Error"],"url":"https://m.cicdi.com/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/ERP/BID/BidLibrary/process/Library/libraryProcess","activity":"specification","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryBID_specificationAction","parameters":{"variables":{},"filter":"( 1=1  and issueUnit like '%中国通信标准化协会%')","offset":0,"limit":20,"columns":"BID_specification,issueTime,normalNum,workContent,fCreatePersonID,fCreateDeptCode,fCreatePersonCode,remark,version,certifyData,fCreatePersonName,fCreatdTime,fCreateDeptName,normalName,setDay,ImplTime,fCreatePersonFID,issueUnit,certifyDataAdress,fCreateDeptID"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"BID_specification","sequence":"BID_specification,issueTime,normalNum,workContent,fCreatePersonID,fCreateDeptCode,fCreatePersonCode,remark,version,certifyData,fCreatePersonName,fCreatdTime,fCreateDeptName,normalName,setDay,ImplTime,fCreatePersonFID,issueUnit,certifyDataAdress,fCreateDeptID"}}}}__justepServerErrorEnd__
    at Object.create (core.min.js:65)
    at Object.Request.errorMessage (biz.common.min.js:12)
    at Object.callback (biz.common.min.js:12)
    at Object.h (biz.common.min.js:12)
    at f (core.min.js:65)
    at Object.add (core.min.js:65)
    at _sendRequest (biz.common.min.js:12)
    at Object.Request.sendRequest (biz.common.min.js:12)
    at Object.$var._sendBizRequest (eval at __actionFinish (biz.common.min.js:12), <anonymous>:1:579)
    at Object.Request.sendBizRequest (biz.common.min.js:12)

但是单独拿出sql在navicat中运行是对：
SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT  BID_specification.fID AS BID_specification, BID_specification.ISSUETIME AS issueTime, BID_specification.NORMALNUM AS normalNum, BID_specification.WORKCONTENT AS workContent, BID_specification.FCREATEPERSONID AS fCreatePersonID, BID_specification.FCREATEDEPTCODE AS fCreateDeptCode, BID_specification.FCREATEPERSONCODE AS fCreatePersonCode, BID_specification.REMARK AS remark, BID_specification.VERSION AS version, BID_specification.CERTIFYDATA AS certifyData, BID_specification.FCREATEPERSONNAME AS fCreatePersonName, BID_specification.FCREATDTIME AS fCreatdTime, BID_specification.FCREATEDEPTNAME AS fCreateDeptName, BID_specification.NORMALNAME AS normalName, BID_specification.SETDAY AS setDay, BID_specification.IMPLTIME AS ImplTime, BID_specification.FCREATEPERSONFID AS fCreatePersonFID, BID_specification.ISSUEUNIT AS issueUnit, BID_specification.CERTIFYDATAADRESS AS certifyDataAdress, BID_specification.FCREATEDEPTID AS fCreateDeptID FROM BID_SPECIFICATION BID_specification  WHERE  (1 = 1) AND (issueUnit LIKE '%中国通信标准化协会%') ) JUSTEP_TABLE__  WHERE ROWNUM<21

jishuang

发tomcat控制台完整的错误信息

sandgia

jishuang 发表于 2019-10-14 16:42
发tomcat控制台完整的错误信息

是正式环境，没有控制台日志。是不是tomcat目录下有相关的log可以提供呢？ 相关的错误信息我搜集在了附件中。

jishuang

model同级的logs和tomcat的log都发过来

sandgia

jishuang 发表于 2019-10-15 08:37
model同级的logs和tomcat的log都发过来

今天又试一下，错误如下：
执行KSQL出错, KSQL: SELECT S.* FROM BID_specification S WHERE S = 'FBEA6AB2A5C4475B8FA10FD4C1B6D9B4'
--> sql: SELECT S.fID AS S, S.VERSION AS version, S.FCREATEPERSONNAME AS fCreatePersonName, S.FCREATEPERSONID AS fCreatePersonID, S.FCREATEPERSONCODE AS fCreatePersonCode, S.FCREATDTIME AS fCreatdTime, S.FCREATEPERSONFID AS fCreatePersonFID, S.FCREATEDEPTNAME AS fCreateDeptName, S.FCREATEDEPTID AS fCreateDeptID, S.FCREATEDEPTCODE AS fCreateDeptCode, S.ISSUEUNIT AS issueUnit, S.NORMALNUM AS normalNum, S.NORMALNAME AS normalName, S.SETDAY AS setDay, S.ISSUETIME AS issueTime, S.IMPLTIME AS ImplTime, S.WORKCONTENT AS workContent, S.REMARK AS remark, S.CERTIFYDATA AS certifyData, S.CERTIFYDATAADRESS AS certifyDataAdress FROM BID_SPECIFICATION S WHERE S.fID = ?
--> binds: [FBEA6AB2A5C4475B8FA10FD4C1B6D9B4]

你可以根据这个定位附件（model同级log 和tomcat中的log）中的错误。附件已经舍弃了一部分，太大。

jishuang

有日志自己都能看出具体的错误信息，错误中都提示了具体的代码行和错误原因

sandgia

jishuang 发表于 2019-10-22 13:52
有日志自己都能看出具体的错误信息，错误中都提示了具体的代码行和错误原因

...

我添加log也没有看出什么来，

而且也没有看出什么来，就是执行翻译出来的sql：
SELECT  S.fID AS S, S.VERSION AS version, S.FCREATEPERSONNAME AS fCreatePersonName, S.FCREATEPERSONID AS fCreatePersonID, S.FCREATEPERSONCODE AS fCreatePersonCode, S.FCREATDTIME AS fCreatdTime, S.FCREATEPERSONFID AS fCreatePersonFID, S.FCREATEDEPTNAME AS fCreateDeptName, S.FCREATEDEPTID AS fCreateDeptID, S.FCREATEDEPTCODE AS fCreateDeptCode, S.ISSUEUNIT AS issueUnit, S.NORMALNUM AS normalNum, S.NORMALNAME AS normalName, S.SETDAY AS setDay, S.ISSUETIME AS issueTime, S.IMPLTIME AS ImplTime, S.WORKCONTENT AS workContent, S.REMARK AS remark, S.CERTIFYDATA AS certifyData, S.CERTIFYDATAADRESS AS certifyDataAdress FROM BID_SPECIFICATION S  WHERE S.fID = 'FBEA6AB2A5C4475B8FA10FD4C1B6D9B4'
在navicat中已经正常运行了。而且这个错误在上次我贴出的简化版本的描述中就已经试过了。

jishuang

那你可以直接写sql通过sql执行看看，报错就是sql的错误