数据过滤问题

dh_n

1. (ERP_MM_ProcessCompletion.fTime >= stringToDate('2018-11-01')) AND (ERP_MM_ProcessCompletion.fTime < stringToDate('2018-12-01')) and (upper(ERP_MM_ProcessCompletion.fProcessCompletionCode) LIKE '%3%') OR (upper(DateTimeToString(ERP_MM_ProcessCompletion.fTime)) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fWhetherInspection) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fTransshipmentRequireds) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fProcedureNameID) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fWorkCenterID) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fProcedureContent) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fWorkCalendarMainID) LIKE '%3%') OR (upper(ERP_GY_PTProcedure_1.fProcedureNum) LIKE '%3%') OR (upper(ERP_GY_PTProcedure.fProcedureNum) LIKE '%3%') OR (upper(ERP_MM_ProductionOrder.fProduceOrderNO) LIKE '%3%') OR (upper(SA_OPPerson.sName) LIKE '%3%') OR (upper(ERP_ME_WorkCenterMain.fName) LIKE '%3%') OR (upper(ERP_MM_ProductionOrder.fMaterielCode) LIKE '%3%')
   

复制代码

界面上是主子表显示，需求导出主子表关联数据
获取界面上datefilter条件和smartfilter条件拼接，作为条件去查询；上面 是拼接的条件。
控制台报错
java.lang.OutOfMemoryError: Java heap space
        at java.util.HashMap.newNode(HashMap.java:1734)
        at java.util.HashMap.putVal(HashMap.java:630)
        at java.util.HashMap.put(HashMap.java:611)
        at com.justep.system.transform.Table2Json.createCell(Unknown Source)
        at com.justep.system.transform.Table2Json.createRow(Unknown Source)
        at com.justep.system.transform.Table2Json.transformList(Unknown Source)
        at com.justep.system.transform.Table2Json.transform(Unknown Source)
        at com.justep.system.transform.ResultTransform.transformTableByJson(Unknown Source)
        at com.justep.system.transform.ResultTransform.transformCompObjectByJson(Unknown Source)
        at com.justep.system.transform.ResultTransform.transformByJson(Unknown Source)
        at com.justep.system.transform.ResultTransform.transform(Unknown Source)
        at com.justep.system.transform.ResponseTransform.transform(Unknown Source)
        at com.justep.system.action.Engine.translateResult(Unknown Source)
        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)




