123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144 |
- [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
|