글 수 7,449
조회 수 : 3523
2012.11.07 (12:00:21)
GauceOutputStream을 정상적으로 close 하셨는지 확인해보시길 바랍니다.
>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : 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=238396
(*.124.184.238)
|
|
