몇일전
티베로7 버전으로 업그레이드 후 레포트 조회 시 문제가 발생되고 있습니다.
오즈서버 재가동 후 몇시간동안 뷰어 에서 잘 조회 되다가
시간이 좀 지나면 뷰어에서 조회중에 멈춘 현상이 있습니다.
첨부파일에
오즈서버 에러로그 첨부합니다.
-- 오즈서버 에러 내용 ----------------------------------------------
2023-12-28 09:18:08,498 [http-7788-3] INFO DataModule - Start Datamodule-Binding.
2023-12-28 09:18:08,498 [http-7788-3] DEBUG DataModule - </bis/tra/t34/BTGD08P2_2014.odi Set Name : OZParam> data-binding complete.
2023-12-28 09:18:08,498 [http-7788-3] DEBUG StoredPool - Request for connection has alias 'DB_TRA'
2023-12-28 09:18:08,499 [http-7788-3] INFO ConnectionPool-DB_TRA - Request for connection received.
2023-12-28 09:22:44,738 [http-7788-7] DEBUG ConnectionPool-DB_TRA - Delivered connection from pool []
2023-12-28 09:22:44,739 [http-7788-7] DEBUG ConnectionPool-DB_TRA - Total connections: 5 Available: 2 Checked-out: 3
2023-12-28 09:22:44,739 [http-7788-1] INFO ConnectionPool-DB_TRA - Start free a connection. []
2023-12-28 09:22:44,739 [http-7788-1] DEBUG ConnectionPool-DB_TRA - Returned connection to pool
2023-12-28 09:22:44,739 [http-7788-1] DEBUG ConnectionPool-DB_TRA - Total connections: 5 Available: 3 Checked-out: 2
2023-12-28 09:22:44,739 [http-7788-1] DEBUG StoredPool - removed item from pool [ size : 0 ]
2023-12-28 09:22:44,739 [http-7788-3] DEBUG ConnectionPool-DB_TRA - Pooled Connection checking
2023-12-28 09:22:44,739 [http-7788-1] ERROR FrameworkRequestDataModule - Bind Error occured during fetching
at oz.framework.policy.cozb5.a(DashoA12957:34)
at oz.dm.meta.OZDBQuerySet.b(DashoA12957:320)
at oz.dm.meta.OZDBQuerySet.getResultSet(DashoA12957:107)
at oz.dm.meta.OZRSDataSet.BindRealTimeReport(DashoA12957:703)
at oz.dm.meta.OZDataModuleImpl.getBCDataModule(DashoA12957:811)
at oz.dm.meta.OZDataModuleImpl.getBCDataModule(DashoA12957:727)
at oz.framework.cp.message.FrameworkRequestDataModule.b(DashoA12957:835)
at oz.framework.cp.message.FrameworkRequestDataModule.fetchMessage(DashoA12957:1364)
at oz.server.cozcu.a(DashoA12957:247)
at oz.server.cozcu.a(DashoA12957:151)
at oz.server.OZServlet.a(DashoA12957:836)
at oz.server.OZServlet.doPost(DashoA12957:164)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:682)
2023-12-28 09:22:44,740 [http-7788-7] ERROR DataModule - [Error Code :10102005] [/bis/tra/t34/BTGD08P2_2014.odi] [Component Name : MASTER] Fail to get statement.
java.sql.SQLException: JDBC-90603:Invalid operation: disconnected from the server.
at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source)
at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
at com.tmax.tibero.jdbc.driver.TbConnection.createStatement(Unknown Source)
at com.tmax.tibero.jdbc.driver.TbConnection.createStatement(Unknown Source)
at oz.dm.meta.OZDBQuerySet.b(DashoA12957:291)
at oz.dm.meta.OZDBQuerySet.getResultSet(DashoA12957:107)
at oz.dm.meta.OZRSDataSet.BindRealTimeReport(DashoA12957:703)
at oz.dm.meta.OZDataModuleImpl.getBCDataModule(DashoA12957:811)
at oz.dm.meta.OZDataModuleImpl.getBCDataModule(DashoA12957:727)
at oz.framework.cp.message.FrameworkRequestDataModule.b(DashoA12957:835)
at oz.framework.cp.message.FrameworkRequestDataModule.fetchMessage(DashoA12957:1364)
at oz.server.cozcu.a(DashoA12957:247)
at oz.server.cozcu.a(DashoA12957:151)
at oz.server.OZServlet.a(DashoA12957:836)
at oz.server.OZServlet.doPost(DashoA12957:164)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:682)
2023-12-28 09:22:44,740 [http-7788-3] DEBUG ConnectionPool-DB_TRA - executing test query for pooled connection
2023-12-28 09:22:44,741 [http-7788-7] ERROR DataModule - Binding Job Failure - Removed cache data.
2023-12-28 09:22:44,742 [http-7788-1] ERROR FrameworkRequestDataModule - Exception Occured in Message Fetching[3]
2023-12-28 09:22:44,744 [http-7788-1] INFO MessageHandler - End Message Handing
NOSPAM_javaxp@naver.com
1
