ITS_OP_09.java 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. [16:55:41] DB Error Occured. FILE: CDSLinkF.cpp LINE: 477 FUNC: TItsLinkManager::LoadTraffic
  2. Title: TItsLinkManager::LoadTraffic
  3. Class: EOleException
  4. Error: ORA-03114: ORACLE에 연결되어 있지 않습니다
  5. SQL :
  6. SELECT A.LINK_ID, PRCN_DT, TFVL, SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, MISS_YN,
  7. PRCN_SPED, SMTH_SPED, ADJS_SPED, PTRN_SPED, PRCN_SORC, ADJS_SORC, DATA_NUM,
  8. (CASE WHEN PRCN_DT <= TO_CHAR(SYSDATE - 10/1440, 'YYYYMMDDHH24MISS')
  9. THEN 'Y' ELSE 'N' END) AS MISSING,
  10. (CASE WHEN PRCN_DT >= TO_CHAR(SYSDATE - 15/1440, 'YYYYMMDDHH24MISS')
  11. THEN 'Y' ELSE 'N' END) AS LASTANS,
  12. (SELECT MAX(PRCN_DT) FROM TB_LINK_TRAF) MPRCN_DT
  13. FROM TB_LINK_TRAF A, TB_LINK B
  14. WHERE A.LINK_ID = B.LINK_ID
  15. [16:55:41] DB Error Occured. FILE: CDSIfscF.cpp LINE: 500 FUNC: TItsIfscManager::LoadTraffic
  16. Title: TItsIfscManager::LoadTraffic
  17. Class: EOleException
  18. Error: ORA-03114: ORACLE에 연결되어 있지 않습니다
  19. SQL :
  20. SELECT A.IFSC_ID, PRCN_DT, TFVL, SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, PTRN_SPED, DATA_NUM,
  21. (CASE WHEN PRCN_DT <= TO_CHAR(SYSDATE - 10/1440, 'YYYYMMDDHH24MISS')
  22. THEN 'Y' ELSE 'N' END) AS MISSING,
  23. (CASE WHEN PRCN_DT >= TO_CHAR(SYSDATE - 15/1440, 'YYYYMMDDHH24MISS')
  24. THEN 'Y' ELSE 'N' END) AS LASTANS,
  25. (SELECT MAX(PRCN_DT) FROM TB_LINK_TRAF) MPRCN_DT
  26. FROM TB_IFSC_TRAF A, TB_IFSC B
  27. WHERE A.IFSC_ID = B.IFSC_ID
  28. [16:55:41] DB Error Occured. FILE: CDSRoadF.cpp LINE: 520 FUNC: TItsRoadManager::LoadTraffic
  29. Title: TItsRoadManager::LoadTraffic
  30. Class: EOleException
  31. Error: ORA-03114: ORACLE에 연결되어 있지 않습니다
  32. SQL :
  33. SELECT A.ROAD_ID, PRCN_DT, TFVL, SPED, PTRN_SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, DATA_NUM,
  34. (CASE WHEN PRCN_DT <= TO_CHAR(SYSDATE - 10/1440, 'YYYYMMDDHH24MISS')
  35. THEN 'Y' ELSE 'N' END) AS MISSING,
  36. (CASE WHEN PRCN_DT >= TO_CHAR(SYSDATE - 15/1440, 'YYYYMMDDHH24MISS')
  37. THEN 'Y' ELSE 'N' END) AS LASTANS,
  38. (SELECT MAX(PRCN_DT) FROM TB_ROAD_TRAF) MPRCN_DT
  39. FROM TB_ROAD_TRAF A, TB_ROAD B
  40. WHERE A.ROAD_ID = B.ROAD_ID
  41. [16:55:41] DB Error Occured. FILE: CDSRepeatCongestF.cpp LINE: 97 FUNC: TItsRepeatCongestManager::LoadFromDb
  42. Title: TItsRepeatCongestManager::LoadFromDb
  43. Class: EOleException
  44. Error: ORA-03114: ORACLE에 연결되어 있지 않습니다
  45. SQL :
  46. SELECT *
  47. FROM TB_REPT_CNGS_SECT
  48. [16:55:44] DB Error Occured. FILE: CDSFacilityF.cpp LINE: 1803 FUNC: TItsFacilityManager::LoadFacilityStatusFromDb
  49. Title: TItsFacilityManager::LoadFacilityStatusFromDb
  50. Class: EOleException
  51. Error: ORA-03114: ORACLE에 연결되어 있지 않습니다
  52. SQL :
  53. SELECT '' AS FAC_TYPE, '' AS FAC_ID,
  54. '' AS STTS_CD, '' AS DOOR_STTS_CD,
  55. DECODE('', 'CMS0', '0', 'CMS1', '1', '2') AS COMM,
  56. DECODE('', 'CDS0', '0', 'CDS1', '1', '0') AS DOOR,
  57. NVL(NULL, 0) AS CBOX_TMPR,
  58. '' AS STS00,
  59. '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05,
  60. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  61. FROM DUAL
  62. WHERE 1 = 0
  63. UNION
  64. SELECT 'CCTV' AS FAC_TYPE, B.CCTV_CTLR_ID AS FAC_ID,
  65. CMNC_STTS_CD AS STTS_CD, CBOX_DOOR_STTS_CD AS DOOR_STTS_CD,
  66. DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '2') AS COMM,
  67. DECODE(CBOX_DOOR_STTS_CD, 'CDS0', '0', 'CDS1', '1', '0') AS DOOR,
  68. NVL(A.CBOX_TMPR, 0) AS CBOX_TMPR,
  69. A.UPDT_DT AS STS00,
  70. '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05,
  71. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  72. FROM TB_CCTV_STTS A, TB_CCTV_CTLR B
  73. WHERE A.CCTV_MNGM_NMBR = B.CCTV_MNGM_NMBR
  74. AND UPDT_DT >= TO_CHAR(SYSDATE-10/1440, 'YYYYMMDDHH24MISS')
  75. UNION
  76. SELECT B.WCAM_TYPE_CD AS FAC_TYPE, B.WCAM_CTLR_ID AS FAC_ID,
  77. CMNC_STTS_CD AS STTS_CD, 'CDS0' AS DOOR_STTS_CD,
  78. DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '0') AS COMM,
  79. '0' AS DOOR, 0 AS CBOX_TMPR,
  80. A.UPDT_DT AS STS00,
  81. '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05,
  82. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  83. FROM TB_WCAM_CTLR_STTS A, TB_WCAM_CTLR B
  84. WHERE A.WCAM_CTLR_NMBR = B.WCAM_CTLR_NMBR
  85. AND A.UPDT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS')
  86. UNION
  87. SELECT 'VMS' AS FAC_TYPE, B.VMS_CTLR_ID AS FAC_ID,
  88. CMNC_STTS_CD AS STTS_CD, CBOX_DOOR_STTS_CD AS DOOR_STTS_CD,
  89. DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '2') AS COMM,
  90. DECODE(CBOX_DOOR_STTS_CD, 'CDS0', '0', 'CDS1', '1', '0') AS DOOR,
  91. NVL(A.CBOX_TMPR, 0) AS CBOX_TMPR,
  92. A.UPDT_DT AS STS00,
  93. DECODE(A.PWER_STTS_CD, 'MOS0', '0', '1') AS STS01,
  94. DECODE(A.MODL_STTS_CD, 'MOS0', '0', '1') AS STS02,
  95. '0' AS STS03, '0' AS STS04, '0' AS STS05,
  96. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  97. FROM TB_VMS_CTLR_STTS A, TB_VMS_CTLR B
  98. WHERE A.VMS_CTLR_NMBR = B.VMS_CTLR_NMBR
  99. AND A.UPDT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS')
  100. UNION
  101. SELECT 'VDS' AS FAC_TYPE, B.VDS_CTLR_ID AS FAC_ID,
  102. CMNC_STTS_CD AS STTS_CD, CBOX_DOOR_STTS_CD AS DOOR_STTS_CD,
  103. DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '2') AS COMM,
  104. DECODE(CBOX_DOOR_STTS_CD, 'CDS0', '0', 'CDS1', '1', '0') AS DOOR,
  105. NVL(A.CBOX_TMPR, 0) AS CBOX_TMPR,
  106. A.UPDT_DT AS STS00,
  107. '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05,
  108. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  109. FROM TB_VDS_CTLR_STTS A, TB_VDS_CTLR B
  110. WHERE A.UPDT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS')
  111. AND A.VDS_CTLR_NMBR = B.VDS_CTLR_NMBR
  112. UNION
  113. SELECT 'DSRC' AS FAC_TYPE, B.RSE_ID AS FAC_ID,
  114. DECODE(CMNC_STTS, '0', 'CMS0', 'CMS1') AS STTS_CD,
  115. DECODE(CNTL_DEVC_STTS, '0', 'CDS0', '4', 'CDS0', 'CDS1') AS DOOR_STTS_CD,
  116. DECODE(CMNC_STTS, '0', '0', '1') AS COMM,
  117. '0' AS DOOR, 0 AS CBOX_TMPR,
  118. A.CLCT_DT AS STS00,
  119. '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05,
  120. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  121. FROM TB_RSE_STTS_PNST A, TB_RSE_MSTR B
  122. WHERE A.CLCT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS')
  123. AND A.ID = B.ID
  124. UNION
  125. SELECT 'CRSCAM' AS FAC_TYPE, A.CAM_ID AS FAC_ID,
  126. DECODE(A.STATUS, 1, 'CMS0', 'CMS1') AS STTS_CD,
  127. 'CDS0' AS DOOR_STTS_CD,
  128. DECODE(A.STATUS, 1, '0', '1') AS COMM,
  129. '0' AS DOOR, 0 AS CBOX_TMPR,
  130. TO_CHAR(A.CAP_DATE, 'YYYYMMDDHH24MISS') AS STS00,
  131. '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05,
  132. '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10
  133. FROM COL_CCAM_STATUS A
  134. WHERE A.CAP_DATE > SYSDATE - 10/1440