[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