글 수 7,449
조회 수 : 2880
2012.11.06 (22:09:37)
게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.
* 고객시스템명 : LG전자
* GAUCE 버전 : 4.0.4.4
* WAS 종류(WebLogic 등등) : Weblogic
* DB 종류 : Oracle
* 문의 유형(질문/요청/참조) : 질문
* 내용 : 화면 조회하면서 대용량 데이터 조회시 아래의 에러가 잡힙니다.
약 3만건 정도 까지는 괜찮은데 6만건 이상 올라가니 에러가 발생하네요.
쿼리는 실행되서 DataSet에 데이터는 담았고
DataSet을 JSP단으로 가져올때 에러가 나는거 같습니다.
이럴때 해결방안 같은게 있나요??
현재 ResultSet > LMultiData > DataSet > GauceOutputStream.write() 로 실행되는데
GauceOutputStream.write() 에서 에러가 납니다.
com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute()=>Connection reset by peer: socket write error
JSP/Servlet Error (Catched by LAbstractGauceServlet) :[GSCPGauceServlet-catchService Failed ] Request URI: /analysis/salesPSINav/retrieveSalesPSISearchList.gau, User Location: 0:0:0:0:0:0:0:1(0:0:0:0:0:0:0:1)
devon.core.exception.LBizException: ddgscp.com.err.retrieve
at com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute(ANLSalesPSIRetrieveCmd.java:90)
at devonframework.front.command.LCommandEngine.a(Unknown Source)
at devonframework.front.command.LCommandEngine.execute(Unknown Source)
at devonframework.front.channel.interceptor.LCommandInterceptor.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LConverterInterceptor.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LFileUploadInterceptor.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
at devonframework.bridge.gauce.channel.LAbstractGauceServlet.process(Unknown Source)
at com.lge.ddgscp.framework.channel.GSCPGauceServlet.catchService(GSCPGauceServlet.java:110)
at devonframework.front.channel.LAbstractServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
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:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.lge.ddgscp.framework.util.CustomCharacterEncodingFilter.doFilter(CustomCharacterEncodingFilter.java:38)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.gauce.filter.GauceFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
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:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
Caused by: java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:568)
at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:539)
at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:427)
at weblogic.servlet.internal.ChunkOutput$2.checkForFlush(ChunkOutput.java:648)
at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:333)
at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:148)
at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:148)
at com.gauce.io.bin.H.A(Unknown Source)
at com.gauce.io.bin.H.A(Unknown Source)
at com.gauce.io.bin.H.write(Unknown Source)
at com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute(ANLSalesPSIRetrieveCmd.java:82)
... 31 more
다음양식에 맞게 입력해주세요.
* 고객시스템명 : LG전자
* GAUCE 버전 : 4.0.4.4
* WAS 종류(WebLogic 등등) : Weblogic
* DB 종류 : Oracle
* 문의 유형(질문/요청/참조) : 질문
* 내용 : 화면 조회하면서 대용량 데이터 조회시 아래의 에러가 잡힙니다.
약 3만건 정도 까지는 괜찮은데 6만건 이상 올라가니 에러가 발생하네요.
쿼리는 실행되서 DataSet에 데이터는 담았고
DataSet을 JSP단으로 가져올때 에러가 나는거 같습니다.
이럴때 해결방안 같은게 있나요??
현재 ResultSet > LMultiData > DataSet > GauceOutputStream.write() 로 실행되는데
GauceOutputStream.write() 에서 에러가 납니다.
com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute()=>Connection reset by peer: socket write error
JSP/Servlet Error (Catched by LAbstractGauceServlet) :[GSCPGauceServlet-catchService Failed ] Request URI: /analysis/salesPSINav/retrieveSalesPSISearchList.gau, User Location: 0:0:0:0:0:0:0:1(0:0:0:0:0:0:0:1)
devon.core.exception.LBizException: ddgscp.com.err.retrieve
at com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute(ANLSalesPSIRetrieveCmd.java:90)
at devonframework.front.command.LCommandEngine.a(Unknown Source)
at devonframework.front.command.LCommandEngine.execute(Unknown Source)
at devonframework.front.channel.interceptor.LCommandInterceptor.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LConverterInterceptor.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LFileUploadInterceptor.doIntercept(Unknown Source)
at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
at devonframework.bridge.gauce.channel.LAbstractGauceServlet.process(Unknown Source)
at com.lge.ddgscp.framework.channel.GSCPGauceServlet.catchService(GSCPGauceServlet.java:110)
at devonframework.front.channel.LAbstractServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
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:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.lge.ddgscp.framework.util.CustomCharacterEncodingFilter.doFilter(CustomCharacterEncodingFilter.java:38)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.gauce.filter.GauceFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
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:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
Caused by: java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:568)
at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:539)
at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:427)
at weblogic.servlet.internal.ChunkOutput$2.checkForFlush(ChunkOutput.java:648)
at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:333)
at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:148)
at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:148)
at com.gauce.io.bin.H.A(Unknown Source)
at com.gauce.io.bin.H.A(Unknown Source)
at com.gauce.io.bin.H.write(Unknown Source)
at com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute(ANLSalesPSIRetrieveCmd.java:82)
... 31 more
http://member.shift.co.kr/index.php?document_srl=238399
(*.247.149.205)
|
|