浏览器报错
Uncaught Error: __justepServerErrorStart__{"message":"刷新数据失败！ , \n业务服务器执行出错","reason":"","code":"JUSTEP150011","stack":"java.lang.OutOfMemoryError: Java heap space\r\n\tat java.util.HashMap.newNode(HashMap.java:1734)\r\n\tat java.util.HashMap.putVal(HashMap.java:630)\r\n\tat java.util.HashMap.put(HashMap.java:611)\r\n\tat com.justep.system.transform.Table2Json.createCell(Unknown Source)\r\n\tat com.justep.system.transform.Table2Json.createRow(Unknown Source)\r\n\tat com.justep.system.transform.Table2Json.transformList(Unknown Source)\r\n\tat com.justep.system.transform.Table2Json.transform(Unknown Source)\r\n\tat com.justep.system.transform.ResultTransform.transformTableByJson(Unknown Source)\r\n\tat com.justep.system.transform.ResultTransform.transformCompObjectByJson(Unknown Source)\r\n\tat com.justep.system.transform.ResultTransform.transformByJson(Unknown Source)\r\n\tat com.justep.system.transform.ResultTransform.transform(Unknown Source)\r\n\tat com.justep.system.transform.ResponseTransform.transform(Unknown Source)\r\n\tat com.justep.system.action.Engine.translateResult(Unknown Source)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n","messages":["Java heap space"],"url":"http://127.0.0.1:8080/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/erp/marketSys/process/completion/completionProcess","activity":"listActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryERP_MM_ProcessCompletionjoindetailAction","parameters":{"variables":{},"filter":"((ERP_MM_ProcessCompletion.fTime >= stringToDate('2018-11-01')) AND (ERP_MM_ProcessCompletion.fTime < stringToDate('2018-12-01')) and (upper(ERP_MM_ProcessCompletion.fProcessCompletionCode) LIKE '%3%') OR (upper(DateTimeToString(ERP_MM_ProcessCompletion.fTime)) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fWhetherInspection) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fTransshipmentRequireds) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fProcedureNameID) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fWorkCenterID) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fProcedureContent) LIKE '%3%') OR (upper(ERP_MM_ProcessCompletion.fWorkCalendarMainID) LIKE '%3%') OR (upper(ERP_GY_PTProcedure_1.fProcedureNum) LIKE '%3%') OR (upper(ERP_GY_PTProcedure.fProcedureNum) LIKE '%3%') OR (upper(ERP_MM_ProductionOrder.fProduceOrderNO) LIKE '%3%') OR (upper(SA_OPPerson.sName) LIKE '%3%') OR (upper(ERP_ME_WorkCenterMain.fName) LIKE '%3%') OR (upper(ERP_MM_ProductionOrder.fMaterielCode) LIKE '%3%'))","offset":0,"limit":-1,"columns":"ERP_MM_ProcessCompletion,currentCode,fActualHour,fBatchNo,fBatchNo1,fBizState,fBizStateName,fCarrierUnit,fCheckReceivedQuantity,fCode1,fCode2,fCompletionQuantity,fCurrentActivities,fCurrentExecutors,fCustomerBatch,fExplain,fFinishedDate,fHandlePerson,fInspectionLoadingPoint,fLnspectionList,fMaterielCode,fName,fNextProcedureID,fNormsType,fOrderStatus,fPlannedCompletionDate,fPlannedEndDate,fPlannedReceptions,fPlannedStartDate,fProcedureContent,fProcedureID,fProcedureNameID,fProcedureNum,fProcedureNum1,fProcessCompletionCode,fProcessingQuantity,fProcessingTime,fProduceOrderID,fProduceOrderNO,fProductionHours,fQualifiedNumber,fReceiveDate,fReceiveDates,fRemark,fReportPeople,fSource,fStockName,fStockType,fSumNum,fTheRecipientID,fTheRecipientsID,fTime,fTransshipmentRequired,fTransshipmentRequireds,fWaybillNumber,fWhetherInspection,fWhetherSetPieces,fWhetherTheFinalProcess,fWorkCalendarMainID,fWorkCenterID,fWorkTimeDistribution,gName,inName,jName,nextCode,tName,version"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"ERP_MM_ProcessCompletion","sequence":"ERP_MM_ProcessCompletion,currentCode,fActualHour,fBatchNo,fBatchNo1,fBizState,fBizStateName,fCarrierUnit,fCheckReceivedQuantity,fCode1,fCode2,fCompletionQuantity,fCurrentActivities,fCurrentExecutors,fCustomerBatch,fExplain,fFinishedDate,fHandlePerson,fInspectionLoadingPoint,fLnspectionList,fMaterielCode,fName,fNextProcedureID,fNormsType,fOrderStatus,fPlannedCompletionDate,fPlannedEndDate,fPlannedReceptions,fPlannedStartDate,fProcedureContent,fProcedureID,fProcedureNameID,fProcedureNum,fProcedureNum1,fProcessCompletionCode,fProcessingQuantity,fProcessingTime,fProduceOrderID,fProduceOrderNO,fProductionHours,fQualifiedNumber,fReceiveDate,fReceiveDates,fRemark,fReportPeople,fSource,fStockName,fStockType,fSumNum,fTheRecipientID,fTheRecipientsID,fTime,fTransshipmentRequired,fTransshipmentRequireds,fWaybillNumber,fWhetherInspection,fWhetherSetPieces,fWhetherTheFinalProcess,fWorkCalendarMainID,fWorkCenterID,fWorkTimeDistribution,gName,inName,jName,nextCode,tName,version"}}}}__justepServerErrorEnd__

jishuang

java.lang.OutOfMemoryError: Java heap space

报的是内存溢出，确认tomcat的内存是否够用

dh_n

这条件是从界面上显示数据源上获取出来的，为什么显示数据源可以过滤成功
导出数据源表和显示数据源是同一张表，差异是导出数据源多关联了子表、

jishuang

显示是分页的，导出如果是导出的DB是导出的数据库所有的数据，如果数据多是需要占用一定内存量的

dh_n

结帖