[16:55:41] DB Error Occured. FILE: CDSLinkF.cpp LINE: 477 FUNC: TItsLinkManager::LoadTraffic Title: TItsLinkManager::LoadTraffic Class: EOleException Error: ORA-03114: ORACLE에 연결되어 있지 않습니다 SQL : SELECT A.LINK_ID, PRCN_DT, TFVL, SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, MISS_YN, PRCN_SPED, SMTH_SPED, ADJS_SPED, PTRN_SPED, PRCN_SORC, ADJS_SORC, DATA_NUM, (CASE WHEN PRCN_DT <= TO_CHAR(SYSDATE - 10/1440, 'YYYYMMDDHH24MISS') THEN 'Y' ELSE 'N' END) AS MISSING, (CASE WHEN PRCN_DT >= TO_CHAR(SYSDATE - 15/1440, 'YYYYMMDDHH24MISS') THEN 'Y' ELSE 'N' END) AS LASTANS, (SELECT MAX(PRCN_DT) FROM TB_LINK_TRAF) MPRCN_DT FROM TB_LINK_TRAF A, TB_LINK B WHERE A.LINK_ID = B.LINK_ID [16:55:41] DB Error Occured. FILE: CDSIfscF.cpp LINE: 500 FUNC: TItsIfscManager::LoadTraffic Title: TItsIfscManager::LoadTraffic Class: EOleException Error: ORA-03114: ORACLE에 연결되어 있지 않습니다 SQL : SELECT A.IFSC_ID, PRCN_DT, TFVL, SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, PTRN_SPED, DATA_NUM, (CASE WHEN PRCN_DT <= TO_CHAR(SYSDATE - 10/1440, 'YYYYMMDDHH24MISS') THEN 'Y' ELSE 'N' END) AS MISSING, (CASE WHEN PRCN_DT >= TO_CHAR(SYSDATE - 15/1440, 'YYYYMMDDHH24MISS') THEN 'Y' ELSE 'N' END) AS LASTANS, (SELECT MAX(PRCN_DT) FROM TB_LINK_TRAF) MPRCN_DT FROM TB_IFSC_TRAF A, TB_IFSC B WHERE A.IFSC_ID = B.IFSC_ID [16:55:41] DB Error Occured. FILE: CDSRoadF.cpp LINE: 520 FUNC: TItsRoadManager::LoadTraffic Title: TItsRoadManager::LoadTraffic Class: EOleException Error: ORA-03114: ORACLE에 연결되어 있지 않습니다 SQL : SELECT A.ROAD_ID, PRCN_DT, TFVL, SPED, PTRN_SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, DATA_NUM, (CASE WHEN PRCN_DT <= TO_CHAR(SYSDATE - 10/1440, 'YYYYMMDDHH24MISS') THEN 'Y' ELSE 'N' END) AS MISSING, (CASE WHEN PRCN_DT >= TO_CHAR(SYSDATE - 15/1440, 'YYYYMMDDHH24MISS') THEN 'Y' ELSE 'N' END) AS LASTANS, (SELECT MAX(PRCN_DT) FROM TB_ROAD_TRAF) MPRCN_DT FROM TB_ROAD_TRAF A, TB_ROAD B WHERE A.ROAD_ID = B.ROAD_ID [16:55:41] DB Error Occured. FILE: CDSRepeatCongestF.cpp LINE: 97 FUNC: TItsRepeatCongestManager::LoadFromDb Title: TItsRepeatCongestManager::LoadFromDb Class: EOleException Error: ORA-03114: ORACLE에 연결되어 있지 않습니다 SQL : SELECT * FROM TB_REPT_CNGS_SECT [16:55:44] DB Error Occured. FILE: CDSFacilityF.cpp LINE: 1803 FUNC: TItsFacilityManager::LoadFacilityStatusFromDb Title: TItsFacilityManager::LoadFacilityStatusFromDb Class: EOleException Error: ORA-03114: ORACLE에 연결되어 있지 않습니다 SQL : SELECT '' AS FAC_TYPE, '' AS FAC_ID, '' AS STTS_CD, '' AS DOOR_STTS_CD, DECODE('', 'CMS0', '0', 'CMS1', '1', '2') AS COMM, DECODE('', 'CDS0', '0', 'CDS1', '1', '0') AS DOOR, NVL(NULL, 0) AS CBOX_TMPR, '' AS STS00, '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM DUAL WHERE 1 = 0 UNION SELECT 'CCTV' AS FAC_TYPE, B.CCTV_CTLR_ID AS FAC_ID, CMNC_STTS_CD AS STTS_CD, CBOX_DOOR_STTS_CD AS DOOR_STTS_CD, DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '2') AS COMM, DECODE(CBOX_DOOR_STTS_CD, 'CDS0', '0', 'CDS1', '1', '0') AS DOOR, NVL(A.CBOX_TMPR, 0) AS CBOX_TMPR, A.UPDT_DT AS STS00, '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM TB_CCTV_STTS A, TB_CCTV_CTLR B WHERE A.CCTV_MNGM_NMBR = B.CCTV_MNGM_NMBR AND UPDT_DT >= TO_CHAR(SYSDATE-10/1440, 'YYYYMMDDHH24MISS') UNION SELECT B.WCAM_TYPE_CD AS FAC_TYPE, B.WCAM_CTLR_ID AS FAC_ID, CMNC_STTS_CD AS STTS_CD, 'CDS0' AS DOOR_STTS_CD, DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '0') AS COMM, '0' AS DOOR, 0 AS CBOX_TMPR, A.UPDT_DT AS STS00, '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM TB_WCAM_CTLR_STTS A, TB_WCAM_CTLR B WHERE A.WCAM_CTLR_NMBR = B.WCAM_CTLR_NMBR AND A.UPDT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS') UNION SELECT 'VMS' AS FAC_TYPE, B.VMS_CTLR_ID AS FAC_ID, CMNC_STTS_CD AS STTS_CD, CBOX_DOOR_STTS_CD AS DOOR_STTS_CD, DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '2') AS COMM, DECODE(CBOX_DOOR_STTS_CD, 'CDS0', '0', 'CDS1', '1', '0') AS DOOR, NVL(A.CBOX_TMPR, 0) AS CBOX_TMPR, A.UPDT_DT AS STS00, DECODE(A.PWER_STTS_CD, 'MOS0', '0', '1') AS STS01, DECODE(A.MODL_STTS_CD, 'MOS0', '0', '1') AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM TB_VMS_CTLR_STTS A, TB_VMS_CTLR B WHERE A.VMS_CTLR_NMBR = B.VMS_CTLR_NMBR AND A.UPDT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS') UNION SELECT 'VDS' AS FAC_TYPE, B.VDS_CTLR_ID AS FAC_ID, CMNC_STTS_CD AS STTS_CD, CBOX_DOOR_STTS_CD AS DOOR_STTS_CD, DECODE(CMNC_STTS_CD, 'CMS0', '0', 'CMS1', '1', '2') AS COMM, DECODE(CBOX_DOOR_STTS_CD, 'CDS0', '0', 'CDS1', '1', '0') AS DOOR, NVL(A.CBOX_TMPR, 0) AS CBOX_TMPR, A.UPDT_DT AS STS00, '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM TB_VDS_CTLR_STTS A, TB_VDS_CTLR B WHERE A.UPDT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS') AND A.VDS_CTLR_NMBR = B.VDS_CTLR_NMBR UNION SELECT 'DSRC' AS FAC_TYPE, B.RSE_ID AS FAC_ID, DECODE(CMNC_STTS, '0', 'CMS0', 'CMS1') AS STTS_CD, DECODE(CNTL_DEVC_STTS, '0', 'CDS0', '4', 'CDS0', 'CDS1') AS DOOR_STTS_CD, DECODE(CMNC_STTS, '0', '0', '1') AS COMM, '0' AS DOOR, 0 AS CBOX_TMPR, A.CLCT_DT AS STS00, '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM TB_RSE_STTS_PNST A, TB_RSE_MSTR B WHERE A.CLCT_DT >= TO_CHAR(SYSDATE-5/1440, 'YYYYMMDDHH24MISS') AND A.ID = B.ID UNION SELECT 'CRSCAM' AS FAC_TYPE, A.CAM_ID AS FAC_ID, DECODE(A.STATUS, 1, 'CMS0', 'CMS1') AS STTS_CD, 'CDS0' AS DOOR_STTS_CD, DECODE(A.STATUS, 1, '0', '1') AS COMM, '0' AS DOOR, 0 AS CBOX_TMPR, TO_CHAR(A.CAP_DATE, 'YYYYMMDDHH24MISS') AS STS00, '0' AS STS01, '0' AS STS02, '0' AS STS03, '0' AS STS04, '0' AS STS05, '0' AS STS06, '0' AS STS07, '0' AS STS08, '0' AS STS09, '0' AS STS10 FROM COL_CCAM_STATUS A WHERE A.CAP_DATE > SYSDATE - 10/1440