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

QQ登录

只需一步,快速开始

查看: 3092|回复: 1

[处理中3] 查询数据量大报错

[复制链接]

213

主题

790

帖子

2056

积分

金牌会员

Rank: 6Rank: 6

积分
2056
QQ
发表于 2019-4-10 09:58:42 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: select b.forgname as org,b.fproduceorderno as produceorderno,b.fmaterielcode  as materielcode,b.feditioncode as editioncode,p.fcode as code,p.fprocedurenameid as procedurename,w.fname as wname,b.fresultnum as resultnum,a.factualenddate as  actualenddate ,(select  sum(ERP_QM_QualityTesting.fQualifiedNumber) from ERP_QM_QualityTesting ERP_QM_QualityTesting  where  ERP_QM_QualityTesting.fProcedureID = a.fProcedureNum AND ERP_QM_QualityTesting.fStatus = '已转出' )  as c1,(select  sum(ERP_QM_QualityTesting.fbalanceAmount) from ERP_QM_QualityTesting ERP_QM_QualityTesting  where  ERP_QM_QualityTesting.fProcedureID = a.fProcedureNum AND ERP_QM_QualityTesting.fStatus = '已转出' )  as c2  ,(select  sum(t.fCompletionQuantity) as custom2 from ERP_MM_ProcessCompletion t  where  t.fProcedureID = a.fProcedureNum AND t.fWhetherInspection = '否' ) as c3 ,b.fProjectName as ProjectName,s.fstockname as stockname,p.fid as pid from Erp_Mm_Procedureplan a  left join erp_gy_ptprocedure  p on  p.fid = a.fprocedurenum  left join erp_me_workcentermain w on w.fid  = a.fworkcenterid  left join erp_mm_productionorder b on a.fproduceorderid = b.fid   left join erp_stockarchives  s on s.fstockcode = b.fmaterielcode where a.fifcompleted='是' and b.fordersource ='MRP' and a.factualenddate >= to_date('2019-01-01','yyyy-mm-dd')    and a.factualenddate <= to_date('2019-01-31','yyyy-mm-dd'), binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at MarketSys.querypercent(MarketSys.java:20281)
        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: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: java.sql.SQLException: 无法从套接字读取更多的数据
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1024)
        at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:291)
        at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
        ... 33 more
