| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889 |
- [10:27:42] 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
|
