* 장애현상
- 현상 : 6분 이상 걸리는 쿼리문 실행할 때 "데이터 모듈을 받기 시작합니다."에서 멈추고 아래 에러 발생함.
사용자 PC의 뷰어 쪽에는 보고서 호출 후 6분 후에 "The operation timed out" 에러창 나옴.
서버로그에는 쿼리가 완료된 7분 후에 쿼리 실행이 완료되었다고 나오고,(파란색부분)
클라이언트쪽과의 통신이 끊어져서 socket write error 발생(빨간색부분)
- 에러 코드 : 10902000
- 일반 메시지 : 리포트 로더:
클라이언트에서 서버로 통신 중 에러가 발생했습니다. 네트워크 상태나 서버의 프로토콜 버전을 확인해 주십시오.
- 상세 메시지 : The operation timed out
- 오즈서버 로그
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] INFO ConnectionPool-ForCSTest - Request for connection received.
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG ConnectionPool-ForCSTest - newConnectionByURL.... url: forcs:weblogic.jndi.WLInitialContextFactory:TestDS
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG ConnectionPool-ForCSTest - getConnection without DriverManager.
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] INFO ConnectionPool-ForCSTest - Opened a new connection by URL.
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG ConnectionPool-ForCSTest - Delivered connection from pool []
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG ConnectionPool-ForCSTest - Total connections: 1 Available: 0 Checked-out: 1
2010-09-06 11:13:13,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG DataModule - </Report_Test/51/mssql_delayquery.odi Set Name : SQL_test> Query to run:waitfor delay '00:07:01'
select top 3 * from TestTable
2010-09-06 11:20:14,593 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG DataModule - </Report_Test/51/mssql_delayquery.odi Set Name : SQL_test> Success to execute query.
2010-09-06 11:20:14,593 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG DataModule - </Report_Test/51/mssql_delayquery.odi Set Name : SQL_test, 3> data-binding complete.
2010-09-06 11:20:14,593 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] INFO DataModule - Datamodule-Binding Complete.
2010-09-06 11:20:14,593 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] INFO ConnectionPool-ForCSTest - Start free a connection. []
2010-09-06 11:20:14,593 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG ConnectionPool-ForCSTest - Closed connection
2010-09-06 11:20:14,593 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG ConnectionPool-ForCSTest - Total connections: 0 Available: 0 Checked-out: 0
2010-09-06 11:20:14,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] DEBUG StoredPool - removed item from pool [ size : 0 ]
2010-09-06 11:20:14,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] INFO FrameworkRequestDataModule - Making DataModule is successfully completed: [mssql_delayquery.odi]
2010-09-06 11:20:14,609 [ExecuteThread: '14' for queue: 'weblogic.kernel.Default'] ERROR FrameworkResponseDataModule - Error occured in writing Message on network
java.net.SocketException: Software caused connection abort: 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.ChunkUtils.writeChunkTransfer(ChunkUtils.java:250)
at weblogic.servlet.internal.ChunkUtils.writeChunks(ChunkUtils.java:226)
at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:296)
at weblogic.servlet.internal.ChunkOutputWrapper.flush(ChunkOutputWrapper.java:145)
at weblogic.servlet.internal.ServletOutputStreamImpl.flush(ServletOutputStreamImpl.java:126)
at java.io.DataOutputStream.flush(DataOutputStream.java:101)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:128)
at java.io.DataOutputStream.flush(DataOutputStream.java:101)
at java.io.DataOutputStream.flush(DataOutputStream.java:101)
at oz.dm.intermediate.IBasicDataModule.WriteBody(DashoA12957:114)
at oz.dm.intermediate.IBasicDataModule.Write(DashoA12957:210)
at oz.framework.cp.message.FrameworkResponseDataModule.b(DashoA12957:316)
at oz.framework.cp.message.FrameworkResponseDataModule.write(DashoA12957:238)
at oz.framework.cp.message.FrameworkRequestDataModule.fetchMessage(DashoA12957:1601)
at oz.server.cozcp.a(DashoA12957:214)
at oz.server.cozcp.a(DashoA12957:124)
at oz.server.OZServlet.a(DashoA12957:200)
at oz.server.OZServlet.doPost(DashoA12957:153)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) |
* 장애원인
웹브라우저의 timeout이 있어서 6분 후에 서버와의 연결이 끊어지기 때문임.
ie6 :
연결시도 30초 timeout
데이터waiting 6분 timeout
ie7 :
연결시도 30초
데이터waiting 30초 -> 오즈가 강제로 6분이 되도록 수정 (2007년 초에 모든 버전 뷰어에 반영됨)
* 해결방법
IE의 timeout이 발생하는 경우 강제로 ZTransfer 패러미터 Min~Timeout를 통해 늘려줄 수 있습니다. (단위 : 초)
단, IE의 설정을 레지스트리에서 임의로 바꾸는 것이기 때문에 아래 태그로 실행 후 IE를 모두 닫고 다시 실행하거나 pc를 한번 재부팅해야 반영됩니다.
ZTransfer 2.2.0.8 부터 지원됩니다. 예를 들어 3시간 설정은 10800으로 값을 주면 됩니다.
<OBJECT width = "0" height = "0" ID="ZTransferX" CLASSID="CLSID:C7C7225A-9476-47AC-B0B0-FF3B79D55E67" codebase="http://127.0.0.1:7001/oz51/OZViewerActiveX51_20100830100/ZTransferX_2,2,1,8.cab#version=2,2,1,8">
<param name="download.Server" value="http://127.0.0.1/oz51/OZViewerActiveX51_20100830100">
<param name="download.Port" value="7001">
<param name="download.Instruction" value="ozrviewer.idf">
<param name="install.Base" value="<PROGRAMS>/Forcs">
<param name="install.Namespace" value="OZViewerActiveX51_20100830100">
<param name="MinConnectTimeout" value="10800">
<param name="MinReceiveTimeout" value="10800">
<param name="MinSendTimeout" value="10800">
</OBJECT>
ZTransfer 2.2.0.8
IE의 웹서버 연결 시간, 응답 시간, 요청 전송 시간을 설정할 수 있도록 ZTrasnfer.cab에 MinConnectTimeout, MinReceiveTimeout, MinSendTimeout 태그가 추가되었습니다.
- MinConnectTimeout
- MinRecevieTimeout
- MinSendTimeout
|
Timeout |
경로 |
|
MinConnectTimeout |
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ConnectTimeout |
|
MinRecevieTimeout |
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\RecevieTimeout |
|
MinSendTimeout |
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\SendTimeout |
* 참고사항
마이플랫폼에서 오즈 뷰어를 실행하거나 쿼리 디자이너에서 데이터조회를 오즈서버로부터 실행한 경우에도 IE의 timeout 6분 후에 동일하게 에러 발생합니다.
|
NOSPAM_mklee@forcs.com
