VmsCommServer/RUN/Log/VMSCommServer_08.err

[15:03:06] [ERROR] MAIN Program terminated start
[15:13:25] [ERROR] MAIN LoadVmsFormObjectInfo Symbol Not Found: 6013
[15:13:28] [ERROR] MAIN LoadVmsFormObjectInfo Symbol Not Found: 6013
[15:44:42] [ERROR] MAIN Program terminated start
[15:44:45] [ERROR] MAIN Program terminated end
[16:11:01] [ERROR] +CLI Unknown client address: 192.168.20.93. will be closed.
[16:11:01] [ERROR] 192.168.20.93.2108, disconnected.
[16:11:30] [ERROR] +CLI Unknown client address: 192.168.20.93. will be closed.
[16:11:30] [ERROR] 192.168.20.93.2060, disconnected.
[16:11:47] [ERROR] MAIN Program terminated start
[16:11:49] [ERROR] MAIN Program terminated end
[16:13:59] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1796]
[16:14:03] [ERROR] 192.168.20.93.1796, VMS 0000001001 disconnected.
[16:14:03] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 722 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:14:03] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:14:03] [ERROR] Database job error: 4
[16:14:29] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1852]
[16:14:30] [ERROR] 192.168.20.93.1852, VMS 0000001001 disconnected.
[16:14:30] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 722 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:14:31] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:14:31] [ERROR] Database job error: 4
[16:15:28] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1712]
[16:15:32] [ERROR] 192.168.20.93.1712, VMS 0000001001 disconnected.
[16:15:32] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 722 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:15:32] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:15:32] [ERROR] Database job error: 4
[16:16:46] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1616]
[16:16:48] [ERROR] 192.168.20.93.1616, VMS 0000001001 disconnected.
[16:16:48] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 722 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:16:48] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:16:48] [ERROR] Database job error: 4
[16:17:53] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1800]
[16:18:34] [ERROR] 192.168.20.93.1800, VMS 0000001001 disconnected.
[16:25:59] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1832]
[16:26:06] [ERROR] 192.168.20.93.1832, VMS 0000001001 disconnected.
[16:26:06] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 730 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:26:06] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:26:06] [ERROR] Database job error: 4
[16:26:11] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1828]
[16:26:45] [ERROR] 192.168.20.93.1828, VMS 0000001001 disconnected.
[16:31:56] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1876]
[16:32:09] [ERROR] 192.168.20.93.1876, VMS 0000001001 disconnected.
[16:32:09] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 731 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:32:09] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:32:09] [ERROR] Database job error: 4
[16:32:49] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1832]
[16:34:16] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1768]
[16:38:37] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1820]
[16:38:41] [ERROR] 192.168.20.93.1820, VMS 0000001001 disconnected.
[16:38:51] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:38:51] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:38:51] [ERROR] Database job error: 4
[16:38:54] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1820]
[16:38:54] [ERROR] 192.168.20.93.1820, VMS 0000001001 disconnected.
[16:38:58] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:38:58] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:38:58] [ERROR] Database job error: 4
[16:39:13] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1824]
[16:39:13] [ERROR] 192.168.20.93.1824, VMS 0000001001 disconnected.
[16:39:34] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:39:34] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:39:34] [ERROR] Database job error: 4
[16:39:38] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1872]
[16:39:38] [ERROR] 192.168.20.93.1872, VMS 0000001001 disconnected.
[16:40:00] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:40:00] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:40:00] [ERROR] Database job error: 4
[16:41:02] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1744]
[16:41:02] [ERROR] 192.168.20.93.1744, VMS 0000001001 disconnected.
[16:41:05] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:41:05] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:41:05] [ERROR] Database job error: 4
[16:41:27] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1812]
[16:41:27] [ERROR] 192.168.20.93.1812, VMS 0000001001 disconnected.
[16:41:40] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:41:40] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:41:40] [ERROR] Database job error: 4
[16:42:21] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1816]
[16:42:21] [ERROR] 192.168.20.93.1816, VMS 0000001001 disconnected.
[16:43:19] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 732 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:43:19] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:43:19] [ERROR] Database job error: 4
[16:43:30] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1592]
[16:43:33] [ERROR] 192.168.20.93.1592, VMS 0000001001 disconnected.
[16:51:13] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1804]
[16:52:44] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1828]
[16:54:44] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1832]
[16:54:44] [ERROR] 192.168.20.93.1832, VMS 0000001001 disconnected.
[16:54:45] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1824]
[16:54:53] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 737 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:54:53] [ERROR] 192.168.20.93.1824, VMS 0000001001 disconnected.
[16:54:53] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:54:53] [ERROR] Database job error: 4
[16:55:01] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1832]
[16:55:17] [ERROR] 192.168.20.93.1832, VMS 0000001001 disconnected.
[16:55:21] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1544]
[16:55:23] [ERROR] 192.168.20.93.1544, VMS 0000001001 disconnected.
[16:55:27] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1820]
[16:55:27] [ERROR] 192.168.20.93.1820, VMS 0000001001 disconnected.
[16:55:29] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[912]
[16:55:29] [ERROR] 192.168.20.93.912, VMS 0000001001 disconnected.
[16:55:30] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1756]
[16:55:33] DB Error Occured. FILE: CDSCtlrF.cpp LINE: 737 FUNC: TCDSCtlrManager::SaveCtlrStts
Title: TCDSCtlrManager::SaveCtlrStts
Class: EOleException
Error: ORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
SQL  :
MERGE INTO TB_VMS_CTLR_STTS L                             
USING (SELECT :p01 AS VMS_CTLR_NMBR,                      
              :p02 AS UPDT_DT,                            
              :p03 AS CMNC_STTS_CD,                       
              :p04 AS PWER_STTS_CD,                       
              :p05 AS MODL_STTS_CD,                       
              :p06 AS CBOX_DOOR_STTS_CD,                  
              :p07 AS FAN_STTS_CD,                        
              :p08 AS HETR_STTS_CD,                       
              :p09 AS CBOX_TMPR,                          
              :p10 AS BRGH_VAL,                           
              :p11 AS COMM_STTS_CD,                       
              :p12 AS MODL_STTS,                          
              :p13 AS PWER_STTS                           
         FROM DUAL) M                                     
        ON (L.VMS_CTLR_NMBR = M.VMS_CTLR_NMBR)            
