ITS_OP/RUN/Log/ITS_OP_29.err

[09:37:51] DB Error Occured. FILE: PRK0020MF.cpp LINE: 148 FUNC: TPRK0020M::RefreshData
Title: 주차현황조회
Class: EOleException
Error: 

TBR-08033 (42S02): Specified schema object was not found.   
at line 3, column 9 of null:
       TB_PRLT_RT_INFR B                     
       ^
SQL  :
SELECT A.PRLT_CTLR_ID, A.PRLT_NM, B.*       
  FROM TB_PRLT_CTLR    A,                   
       TB_PRLT_RT_INFR B                    
 WHERE A.REAL_DATA_YN   = 'Y'               
   AND A.PRLT_CTLR_NMBR = B.PRLT_CTLR_NMBR  
 ORDER BY A.PRLT_CTLR_NMBR, B.FLOR_NMBR     


[10:25:09] DB Error Occured. FILE: PRK0020MF.cpp LINE: 176 FUNC: TPRK0020M::RefreshData
Title: 주차장 실시간정보
Class: EOleException
Error: 

TBR-08008 (42000): Missing expression.   
at line 1, column 23 of null:
SELECT 0 as data_seq, , A.prk_plce_nmbr, A.prk_plce_manage_no, A.prk_plce_nm,   
                      ^
SQL  :
SELECT 0 as data_seq, , A.prk_plce_nmbr, A.prk_plce_manage_no, A.prk_plce_nm,              
       B.cmnc_stts_cd, DECODE(B.cmnc_stts_cd, 'CMS0', '정상', '이상') AS cmnc_stts_desc,   
       C.data_colct_time, '전체' AS flr_no,                                                
       C.parking_cgs_sttus,                                                                
       DECODE(C.parking_cgs_sttus, 0, '여유',                                              
                                   1, '보통',                                              
                                   2, '혼잡',                                              
                                   3, '만차',                                              
                                   '정보없음') AS parking_cgs_desc,                        
       C.prk_cmprt_co AS prk_cmprt_co,                                                     
       C.remndr_prk_cmprt_co AS remndr_prk_cmprt_co,                                       
       C.partclr_matter                                                                    
  FROM TB_PRK_PLCE A, TB_PRK_PLCE_STTS B,                                                  
       TB_PRK_PLCE_RT C                                                                    
 WHERE A.prk_plce_nmbr = B.prk_plce_nmbr                                                   
   AND A.prk_plce_nmbr = C.prk_plce_nmbr                                                   
UNION ALL                                                                                  
SELECT 1 as data_seq, A.prk_plce_nmbr, A.prk_plce_manage_no, A.prk_plce_nm,                
       B.cmnc_stts_cd, DECODE(B.cmnc_stts_cd, 'CMS0', '정상', '이상') AS cmnc_stts_desc,   
       C.data_colct_time, D.flr_no AS flr_no,                                              
       C.parking_cgs_sttus,                                                                
       DECODE(C.parking_cgs_sttus, 0, '여유',                                              
                                   1, '보통',                                              
                                   2, '혼잡',                                              
                                   3, '만차',                                              
                                   '정보없음') AS parking_cgs_desc,                        
       D.flr_prk_cmprt_co AS prk_cmprt_co,                                                 
       D.flr_remndr_prk_cmprt_co AS remndr_prk_cmprt_co,                                   
       C.partclr_matter                                                                    
  FROM TB_PRK_PLCE A, TB_PRK_PLCE_STTS B,                                                  
       TB_PRK_PLCE_RT C, TB_PRK_PLCE_FLR D                                                 
 WHERE A.prk_plce_nmbr = B.prk_plce_nmbr                                                   
   AND A.prk_plce_nmbr = C.prk_plce_nmbr                                                   
   AND A.prk_plce_nmbr = D.prk_plce_nmbr                                                   
 ORDER BY prk_plce_nmbr, data_seq, flr_no                                                  


[13:01:20] DB Error Occured. FILE: CDSPrltCtlrF.cpp LINE: 116 FUNC: TPrltCtlrManager::LoadFromDb
Title: TPrltCtlrManager::LoadFromDb
Class: EDatabaseError
Error: Field 'PRLT_CTLR_NMBR' not found
SQL  :
SELECT *                
  FROM TB_PRK_PLCE      
 WHERE pis_type != 'N'  
   AND del_yn    = 'N'  


[14:23:31] DB Error Occured. FILE: CDSPrltCtlrF.cpp LINE: 116 FUNC: TPrltCtlrManager::LoadFromDb
Title: TPrltCtlrManager::LoadFromDb
Class: EDatabaseError
Error: Field 'PRLT_CTLR_NMBR' not found
SQL  :
SELECT *                
  FROM TB_PRK_PLCE      
 WHERE pis_type != 'N'  
   AND del_yn    = 'N'  


[16:22:03] DB Error Occured. FILE: PRKH0101F.cpp LINE: 141 FUNC: TPRKH0101::SelHistory
Title: 주차장 실시간정보 이력
Class: Exception
Error: EDatabaseErrorADOQry: Field 'GNRL_RMND_PRZN_NUM' not found
SQL  :
SELECT A.prk_plce_nmbr, A.prk_plce_manage_no, A.prk_plce_nm, 
       H.*                                                   
  FROM TB_PRK_PLCE       A,                                  
       TB_PRK_PLCE_RT_HS H                                   
 WHERE A.prk_plce_nmbr IN('1','2','3','4','5','6')                   
   AND A.prk_plce_nmbr = H.prk_plce_nmbr                     
   AND H.CRTN_DT BETWEEN :p01 AND :p02