2019-04-10 09:55:27 excute stream action, params:{"accept":"application/json","action":"querypercent","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"ERP_MM_ProcedurePlan,code,editioncode,fActualEndDate,fActualStartDate,fBeginTime,fCompletionQuantity,fCompromiseNum,fContent,fContinuityFlag,fDeviceGZ,fDispatchingDate,fDispatchingPsnID,fEndTime,fIFcompleted,fIdentifying,fIsAssessment,fIsCompressed,fIsSDGX,fLeadtimeCompressionRatio,fLeadtimeModelSetting,fMixDate,fNewStatus,fNumOfWorkers,fPersonCode,fPersonID,fPersonName,fPlanLeadtime,fPlannedEndDate,fPlannedStartDate,fProcedureNameID,fProcedureNum,fProduceOrderID,fProductionReadinessStatus,fRemark,fRepairNum,fResourceNumber,fReworkNum,fScrapNum,fSingleManhour,fSplitNumber,fStatus,fStdLeadtime,fStockCode,fStockName,fSurplusTimes,fTotalManhour,fTransferDate,fTransferQuantity,fTransferredQuantity,fVendorID,fVendorName,fWorkCenterID,fZJManhour,id,materielcode,materielname,no,org,procedurename,project,qualified,resultnum,scrap,unqualified,version,workcenter","limit":20,"offset":0,"variables":{}},"process":"/erp/marketSys/process/passrate/passrateProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"id","sequence":"ERP_MM_ProcedurePlan,code,editioncode,fActualEndDate,fActualStartDate,fBeginTime,fCompletionQuantity,fCompromiseNum,fContent,fContinuityFlag,fDeviceGZ,fDispatchingDate,fDispatchingPsnID,fEndTime,fIFcompleted,fIdentifying,fIsAssessment,fIsCompressed,fIsSDGX,fLeadtimeCompressionRatio,fLeadtimeModelSetting,fMixDate,fNewStatus,fNumOfWorkers,fPersonCode,fPersonID,fPersonName,fPlanLeadtime,fPlannedEndDate,fPlannedStartDate,fProcedureNameID,fProcedureNum,fProduceOrderID,fProductionReadinessStatus,fRemark,fRepairNum,fResourceNumber,fReworkNum,fScrapNum,fSingleManhour,fSplitNumber,fStatus,fStdLeadtime,fStockCode,fStockName,fSurplusTimes,fTotalManhour,fTransferDate,fTransferQuantity,fTransferredQuantity,fVendorID,fVendorName,fWorkCenterID,fZJManhour,id,materielcode,materielname,no,org,procedurename,project,qualified,resultnum,scrap,unqualified,version,workcenter"},"transformIdcolumn":true,"useNamespace":true}}
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: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: java.lang.RuntimeException: 编码: JUSTEP150039; 提示: 执行sql: select b.forgname as org,b.fproduceorderno as produceorderno,b.fmaterielcode  as materielcode,b.feditioncode as editioncode,p.fcode as code,p.fprocedurenameid as procedurename,w.fname as wname,b.fresultnum as resultnum,a.factualenddate as  actualenddate ,(select  sum(ERP_QM_QualityTesting.fQualifiedNumber) from ERP_QM_QualityTesting ERP_QM_QualityTesting  where  ERP_QM_QualityTesting.fProcedureID = a.fProcedureNum AND ERP_QM_QualityTesting.fStatus = '已转出' )  as c1,(select  sum(ERP_QM_QualityTesting.fbalanceAmount) from ERP_QM_QualityTesting ERP_QM_QualityTesting  where  ERP_QM_QualityTesting.fProcedureID = a.fProcedureNum AND ERP_QM_QualityTesting.fStatus = '已转出' )  as c2  ,(select  sum(t.fCompletionQuantity) as custom2 from ERP_MM_ProcessCompletion t  where  t.fProcedureID = a.fProcedureNum AND t.fWhetherInspection = '否' ) as c3 ,b.fProjectName as ProjectName,s.fstockname as stockname,p.fid as pid from Erp_Mm_Procedureplan a  left join erp_gy_ptprocedure  p on  p.fid = a.fprocedurenum  left join erp_me_workcentermain w on w.fid  = a.fworkcenterid  left join erp_mm_productionorder b on a.fproduceorderid = b.fid   left join erp_stockarchives  s on s.fstockcode = b.fmaterielcode where a.fifcompleted='是' and b.fordersource ='MRP' and a.factualenddate >= to_date('2019-01-01','yyyy-mm-dd')    and a.factualenddate <= to_date('2019-01-31','yyyy-mm-dd'), binds: []出错
        at MarketSys.querypercent(MarketSys.java:20317)
        ... 30 more
  1. HashMap<String, String> sqlMap = new HashMap<String, String>();
  2.                     sqlMap.put(DatabaseProduct.ORACLE.name(), ksql);
  3.                     sqlMap.put(DatabaseProduct.KINGBASE.name(), ksql);
  4.                     sqlMap.put(DatabaseProduct.DB2.name(), ksql);
  5.                     Table tables = SQL.select(sqlMap, null, DATA_MODEL);
复制代码
查询数据5000条,报上面错误

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35878
发表于 2019-4-10 10:30:40 | 显示全部楼层
java.sql.SQLException: 无法从套接字读取更多的数据是标准的报错信息,可以到网上查找解决方案

可以直接那sql语句到数据库查询或者用java按标准的jdbc的方式去查询数据库测试
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-3-29 10:00 , Processed in 0.078240 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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