| 1234567891011121314151617181920212223242526272829303132333435363738394041 |
- [17:45:03] DB Error Occured. FILE: CDSWCamCtlrF.cpp LINE: 616 FUNC: TWCamCtlrManager::LoadPreSet
- Title: TWCamCtlrManager::LoadPreSet
- Class: EOleException
- Error: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다
- SQL :
- SELECT B.*
- FROM TB_WCAM_CTLR A,
- TB_WCAM_PSET B
- WHERE A.WCAM_CTLR_NMBR = B.WCAM_CTLR_NMBR
- ORDER BY B.WCAM_CTLR_NMBR, B.PSET_NMBR
- [17:45:19] DB Error Occured. FILE: EVSPH10MF.cpp LINE: 378 FUNC: TEVSPH10M::SelHistorySummary
- Title: 긴급차량 운영이력 [EVSPH10M]
- Class: Exception
- Error: EDatabaseErrorADOQry: Cannot perform this operation on a closed dataset
- SQL :
- SELECT A.SRVC_ID, A.EMRG_VHCL_ID, TO_CHAR(MIN(A.CLCT_DT), 'YYYY-MM-DD HH24:MI:SS') AS CLCT_DT,
- COUNT(1) AS DATA_CNT
- FROM EMRG_VHCL_OPER_HS A
- WHERE A.CLCT_DT BETWEEN TO_DATE(:p01, 'YYYYMMDDHH24MISS') AND TO_DATE(:p02, 'YYYYMMDDHH24MISS')
- GROUP BY A.SRVC_ID, A.EMRG_VHCL_ID
- ORDER BY MIN(A.CLCT_DT)
- [17:45:38] DB Error Occured. FILE: CDSSgnlCtlrF.cpp LINE: 82 FUNC: TSgnlCtlrManager::LoadFromDb
- Title: TSgnlCtlrManager::LoadFromDb
- Class: EOleException
- Error: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다
- SQL :
- SELECT A.SGNL_IXR_NMBR, A.X_CRDN/1000000 AS X_CRDN, A.Y_CRDN/1000000 AS Y_CRDN,
- B.IXR_NM AS IXR_NM,
- NVL(B.NODE_ID, 0) AS NODE_ID,
- NVL(B.CCTV_TYPE, 0) AS CCTV_TYPE,
- NVL(B.CCTV_NMBR, 0) AS CCTV_NMBR
- FROM SGNL_CTLR A
- LEFT OUTER JOIN SGNL_IXR_MNGM B
- ON A.SGNL_IXR_NMBR = B.SGNL_IXR_NMBR
- ORDER BY A.SGNL_IXR_NMBR
|