WHEN MATCHED THEN                                         
   UPDATE SET L.UPDT_DT           = M.UPDT_DT,            
              L.CMNC_STTS_CD      = M.CMNC_STTS_CD,       
              L.PWER_STTS_CD      = M.PWER_STTS_CD,       
              L.MODL_STTS_CD      = M.MODL_STTS_CD,       
              L.CBOX_DOOR_STTS_CD = M.CBOX_DOOR_STTS_CD,  
              L.FAN_STTS_CD       = M.FAN_STTS_CD,        
              L.HETR_STTS_CD      = M.HETR_STTS_CD,       
              L.CBOX_TMPR         = M.CBOX_TMPR,          
              L.BRGH_VAL          = M.BRGH_VAL,           
              L.COMM_STTS_CD      = M.COMM_STTS_CD,       
              L.MODL_STTS         = M.MODL_STTS,          
              L.PWER_STTS         = M.PWER_STTS           
WHEN NOT MATCHED THEN                                     
   INSERT (VMS_CTLR_NMBR,                                 
           UPDT_DT,                                       
           CMNC_STTS_CD,                                  
           PWER_STTS_CD,                                  
           MODL_STTS_CD,                                  
           CBOX_DOOR_STTS_CD,                             
           FAN_STTS_CD,                                   
           HETR_STTS_CD,                                  
           CBOX_TMPR,                                     
           BRGH_VAL,                                      
           COMM_STTS_CD,                                  
           MODL_STTS,                                     
           PWER_STTS )                                    
   VALUES (M.VMS_CTLR_NMBR,                               
           M.UPDT_DT,                                     
           M.CMNC_STTS_CD,                                
           M.PWER_STTS_CD,                                
           M.MODL_STTS_CD,                                
           M.CBOX_DOOR_STTS_CD,                           
           M.FAN_STTS_CD,                                 
           M.HETR_STTS_CD,                                
           M.CBOX_TMPR,                                   
           M.BRGH_VAL,                                    
           M.COMM_STTS_CD,                                
           M.MODL_STTS,                                   
           M.PWER_STTS )                                  


[16:55:33] [ERROR] 192.168.20.93.1756, VMS 0000001001 disconnected.
[16:55:33] [ERROR] DCOM TCDSCtlrManager::SaveCtlrSttsORA-00001: 무결성 제약 조건(PTATMS.PK_VMS_CTLR_STTS_HS)에 위배됩니다
[16:55:33] [ERROR] Database job error: 4
[16:59:05] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1596]
[16:59:05] [ERROR] 192.168.20.93.1596, VMS 0000001001 disconnected.
[16:59:07] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1624]
[16:59:07] [ERROR] 192.168.20.93.1624, VMS 0000001001 disconnected.
[16:59:07] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1660]
[16:59:07] [ERROR] 192.168.20.93.1660, VMS 0000001001 disconnected.
[16:59:08] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1644]
[16:59:08] [ERROR] 192.168.20.93.1644, VMS 0000001001 disconnected.
[16:59:09] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1724]
[16:59:10] [ERROR] 192.168.20.93.1724, VMS 0000001001 disconnected.
[16:59:10] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1596]
[16:59:10] [ERROR] 192.168.20.93.1596, VMS 0000001001 disconnected.
[16:59:11] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1720]
[16:59:11] [ERROR] 192.168.20.93.1720, VMS 0000001001 disconnected.
[16:59:12] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1652]
[16:59:12] [ERROR] 192.168.20.93.1652, VMS 0000001001 disconnected.
[17:16:26] [ERROR] +SVR Socket Select client OnClose: 192.168.20.93[1724]
[17:16:26] [ERROR] 192.168.20.93.1724, VMS 0000001001 disconnected.
[17:23:46] [ERROR] MAIN Program terminated start
[17:23:48] [ERROR] MAIN Program terminated end
[17:40:21] [ERROR] MAIN Program terminated start
[17:40:23] [ERROR] MAIN Program terminated end
[17:51:46] [ERROR] MAIN Program terminated start
[17:51:47] [ERROR] MAIN Program terminated end
[17:55:17] [ERROR] MAIN Program terminated start
[17:55:19] [ERROR] MAIN Program terminated end